cybertec-postgresql / pgwatch

78%

master: 78%

LAST BUILD ON BRANCH bugfix/global-db-overview-queryLogic

branch: bugfix/global-db-overview-queryLogic

CHANGE BRANCH

x

Reset

Sync Branches

• bugfix/global-db-overview-queryLogic
• 1049-add-web-base-path
• 1050-sort-presets-with-desc
• 1110-apply-postgres-sink-schema-migrations
• 1114-fix-upgrade
• 1156-fix-config-upgrade
• 1158-fix-instance_up
• 1198-fix-yaml-race-conditions
• 512-add-arm64-binaries
• 518-restructure-code-tree
• 524-pgwatch3-ui-not-working
• 526-fix-webui-remote-host
• 532-fix-update-metrics-in-postgres
• 547-metric-docs
• 553-fix-docker-demo
• 554-fix-postgres-resolver
• 557-replace-no-helper-functions-with-create-helpers-command-line-option
• 562_fix_docker_demo
• 567-howto_metrics_db_bootstrap
• 594-sources-are-not-updated-from-config
• 611-add-readiness-liveness-endpoints
• 612-masking-passwords-in-pgwatch-logs
• 622-ensure-partition-metric-time-error
• 625-pgbouncer-could-not-init-connection
• 644-fix-update-metric
• 649-fix-edb
• 664-fix-db-config-add-metric
• 675-fix-postgres-discovery-for-quoted-names
• 730-fix-pgpool
• 749-fix-prometheus-scrapping
• 756-m-option-cannot-use-directory-path
• 759-fix-instance-up-metric
• 764_improve_reco_metrics
• 766-nil-pointer-dereference
• 786-detach-deleted-partitions
• 786_optimize_pgsink_maintenance
• 792-add-default-group
• 792-fix-group-cmdopts
• 821-improve-batching-delay-description
• 843-fix-no-groups
• 879-fix-docker-compose-docs
• 890-unblock-db-resolve
• 908-panic-copy-postgres-sink
• 958-retention-as-interval
• 958-variable-partition-intervals
• 961-fix-dashboard-links
• 962-fix-patroni-resolver
• 968_fix_nil_map_access
• 981-fix-bitnami-hub
• 990-fix-patroni-resolving
• 994-maintenance-interval
• 997-resolver-log-typo
• add-QueryMeasurements
• add-basic-auth-to-grpc-sink
• add-cmd-pgwatch-tests
• add-config-commands
• add-dir-add-update-logic
• add-docker-compose-pg-replication
• add-etcd-resolver-tests
• add-grafana-prometheus-dashboards
• add-greanteagc
• add-maintain_unique_sources-to-pg-sink
• add-metric-list-command
• add-patroni-docker-compose
• add-pg-sink-migration
• add-pg18-support
• add-prometheus-unit-tests
• add-query-performance-pg-dashboard
• add-source-conn
• add-source-name-rule
• add-source-resolve
• add-sources-runtime-info
• add-stat-statements-jit-metric
• add-syncreq-to-api
• add-systemd-service-template
• add-tables-overview-pg-dashboard
• add-test-for-metrics-folder
• add-tls-to-grpc
• add-total-index-size-panel
• add-web-disable-cmdopt
• add-webserver-tests
• add-written-log-to-rpc
• add-yamls-to-release-assets
• ai-policy
• align-webui-grids
• api-consts
• apply-min-retention
• bad_pg_dashboards_path_demo
• bug
• bugfix/datarace-monitoredsources
• bugfix/recourse-leak
• bump-Go-v1.26
• bump-docker-postgres-image-to-v18
• bump-go-1.23
• bump-go-v1.24
• bump-grafana-10.4.15
• bump-grafana-v12.3
• bump-jwt
• bump-logo-panel
• bump-mui-data-grid-to-v7
• bump-nodejs
• bump-react-scripts
• bump-testcontainers
• bump-to-v5
• bump-webui-core
• bump_go_1.25
• check-privilege-before-local-parsing
• claude/postgres-lock-timeout-config-01CV6RHcoPstQMGhREGnNE8r
• cmd-metric-tests
• concurrent-metric-defs
• const-sync-operations
• convert-metric-tests
• delete-dropped-tables-from-listing-table
• dependabot/github_actions/actions/cache-5
• dependabot/github_actions/actions/checkout-5
• dependabot/github_actions/actions/checkout-6
• dependabot/github_actions/actions/download-artifact-5
• dependabot/github_actions/actions/download-artifact-6
• dependabot/github_actions/actions/download-artifact-7
• dependabot/github_actions/actions/setup-go-6
• dependabot/github_actions/actions/setup-node-5
• dependabot/github_actions/actions/setup-node-6
• dependabot/github_actions/actions/setup-python-6
• dependabot/github_actions/actions/stale-10
• dependabot/github_actions/actions/upload-artifact-5
• dependabot/github_actions/actions/upload-artifact-6
• dependabot/github_actions/golangci/golangci-lint-action-7
• dependabot/github_actions/golangci/golangci-lint-action-8
• dependabot/github_actions/golangci/golangci-lint-action-9
• dependabot/github_actions/goreleaser/goreleaser-action-7
• dependabot/go_modules/github.com/cybertec-postgresql/pgx-migrator-1.1.0
• dependabot/go_modules/github.com/cybertec-postgresql/pgx-migrator-1.2.0
• dependabot/go_modules/github.com/docker/docker-28.3.3incompatible
• dependabot/go_modules/github.com/golang-jwt/jwt/v5-5.3.0
• dependabot/go_modules/github.com/golang-jwt/jwt/v5-5.3.1
• dependabot/go_modules/github.com/jackc/pgx/v5-5.7.0
• dependabot/go_modules/github.com/jackc/pgx/v5-5.7.1
• dependabot/go_modules/github.com/jackc/pgx/v5-5.7.2
• dependabot/go_modules/github.com/jackc/pgx/v5-5.7.3
• dependabot/go_modules/github.com/jackc/pgx/v5-5.7.4
• dependabot/go_modules/github.com/jackc/pgx/v5-5.7.5
• dependabot/go_modules/github.com/jackc/pgx/v5-5.7.6
• dependabot/go_modules/github.com/jackc/pgx/v5-5.8.0
• dependabot/go_modules/github.com/pashagolub/pgxmock/v4-4.3.0
• dependabot/go_modules/github.com/pashagolub/pgxmock/v4-4.5.0
• dependabot/go_modules/github.com/pashagolub/pgxmock/v4-4.6.0
• dependabot/go_modules/github.com/pashagolub/pgxmock/v4-4.7.0
• dependabot/go_modules/github.com/pashagolub/pgxmock/v4-4.8.0
• dependabot/go_modules/github.com/pashagolub/pgxmock/v4-4.9.0
• dependabot/go_modules/github.com/prometheus/client_golang-1.20.3
• dependabot/go_modules/github.com/prometheus/client_golang-1.20.4
• dependabot/go_modules/github.com/prometheus/client_golang-1.20.5
• dependabot/go_modules/github.com/prometheus/client_golang-1.21.0
• dependabot/go_modules/github.com/prometheus/client_golang-1.21.1
• dependabot/go_modules/github.com/prometheus/client_golang-1.22.0
• dependabot/go_modules/github.com/prometheus/client_golang-1.23.0
• dependabot/go_modules/github.com/prometheus/client_golang-1.23.1
• dependabot/go_modules/github.com/prometheus/client_golang-1.23.2
• dependabot/go_modules/github.com/shirou/gopsutil/v4-4.24.10
• dependabot/go_modules/github.com/shirou/gopsutil/v4-4.24.11
• dependabot/go_modules/github.com/shirou/gopsutil/v4-4.24.12
• dependabot/go_modules/github.com/shirou/gopsutil/v4-4.24.8
• dependabot/go_modules/github.com/shirou/gopsutil/v4-4.24.9
• dependabot/go_modules/github.com/shirou/gopsutil/v4-4.25.1
• dependabot/go_modules/github.com/shirou/gopsutil/v4-4.25.10
• dependabot/go_modules/github.com/shirou/gopsutil/v4-4.25.11
• dependabot/go_modules/github.com/shirou/gopsutil/v4-4.25.12
• dependabot/go_modules/github.com/shirou/gopsutil/v4-4.25.2
• dependabot/go_modules/github.com/shirou/gopsutil/v4-4.25.3
• dependabot/go_modules/github.com/shirou/gopsutil/v4-4.25.4
• dependabot/go_modules/github.com/shirou/gopsutil/v4-4.25.5
• dependabot/go_modules/github.com/shirou/gopsutil/v4-4.25.6
• dependabot/go_modules/github.com/shirou/gopsutil/v4-4.25.7
• dependabot/go_modules/github.com/shirou/gopsutil/v4-4.25.8
• dependabot/go_modules/github.com/shirou/gopsutil/v4-4.25.9
• dependabot/go_modules/github.com/shirou/gopsutil/v4-4.26.1
• dependabot/go_modules/github.com/sirupsen/logrus-1.9.4
• dependabot/go_modules/github.com/stretchr/testify-1.10.0
• dependabot/go_modules/github.com/stretchr/testify-1.11.0
• dependabot/go_modules/github.com/stretchr/testify-1.11.1
• dependabot/go_modules/github.com/testcontainers/testcontainers-go-0.34.0
• dependabot/go_modules/github.com/testcontainers/testcontainers-go-0.35.0
• dependabot/go_modules/github.com/testcontainers/testcontainers-go-0.36.0
• dependabot/go_modules/github.com/testcontainers/testcontainers-go-0.37.0
• dependabot/go_modules/github.com/testcontainers/testcontainers-go-0.38.0
• dependabot/go_modules/github.com/testcontainers/testcontainers-go-0.39.0
• dependabot/go_modules/github.com/testcontainers/testcontainers-go-0.40.0
• dependabot/go_modules/github.com/testcontainers/testcontainers-go/modules/etcd-0.39.0
• dependabot/go_modules/github.com/testcontainers/testcontainers-go/modules/etcd-0.40.0
• dependabot/go_modules/github.com/testcontainers/testcontainers-go/modules/postgres-0.34.0
• dependabot/go_modules/github.com/testcontainers/testcontainers-go/modules/postgres-0.35.0
• dependabot/go_modules/github.com/testcontainers/testcontainers-go/modules/postgres-0.36.0
• dependabot/go_modules/github.com/testcontainers/testcontainers-go/modules/postgres-0.37.0
• dependabot/go_modules/github.com/testcontainers/testcontainers-go/modules/postgres-0.38.0
• dependabot/go_modules/github.com/testcontainers/testcontainers-go/modules/postgres-0.39.0
• dependabot/go_modules/github.com/testcontainers/testcontainers-go/modules/postgres-0.40.0
• dependabot/go_modules/go.etcd.io/etcd/client/v3-3.5.16
• dependabot/go_modules/go.etcd.io/etcd/client/v3-3.5.17
• dependabot/go_modules/go.etcd.io/etcd/client/v3-3.5.18
• dependabot/go_modules/go.etcd.io/etcd/client/v3-3.5.19
• dependabot/go_modules/go.etcd.io/etcd/client/v3-3.5.20
• dependabot/go_modules/go.etcd.io/etcd/client/v3-3.5.21
• dependabot/go_modules/go.etcd.io/etcd/client/v3-3.6.0
• dependabot/go_modules/go.etcd.io/etcd/client/v3-3.6.1
• dependabot/go_modules/go.etcd.io/etcd/client/v3-3.6.2
• dependabot/go_modules/go.etcd.io/etcd/client/v3-3.6.3
• dependabot/go_modules/go.etcd.io/etcd/client/v3-3.6.4
• dependabot/go_modules/go.etcd.io/etcd/client/v3-3.6.5
• dependabot/go_modules/go.etcd.io/etcd/client/v3-3.6.6
• dependabot/go_modules/go.etcd.io/etcd/client/v3-3.6.7
• dependabot/go_modules/go.etcd.io/etcd/client/v3-3.6.8
• dependabot/go_modules/go.etcd.io/etcd/server/v3-3.6.0
• dependabot/go_modules/go.etcd.io/etcd/server/v3-3.6.1
• dependabot/go_modules/go.etcd.io/etcd/server/v3-3.6.2
• dependabot/go_modules/go.etcd.io/etcd/server/v3-3.6.3
• dependabot/go_modules/go.uber.org/zap-1.27.1
• dependabot/go_modules/golang.org/x/crypto-0.31.0
• dependabot/go_modules/golang.org/x/crypto-0.45.0
• dependabot/go_modules/google.golang.org/grpc-1.74.2
• dependabot/go_modules/google.golang.org/grpc-1.75.0
• dependabot/go_modules/google.golang.org/grpc-1.75.1
• dependabot/go_modules/google.golang.org/grpc-1.76.0
• dependabot/go_modules/google.golang.org/grpc-1.77.0
• dependabot/go_modules/google.golang.org/grpc-1.78.0
• dependabot/go_modules/google.golang.org/grpc-1.79.0
• dependabot/go_modules/google.golang.org/grpc-1.79.1
• dependabot/go_modules/google.golang.org/protobuf-1.36.10
• dependabot/go_modules/google.golang.org/protobuf-1.36.11
• dependabot/go_modules/google.golang.org/protobuf-1.36.7
• dependabot/go_modules/google.golang.org/protobuf-1.36.8
• dependabot/go_modules/google.golang.org/protobuf-1.36.9
• dependabot/go_modules/src/github.com/prometheus/client_golang-1.20.1
• dependabot/go_modules/src/github.com/prometheus/client_golang-1.20.2
• dependabot/go_modules/src/github.com/testcontainers/testcontainers-go-0.33.0
• dependabot/go_modules/src/github.com/testcontainers/testcontainers-go/modules/postgres-0.33.0
• dependabot/npm_and_yarn/internal/webui/ajv-6.14.0
• dependabot/npm_and_yarn/internal/webui/axios-1.12.0
• dependabot/npm_and_yarn/internal/webui/axios-1.13.5
• dependabot/npm_and_yarn/internal/webui/axios-1.7.4
• dependabot/npm_and_yarn/internal/webui/axios-1.8.2
• dependabot/npm_and_yarn/internal/webui/babel/helpers-7.26.10
• dependabot/npm_and_yarn/internal/webui/babel/runtime-7.26.10
• dependabot/npm_and_yarn/internal/webui/cross-spawn-7.0.6
• dependabot/npm_and_yarn/internal/webui/express-4.21.0
• dependabot/npm_and_yarn/internal/webui/http-proxy-middleware-2.0.7
• dependabot/npm_and_yarn/internal/webui/http-proxy-middleware-2.0.9
• dependabot/npm_and_yarn/internal/webui/lodash-4.17.23
• dependabot/npm_and_yarn/internal/webui/nanoid-3.3.8
• dependabot/npm_and_yarn/internal/webui/node-forge-1.3.2
• dependabot/npm_and_yarn/internal/webui/rollup-2.79.2
• dependabot/npm_and_yarn/internal/webui/webpack-5.94.0
• dependabot/npm_and_yarn/src/webui/micromatch-4.0.8
• deprecate-direct-os-stats
• deprecate-realtime-metrics
• deprecate-stat-stmt-panels
• deprecate_db_stats_aurora
• disable-web-ui
• docker-compose-readme
• docker-compose-tweaks
• docker-demo-tweaks
• docker-restructure
• docs-devel-gha
• docs-versioning
• drop-v13-sqls
• duplicate-yaml-sources-fix
• enhance-db-overview-pg-dashboard
• enhance-metric-form
• fallback-logger
• feat/add-single-query-details-prometheus-dashboard
• feat/query-linking-query-perf-analysis
• feature/metrics-sqls-ui
• fetch-metric
• fix-JSONWriter
• fix-LogParse
• fix-archives.format_overrides.format-option
• fix-batching-delay
• fix-bugs
• fix-collect-data-race
• fix-config-upgrade-loop
• fix-dashboards-missing-cybertec-panel
• fix-datasource-id-prom-dashboards
• fix-dbsourcereaderwriter-updatedatabase
• fix-define-metrics-err-msg
• fix-docker-names
• fix-docker-volume
• fix-docs
• fix-duplicated-dlopen-darwin
• fix-ensure-partition-postgres
• fix-expand-env-vars
• fix-grafana-v11-datasource
• fix-hardcoded-epoch-consts
• fix-health-check-dashboard
• fix-last-recovery-check
• fix-log-message
• fix-log-parser
• fix-logger-fields-usage
• fix-login-handler
• fix-logparse-log
• fix-max-parellel-cons-per-db
• fix-metric-init
• fix-metrics-dir-logic
• fix-mindbsize-handling
• fix-non-latin-field
• fix-overly-long-qrs-panel
• fix-package-name
• fix-partition-precreation
• fix-pg-v11-dashboards
• fix-pg_stat_file-dependencies
• fix-pgsrc-rm
• fix-preset-sorting
• fix-prometheus-gauges-race
• fix-prometheus-lazy-init
• fix-prometheus-sink-init
• fix-query-perf-dashboard
• fix-query-perf-prom-dash
• fix-reapMetricMeasurements
• fix-revive-var-naming
• fix-schedule-job
• fix-shared-bf-hits-panel
• fix-sink-only-upgrade-1114
• fix-sink-upgrade-warn
• fix-source-ping
• fix-source-yaml-test
• fix-src-equal
• fix-src-update-logic
• fix-stat-statements-metric
• fix-table-details-dashboard
• fix-typo
• fix-update-srcs
• fix-webui-password-hide
• fix/local-logparser-resume-offsets
• fix/log-parser-offset-tracking-1089
• fix/postgres-writer-deadlock-1212
• fix/preset-order
• fix/remove-redundant-source-name-issue-1134
• fix/stat-activity-query
• fix_default_dashboard_path
• fix_patroni_etcd
• fixture/fix-pg-null-errors-on-grafana-dashboards
• fixture/support-podman
• fixture/update-stat-statements-dashboards-on-postgresql-v11
• global-db-overview-v12-postgres
• grafana-12
• grafana-prom-health-check-add-wal-archiving-status
• grafana-top-tables-pg-fix-null-handling
• grafana-v12
• grafana-v12-p2
• grafana-v12-p3
• handle-metric-interval-update
• handle-sink-schemas
• hyd/enable-postgres-partition-interval
• hyd/introduce-detaching-for-postgresql
• improve-dev-compose
• improve-docker-compose
• improve-docker-gha
• improve-index-dashboard
• improve-index-overview-dashboard
• improve-index-overview-dashboard-2
• improve-memory-usage
• improve-query-perf-prom-dash
• improve-reco-add-index
• improve-vacuum-panels
• improve-webui
• improve_change_events_metric
• imprv-qry-perf-dshbrd
• instance-metric-cache
• json-sink
• jsonb-issue
• linter-nilness
• make-maintenance-in-plpgsql
• master
• mention-demo-site
• metrics-sync
• migrate-all-helpers-to-testutil
• migrate-rpc-sink-to-grpc
• migrate-webui-vite
• misc-minor-update-to-docs
• monitor-btree-bloat
• move-ext-helpers-creation-to-sources
• move-psutil-to-reaper
• move-src-sync-to-reaper
• move-v10-dashboards-to-contrib
• optimize-MeasurementEnvelope
• packages-docs
• parse-remote-logs
• patch-1
• pg17-checkpoint-metrics
• pgbouncer-dashboard
• prevent-concurrent-map-rw
• prom-dashboards/index-bloat
• prometheus-grafana-v11-dashboard-fixes
• refactor-FetchMetrics
• refactor-ParseLogs
• refactor-TryCreateMetricsFetchingHelpers
• refactor-TryCreateMissingExtensions
• refactor-cmd-config
• refactor-db-pkg
• refactor-object-changes-tracking
• refactor-prometheus-cache-to-struct
• refactor-reco-drop-index-metric
• refactor-recommendations
• refactor/update_syncmetric
• refactor_reaper
• remove-default-group
• remove-deprecated-db-types
• remove-metricdef-from-measurement
• remove-metrics-from-pg-sink
• remove-reaper-consts
• remove-source-issuperuser
• remove-undersized-map
• remove_host_config
• remove_source_name
• rename-batching-delay
• renormalize
• reorder-health-check-panel
• replace-configmap-arg
• rest-compliant-entpoints
• rest-path-value
• rewmove-unreachable-map
• rm-host-cfg
• sources-conn-tests
• sql_text_data_source
• testcoverage_reaper
• testing
• tls-client
• uid
• update-migration-01180
• update-readme
• update-test-main
• update-v12-dashboards-gallery
• use-testutil-in-main-integration-test
• v3-docs
• v4

Build # 22555991544

Build Type

Pull #1239

github

Committed by web-flow

Commit Message

Merge 91fdabc21 into b11ec15f8

Pull Request Pull Request #1239: [*] Fix `global-db-overview` query logic, fixes #1152

Run Details

4318 of 5526 relevant lines covered (78.14%)

0.89 hits per line