Home

Welcome to the postgres_exporter wiki!

Sample queries for grafana from postgres_exporter that might be useful:

You will want to update to your filters (inside {}).

# of connections: pg_stat_database_numbackends{job="prodpg-exporter"}

# of locks (by lock type) for a specific DB: pg_locks_count{job="prodpg-exporter",datname="MYDB"}
legend_format: {{mode}}

Cache hit rate by database: rate(pg_stat_database_blks_hit{job="prodpg-exporter"}[5m])
legend_format: {{datname}}

disk reads per sec by database: rate(pg_stat_database_blks_read{instance="proddb"}[5m])
legend_format: {{datname}}