Ad-hoc monitoring
In some cases, we need to observe some values in Postgres or the environment it's running on (OS, FS, etc.), and:
11 docs tagged with "monitoring"
View all tagsAutovacuum "queue" and progress
Monitor and manage autovacuum queue, understand worker activity and vacuum progress
How to determine the replication lag
How to find int4 PKs with out-of-range risks in a large database
How to monitor CREATE INDEX / REINDEX progress in Postgres 12+
How to monitor transaction ID wraparound risks
How to monitor xmin horizon to prevent XID/MultiXID wraparound and high bloat
How to reduce WAL generation rates
How to set application_name without extra queries
How to troubleshoot streaming replication lag
Learn how to troubleshoot streaming replication lag
How to work with pg_stat_statements, part 1
There are two big branches of query optimization: