sapcc / keppel

81%

master: 81%

LAST BUILD ON BRANCH optimize-db-queriesx

branch: optimize-db-queriesx

CHANGE BRANCH

x

Reset

• optimize-db-queriesx
• SubjectDigest
• account-deletion
• account-deletion-storage-sweep
• account-deletion-stuck
• account-validation-cel-expressions
• allow-reauth-on-anonymous-first-pull-error
• alternate-registry-api-authz
• anycast-support
• api-account-same-account-name
• authz-refactor
• autoupdateable-deps
• bring-repo-up-to-code
• bump-docker
• bye-docker-distribution
• cleanup-licneses
• conformance
• disable-trivy-telemetry
• drop_maintenance
• eager-manifest-handling
• expose-labels
• fix-account-deletion-storage-sweep
• fix-lints
• fix-new-lints
• fix-nolintlint
• fix-shellcheck
• fix-validate
• fix_modernize
• garbage-collection
• gc-delete-untagged
• golangcilint2
• graceful-server-termination
• health-ping
• image-spec
• keppel-vulnerability-status-changed-resource
• kubernetes-driver
• kubernetes-orchestrator
• layer-chunking
• list-repos-manifests-api
• master
• misc
• misc-stuff
• negative-rbac
• new-test-db-infrastructure
• not-rescan-rotten
• obfuscated-errors
• oci-db
• options-everywhere
• persist-trivy-reports
• platform-filter
• protect-subject-manifests
• quotas
• ratelimit
• rbac
• registry-api-audit-trail
• remove-bcrypt
• remove-registry-orchestration
• remove-trivy-dep
• renovate/actions-checkout-5.x
• renovate/external-dependencies
• renovate/github.com-opencontainers-distribution-spec-specs-go-digest
• renovate/github.comsapcc
• renovate/go-github.com-golang-jwt-jwt-v5-vulnerability
• renovate/go-github.com-redis-go-redis-v9-vulnerability
• renovate/go-golang.org-x-crypto-vulnerability
• renovate/major-external-dependencies
• replication-on-first-use
• secret-handling
• serve-persisted-trivy-reports
• storage-sweep
• support-tagpolicy-in-managed-accounts
• swift-federation-driver
• swift-storage-driver-test-coverage
• switch-peer-auth-to-sha256
• sync-manifests
• tag-policy
• token-caching
• track-manifest-references
• track-repos-and-tags
• trivial-storage-mutex
• trivy-swift-deletion
• typos
• validation-retry
• vuln_status_changed_at
• vulnerability-scanning

Build # 16442796818

Build Type

Pull #567

github

Committed by SuperSandro2000

Commit Message

Optimize for maia query in pgmetrics

This reduces overhaul cost by 7k points and execution time slightly by
20 to 30ms.

Before:
------------------------------------------+
| QUERY PLAN                                                                                                                                                                                           |
|------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|
| HashAggregate  (cost=24298.74..27654.96 rows=100373 width=80) (actual time=389.562..390.842 rows=3874 loops=1)                                                                                       |
|   Group Key: a.name, r.name, t.vuln_status                                                                                                                                                           |
|   Planned Partitions: 4  Batches: 1  Memory Usage: 2321kB                                                                                                                                            |
|   ->  Hash Join  (cost=151.38..18699.80 rows=100373 width=72) (actual time=1.568..338.989 rows=100264 loops=1)                                                                                       |
|         Hash Cond: (r.account_name = a.name)                                                                                                                                                         |
|         ->  Hash Join  (cost=129.59..18407.90 rows=100373 width=39) (actual time=1.430..311.364 rows=100264 loops=1)                                                                                 |
|               Hash Cond: (t.repo_id = r.id)                                                                                                                                                          |
| ... (continued)

Pull Request Pull Request #567: Optimize for maia query in pgmetrics

Run Details

7753 of 9574 relevant lines covered (80.98%)

165.74 hits per line