PostgreSQL metrics monitor/dashboard
[!]
bump Go to v1.21 by @pashagolub in #729[!]
update "Biggest relations treemap" dashboard plugin, fixes #579 #496 #293 #197 by @pashagolub in #727[+]
add sent_lag
and confirmed_flush_lsn_lag
fields to replication metrics by @bukem in #700[+]
add new metrics for invalid and unused indexes by @kmoppel-cognite in #691[+]
bump actions/checkout
from 3 to 4 by @dependabot in #680[+]
bump actions/setup-go
from 4 to 5 by @dependabot in #721[+]
bump actions/stale
from 8 to 9 by @dependabot in #723[+]
bump docker/setup-buildx-action
from 2 to 3 by @dependabot in #684[+]
bump docker/setup-qemu-action
from 2 to 3 by @dependabot in #683[+]
bump github/codeql-action
from 2 to 3 by @dependabot in #724[+]
bump go.etcd.io/etcd/client/v2
from 2.305.9 to 2.305.11 by @dependabot in #704 #722[+]
bump golang.org/x/crypto
from 0.12.0 to 0.17.0 by @dependabot in #681 #697 #708 #715 #726[+]
bump goreleaser/goreleaser-action
from 4 to 5 by @dependabot in #685[+]
bump hashicorp/consul/api
from 1.24.0 to 1.26.1 by @dependabot in #686 #688 #706[+]
bump prometheus/client_golang
from 1.16.0 to 1.18.0 by @dependabot in #692 #728[+]
bump shirou/gopsutil/v3
from 3.23.7 to 3.23.11 by @dependabot in #678 #693 #705 #718Full Changelog: https://github.com/cybertec-postgresql/pgwatch2/compare/v1.11.0...v1.12.0
[!]
bump PostgreSQL to v15, Grafana to v8.5.20, Go to v1.20 in Docker images by @pashagolub in https://github.com/cybertec-postgresql/pgwatch2/pull/601
[!]
add metrics for PostgreSQL 16 by @kmoppel-cognite in https://github.com/cybertec-postgresql/pgwatch2/pull/669
[+]
add support for Goreleaser v1.20 by @pashagolub in #676[+]
update README.md to show support of PG15 by @kdaveid in https://github.com/cybertec-postgresql/pgwatch2/pull/664
[+]
bump Go to v1.20 by @pashagolub in https://github.com/cybertec-postgresql/pgwatch2/pull/605
[+]
bump shirou/gopsutil/v3
from 3.22.12 to 3.23.7 by @dependabot in #667 #662 #648 #635 #615 #593[+]
bump prometheus/client_golang
from 1.14.0 to 1.16.0 by @dependabot in #654 #636 #627[+]
bump lib/pq
from 1.10.7 to 1.10.9 by @dependabot in #633 #628[+]
bump hashicorp/consul/api
from 1.18.0 to 1.24.0 by @dependabot in #670 #666 #661 #651 #617 #609[+]
bump golang.org/x/crypto
from 0.5.0 to 0.12.0 by @dependabot in #671 #663 #653 #638 #624 #616 #596[+]
bump go.etcd.io/etcd/client/v2
from 2.305.7 to 2.305.9 by @dependabot in #640 #626 #591[+]
bump actions/stale
from 7 to 8 by @dependabot in https://github.com/cybertec-postgresql/pgwatch2/pull/619
[+]
bump actions/setup-go
from 3 to 4 by @dependabot in https://github.com/cybertec-postgresql/pgwatch2/pull/618
[+]
allow to specify multi-host connection string for configDB
with target_session_attrs
by @krisavi in https://github.com/cybertec-postgresql/pgwatch2/pull/647
[+]
allow .pgpass
lookup for web UI by @krisavi in https://github.com/cybertec-postgresql/pgwatch2/pull/646
[+]
add lag in milliseconds to replication metrics by @kmoppel-cognite in https://github.com/cybertec-postgresql/pgwatch2/pull/607
[+]
add Docker GHA workflow to update "latest" images, closes #602 by @pashagolub in https://github.com/cybertec-postgresql/pgwatch2/pull/603
[+]
add "prerequisite extensions" support for metric definitions by @kmoppel-cognite in https://github.com/cybertec-postgresql/pgwatch2/pull/643
[*]
fix cert_key
to key_file
on host_config
by @krisavi in https://github.com/cybertec-postgresql/pgwatch2/pull/608
[-]
fix timeline ID conversion in wal
metric from hexadecimal to decimal by @slardiere in https://github.com/cybertec-postgresql/pgwatch2/pull/604
[-]
fix invalid target_session_attrs
value in WebUI URI, fixes #674 by @pashagolub in https://github.com/cybertec-postgresql/pgwatch2/pull/675
[-]
fix helm chart affinity
, toleration
, nodeSelector
and extraVolumes
for daemon container by @pmpetit in https://github.com/cybertec-postgresql/pgwatch2/pull/631
[-]
fix grafana v8 invalid url parameter panelId
with new viewPanel
by @FireEmerald in https://github.com/cybertec-postgresql/pgwatch2/pull/620
[-]
fix dashboard typos by @AlicjaKucharczyk in https://github.com/cybertec-postgresql/pgwatch2/pull/668
[-]
fix connection string parsing for postgres-continuous-discovery, closes #584 by @chromko in https://github.com/cybertec-postgresql/pgwatch2/pull/585
[-]
fix pgwatch2-postgres
Docker image by @frastr in https://github.com/cybertec-postgresql/pgwatch2/pull/606
[-]
fix "invalid command 'BEGIN READ WRITE'" error when '--conn-pooling' option is on by @IlyaTsoi in https://github.com/cybertec-postgresql/pgwatch2/pull/586
[-]
ensure bootstrap of a timescale metrics db includes necessary metric-time function by @dtmdl in https://github.com/cybertec-postgresql/pgwatch2/pull/592
[-]
add pgwatch2-webui
target to the Release GHA workflow, fixes #597 by @pashagolub in https://github.com/cybertec-postgresql/pgwatch2/pull/598
Full Changelog: https://github.com/cybertec-postgresql/pgwatch2/compare/v1.10.0...v1.11.0
[!]
add Postgres v15 support by @kmoppel-cognite in https://github.com/cybertec-postgresql/pgwatch2/pull/489
[!]
bump Go packages versions by @pashagolub in https://github.com/cybertec-postgresql/pgwatch2/pull/570
[!]
bump Golang to 1.19, closes #538 by @pashagolub in https://github.com/cybertec-postgresql/pgwatch2/pull/539
[!]
provide ARM docker images, closes #502 by @pashagolub in https://github.com/cybertec-postgresql/pgwatch2/pull/534
[*]
allow only local repo PRs test docker builds by @pashagolub in https://github.com/cybertec-postgresql/pgwatch2/pull/530
[*]
change output message in helpers functions, closes #553 by @pmpetit in https://github.com/cybertec-postgresql/pgwatch2/pull/572
[*]
deprecate Influx docker images in Release GHA workflow, closes #544 by @pashagolub in https://github.com/cybertec-postgresql/pgwatch2/pull/558
[*]
metrics: add "wal.timeline" column to be able to detect failovers by @kmoppel-cognite in https://github.com/cybertec-postgresql/pgwatch2/pull/488
[*]
remove trailing space for SQL commands for non-Postgres DB types by @slardiere in https://github.com/cybertec-postgresql/pgwatch2/pull/571
[*]
use ENV var in GHA instead of deprecated set-output
command, fixes #522 by @pashagolub in https://github.com/cybertec-postgresql/pgwatch2/pull/533
[*]
сleanup pgbackrest helper function by @ants in https://github.com/cybertec-postgresql/pgwatch2/pull/512
[+]
add GHA workflow to build Docker image for each PR, closes #528 by @pashagolub in https://github.com/cybertec-postgresql/pgwatch2/pull/529
[+]
add helm chart by @yanchenko-igor in https://github.com/cybertec-postgresql/pgwatch2/pull/490
[+]
add helm chart first version by @yanchenko-igor in https://github.com/cybertec-postgresql/pgwatch2/pull/477
[+]
add metric and dashboard for bloated indexes and tables by @marcelorauldiaz in https://github.com/cybertec-postgresql/pgwatch2/pull/518
[+]
add new stat activity grid report by @pmpetit in https://github.com/cybertec-postgresql/pgwatch2/pull/521
[+]
bump actions/stale
from 4 to 6 by @dependabot in https://github.com/cybertec-postgresql/pgwatch2/pull/562
[+]
bump elgohr/Publish-Docker-Github-Action
from 4 to 5 by @dependabot in https://github.com/cybertec-postgresql/pgwatch2/pull/561
[+]
bump github/codeql-action
from 1 to 2 by @dependabot in https://github.com/cybertec-postgresql/pgwatch2/pull/559
[+]
bump goreleaser/goreleaser-action
from 3 to 4 by @dependabot in https://github.com/cybertec-postgresql/pgwatch2/pull/560
[+]
make unique dbname maintenance less costly for multi-daemon setups, fixes #525 by @kmoppel-cognite in https://github.com/cybertec-postgresql/pgwatch2/pull/573
[+]
postgres backend implemented by @yanchenko-igor in https://github.com/cybertec-postgresql/pgwatch2/pull/483
[+]
some fixes and improvements for helm chart by @yanchenko-igor in https://github.com/cybertec-postgresql/pgwatch2/pull/486
[+]
use predefined Grafana dashboards uid
, fixes #474 by @pashagolub in https://github.com/cybertec-postgresql/pgwatch2/pull/480
[-]
check Docker user name for PR images by @pashagolub in https://github.com/cybertec-postgresql/pgwatch2/pull/531
[-]
fix Invalid command SET lock_timeout...
error, fixes #507 by @IlyaTsoi in https://github.com/cybertec-postgresql/pgwatch2/pull/527
[-]
fix PW2_DATASTORE
environment variable in pgwatch2-webui.service
by @jsoler in https://github.com/cybertec-postgresql/pgwatch2/pull/484
[-]
fix table_bloat_approx_summary_sql
when tblpages = 0
, closes #491 by @dtmdl in https://github.com/cybertec-postgresql/pgwatch2/pull/547
[-]
fix tag_semver
in the Release
workflow, closes #471 by @pashagolub in https://github.com/cybertec-postgresql/pgwatch2/pull/472
[-]
fix executing queries on standby databases with pooling, fixes #520 by @pashagolub in https://github.com/cybertec-postgresql/pgwatch2/pull/551
[-]
fix goreleaser "field empty_folders not found..." error, closes #541 by @pashagolub https://github.com/cybertec-postgresql/pgwatch2/pull/542
[-]
fix pgpool dbtype monitoring failure for multi statement queries, fixes #498 by @palmalcheg in https://github.com/cybertec-postgresql/pgwatch2/pull/499
[-]
fix pgpool mode to execute only "non empty" queries by @palmalcheg in https://github.com/cybertec-postgresql/pgwatch2/pull/501
[-]
fix typo error by @frastr in https://github.com/cybertec-postgresql/pgwatch2/pull/519
[-]
typo fixed by @yanchenko-igor in https://github.com/cybertec-postgresql/pgwatch2/pull/548
Full Changelog: https://github.com/cybertec-postgresql/pgwatch2/compare/v1.9.0...v1.10.0
[+]
make unique dbname maintenance less costly for multi-daemon setups, fixes #525 by @kmoppel-cognite in https://github.com/cybertec-postgresql/pgwatch2/pull/573
[*]
change output message in helpers functions, closes #553 by @pmpetit in https://github.com/cybertec-postgresql/pgwatch2/pull/572
Full Changelog: https://github.com/cybertec-postgresql/pgwatch2/compare/v1.10.0-beta2...v1.10.0-beta3
[!]
bump Go packages versions by @pashagolub in https://github.com/cybertec-postgresql/pgwatch2/pull/570
[+]
add new stat activity grid report by @pmpetit in https://github.com/cybertec-postgresql/pgwatch2/pull/521
[+]
bump actions/stale
from 4 to 6 by @dependabot in https://github.com/cybertec-postgresql/pgwatch2/pull/562
[+]
bump elgohr/Publish-Docker-Github-Action
from 4 to 5 by @dependabot in https://github.com/cybertec-postgresql/pgwatch2/pull/561
[+]
bump github/codeql-action
from 1 to 2 by @dependabot in https://github.com/cybertec-postgresql/pgwatch2/pull/559
[+]
bump goreleaser/goreleaser-action
from 3 to 4 by @dependabot in https://github.com/cybertec-postgresql/pgwatch2/pull/560
[*]
deprecate Influx docker images in Release GHA workflow, closes #544 by @pashagolub in https://github.com/cybertec-postgresql/pgwatch2/pull/558
[*]
remove trailing space for SQL commands for non-Postgres DB types by @slardiere in https://github.com/cybertec-postgresql/pgwatch2/pull/571
[-]
fix table_bloat_approx_summary_sql
when tblpages = 0
, closes #491 by @dtmdl in https://github.com/cybertec-postgresql/pgwatch2/pull/547
[-]
fix executing queries on standby databases with pooling, fixes #520 by @pashagolub in https://github.com/cybertec-postgresql/pgwatch2/pull/551
[-]
typo fixed by @yanchenko-igor in https://github.com/cybertec-postgresql/pgwatch2/pull/548
Full Changelog: https://github.com/cybertec-postgresql/pgwatch2/compare/v1.10.0-beta1...v1.10.0-beta2
[!]
add Postgres v15 support by @kmoppel-cognite in https://github.com/cybertec-postgresql/pgwatch2/pull/489
[!]
bump Golang to 1.19, closes #538 by @pashagolub in https://github.com/cybertec-postgresql/pgwatch2/pull/539
[!]
provide ARM docker images, closes #502 by @pashagolub in https://github.com/cybertec-postgresql/pgwatch2/pull/534
[+]
add GHA workflow to build Docker image for each PR, closes #528 by @pashagolub in https://github.com/cybertec-postgresql/pgwatch2/pull/529
[+]
add helm chart by @yanchenko-igor in https://github.com/cybertec-postgresql/pgwatch2/pull/490
[+]
add helm chart first version by @yanchenko-igor in https://github.com/cybertec-postgresql/pgwatch2/pull/477
[+]
add metric and dashboard for bloated indexes and tables by @marcelorauldiaz in https://github.com/cybertec-postgresql/pgwatch2/pull/518
[+]
postgres backend implemented by @yanchenko-igor in https://github.com/cybertec-postgresql/pgwatch2/pull/483
[+]
some fixes and improvements for helm chart by @yanchenko-igor in https://github.com/cybertec-postgresql/pgwatch2/pull/486
[+]
use predefined Grafana dashboards uid
, fixes #474 by @pashagolub in https://github.com/cybertec-postgresql/pgwatch2/pull/480
[*]
allow only local repo PRs test docker builds by @pashagolub in https://github.com/cybertec-postgresql/pgwatch2/pull/530
[*]
metrics: add "wal.timeline" column to be able to detect failovers by @kmoppel-cognite in https://github.com/cybertec-postgresql/pgwatch2/pull/488
[*]
use ENV var in GHA instead of deprecated set-output
command, fixes #522 by @pashagolub in https://github.com/cybertec-postgresql/pgwatch2/pull/533
[*]
сleanup pgbackrest helper function by @ants in https://github.com/cybertec-postgresql/pgwatch2/pull/512
[-]
check Docker user name for PR images by @pashagolub in https://github.com/cybertec-postgresql/pgwatch2/pull/531
[-]
fix Invalid command SET lock_timeout...
error, fixes #507 by @IlyaTsoi in https://github.com/cybertec-postgresql/pgwatch2/pull/527
[-]
fix PW2_DATASTORE
environment variable in pgwatch2-webui.service
by @jsoler in https://github.com/cybertec-postgresql/pgwatch2/pull/484
[-]
fix tag_semver
in the Release
workflow, closes #471 by @pashagolub in https://github.com/cybertec-postgresql/pgwatch2/pull/472
[-]
fix goreleaser "field empty_folders not found..." error, closes #541 by @pashagolub https://github.com/cybertec-postgresql/pgwatch2/pull/542
[-]
fix pgpool dbtype monitoring failure for multi statement queries, fixes #498 by @palmalcheg in https://github.com/cybertec-postgresql/pgwatch2/pull/499
[-]
fix pgpool mode to execute only "non empty" queries by @palmalcheg in https://github.com/cybertec-postgresql/pgwatch2/pull/501
[-]
fix typo error by @frastr in https://github.com/cybertec-postgresql/pgwatch2/pull/519
Full Changelog: https://github.com/cybertec-postgresql/pgwatch2/compare/v1.9.0...v1.10.0-beta1
sqlx.DB
by @kmoppel-cognite in https://github.com/cybertec-postgresql/pgwatch2/pull/418
release
GitHub Action by @pashagolub in https://github.com/cybertec-postgresql/pgwatch2/pull/437
port
parameter from StartPrometheusExporter()
, fixes #407 by @pashagolub in https://github.com/cybertec-postgresql/pgwatch2/pull/455
stale
label lower cased by @pashagolub in https://github.com/cybertec-postgresql/pgwatch2/pull/457
get_table_bloat_approx_sql()
when tblpages = 0
, closes #464 by @pashagolub in https://github.com/cybertec-postgresql/pgwatch2/pull/468
elgohr/Publish-Docker-Github-Action
to v4, closes #469 by @pashagolub in https://github.com/cybertec-postgresql/pgwatch2/pull/470
Full Changelog: https://github.com/cybertec-postgresql/pgwatch2/compare/v1.8.5...v1.9.0
In the spirit of open-source software community, we strongly encourage you to test the new features of pgwatch2 v1.9 in your systems to help us eliminate any bugs or other issues that may exist. While we do not advise you to run pgwatch2 v1.9.0-beta in your production environments, we encourage you to find ways to run your typical application workloads against this beta release.
sqlx.DB
by @kmoppel-cognite in https://github.com/cybertec-postgresql/pgwatch2/pull/418
release
GitHub Action by @pashagolub in https://github.com/cybertec-postgresql/pgwatch2/pull/437
Full Changelog: https://github.com/cybertec-postgresql/pgwatch2/compare/v1.8.5...v1.9.0-beta
build-docker-influx.sh
46dab01psql
ENV vars in smoke test script efc289elibffi-dev
in Dockerfile
, fixes #444 44f7cc2libffi-dev
in Dockerfile-nonroot
, fixes #444 e811c20golang:1.17
in all Dockerfiles f682ffblibffi-dev
in Dockerfile-nonroot
, fixes #443 363f457set -a
for smoke_test_docker.sh
to mark variables export, fixes #442 1023f86pgwatch2-nonroot
image to the registry during release
workflow 859c73fcp
instead of git archive
in GHA c39d47a*sqlx.DB
6932b6eDBGetPGVersion()
a217aea/* pgwatch2_generated */
to all metric SQLs f186fd5wait_events metric
: add also max_query_duration_us
in addition to avg d40a0eawait_events
metrics to the prometheus-async
preset 4ed96a3See the list of major changes here.
NB! No schema migration diffs to be applied for older Config DB based installations.
NB2! For file-based DEB / RPM installations starting from this release also metric definitions are considered as config files to avoid transparently overriding custom metric changes done by user. Thus when upgrading you might get quite many annoying confirmation dialogs. If you're sure that you have not changed anything then one can bypass them by: a) using some force flag like --force-confnew
with dpkg
b) purging the older package version c) deleting the /etc/pgwatch2/metrics/
contents. In the first two cases make sure though to back up the monitored instances configuration file, located at /etc/pgwatch2/config/instances.yaml
by default.
See list of major changes here.