Ad-hoc monitoring
// I post a new PostgreSQL "howto" article every day. Join me in this journey – subscribe, provide feedback, share!
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 how to troubleshoot streaming replication lag
How to work with pg_stat_statements, part 1
Two branches of query optimization