cybertec-postgresql / pgwatch

64%

master: 71%

LAST BUILD ON BRANCH 786_optimize_pgsink_maintenance

branch: 786_optimize_pgsink_maintenance

CHANGE BRANCH

x

Reset

Sync Branches

• 786_optimize_pgsink_maintenance
• 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
• 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
• 961-fix-dashboard-links
• 962-fix-patroni-resolver
• 968_fix_nil_map_access
• 981-fix-bitnami-hub
• 990-fix-patroni-resolving
• 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-patroni-docker-compose
• add-pg18-support
• add-query-performance-pg-dashboard
• add-source-conn
• add-source-resolve
• add-sources-runtime-info
• add-syncreq-to-api
• add-systemd-service-template
• add-tables-overview-pg-dashboard
• add-test-for-metrics-folder
• add-tls-to-grpc
• add-web-disable-cmdopt
• add-webserver-tests
• add-written-log-to-rpc
• add-yamls-to-release-assets
• align-webui-grids
• api-consts
• bump-go-1.23
• bump-go-v1.24
• bump-grafana-10.4.15
• bump-jwt
• bump-logo-panel
• bump-mui-data-grid-to-v7
• bump-nodejs
• bump-react-scripts
• bump-testcontainers
• bump_go_1.25
• cmd-metric-tests
• concurrent-metric-defs
• const-sync-operations
• convert-metric-tests
• dependabot/github_actions/actions/checkout-5
• dependabot/github_actions/actions/download-artifact-5
• dependabot/github_actions/actions/download-artifact-6
• 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/golangci/golangci-lint-action-7
• dependabot/github_actions/golangci/golangci-lint-action-8
• 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/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/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.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/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/modules/etcd-0.39.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/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/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/golang.org/x/crypto-0.31.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/protobuf-1.36.10
• 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/axios-1.12.0
• 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/nanoid-3.3.8
• 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-realtime-metrics
• deprecate_db_stats_aurora
• disable-web-ui
• docker-compose-readme
• docker-compose-tweaks
• docker-demo-tweaks
• docker-restructure
• docs-devel-gha
• docs-versioning
• duplicate-yaml-sources-fix
• enhance-db-overview-pg-dashboard
• fallback-logger
• fetch-metric
• fix-JSONWriter
• fix-LogParse
• fix-archives.format_overrides.format-option
• fix-batching-delay
• 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-grafana-v11-datasource
• fix-hardcoded-epoch-consts
• fix-last-recovery-check
• fix-logger-fields-usage
• fix-logparse-log
• fix-max-parellel-cons-per-db
• fix-metric-init
• fix-metrics-dir-logic
• fix-mindbsize-handling
• fix-non-latin-field
• fix-package-name
• fix-pg_stat_file-dependencies
• fix-pgsrc-rm
• fix-prometheus-sink-init
• fix-reapMetricMeasurements
• fix-source-ping
• fix-source-yaml-test
• fix-src-equal
• fix-typo
• fix-update-srcs
• 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-top-tables-pg-fix-null-handling
• grafana-v12
• grafana-v12-p2
• grafana-v12-p3
• hyd/enable-postgres-partition-interval
• hyd/introduce-detaching-for-postgresql
• improve-dev-compose
• improve-docker-compose
• improve-docker-gha
• improve-memory-usage
• improve_change_events_metric
• instance-metric-cache
• json-sink
• jsonb-issue
• linter-nilness
• master
• metrics-sync
• migrate-rpc-sink-to-grpc
• misc-minor-update-to-docs
• move-psutil-to-reaper
• move-src-sync-to-reaper
• move-v10-dashboards-to-contrib
• optimize-MeasurementEnvelope
• packages-docs
• patch-1
• pg17-checkpoint-metrics
• pgbouncer-dashboard
• prevent-concurrent-map-rw
• prometheus-grafana-v11-dashboard-fixes
• refactor-FetchMetrics
• refactor-ParseLogs
• refactor-TryCreateMetricsFetchingHelpers
• refactor-cmd-config
• refactor-db-pkg
• refactor-object-changes-tracking
• refactor-recommendations
• refactor/update_syncmetric
• refactor_reaper
• remove-metricdef-from-measurement
• remove-metrics-from-pg-sink
• remove-reaper-consts
• remove-source-issuperuser
• remove-undersized-map
• remove_host_config
• rename-batching-delay
• renormalize
• replace-configmap-arg
• rest-compliant-entpoints
• rest-path-value
• rewmove-unreachable-map
• rm-host-cfg
• sources-conn-tests
• tls-client
• uid
• update-v12-dashboards-gallery
• v3-docs
• v4

Build # 16646463238

Build Type

Pull #861

github

Committed by web-flow

Commit Message

Merge 2d73d130f into bfad57ae2

Pull Request Pull Request #861: [*] optimize maintenance tasks in Postgres sink, closes #786

Run Details

2 of 45 new or added lines in 1 file covered. (4.44%)

1 existing line in 1 file now uncovered.

3188 of 5019 relevant lines covered (63.52%)

0.72 hits per line