:hedgehog: PostHog is the leading platform for building self-driving products. Our developer tools – AI observability, analytics, session replay, flags, experiments, error tracking, logs, and more – capture all the context agents need to diagnose problems, uncover opportunities, and ship fixes. Steer it all from Slack, web, desktop, or the MCP.
Python ab-testingai-analyticsanalyticscdpdata-warehouseexperimentsfeature-flagsjavascriptproduct-analyticspythonreactsession-replaysurveystypescriptweb-analytics
name: database_stats
description: Per-database throughput, cache hit, temp files, deadlocks, xid age.
interval: 60s
scope: cluster
kind: cumulative
key: [datname]
query: |
SELECT d.datname,
s.numbackends,
s.xact_commit, s.xact_rollback,
s.blks_read, s.blks_hit,
s.tup_returned, s.tup_fetched, s.tup_inserted, s.tup_updated, s.tup_deleted,
s.conflicts, s.temp_files, s.temp_bytes, s.deadlocks,
s.blk_read_time, s.blk_write_time,
s.stats_reset,
age(d.datfrozenxid)::bigint AS xid_age
FROM pg_stat_database s
JOIN pg_database d ON d.oid = s.datid
WHERE NOT d.datistemplate AND d.datname <> 'rdsadmin'
variants:
- min_pg_version: 140000
query: |
SELECT d.datname,
s.numbackends,
s.xact_commit, s.xact_rollback,
s.blks_read, s.blks_hit,
s.tup_returned, s.tup_fetched, s.tup_inserted, s.tup_updated, s.tup_deleted,
s.conflicts, s.temp_files, s.temp_bytes, s.deadlocks,
s.blk_read_time, s.blk_write_time,
s.session_time, s.active_time, s.idle_in_transaction_time,
s.sessions, s.sessions_abandoned, s.sessions_fatal, s.sessions_killed,
s.stats_reset,
age(d.datfrozenxid)::bigint AS xid_age
FROM pg_stat_database s
JOIN pg_database d ON d.oid = s.datid
WHERE NOT d.datistemplate AND d.datname <> 'rdsadmin'