1 # Pre-defined queries of collectd's postgresql plugin.
4 Query "SELECT count(*) \
5 FROM pg_stat_activity \
14 Query "SELECT xact_commit, xact_rollback \
15 FROM pg_stat_database \
21 Column pg_xact rollback
25 Query "SELECT sum(n_tup_ins), sum(n_tup_upd), sum(n_tup_del) \
26 FROM pg_stat_user_tables;"
36 Query "SELECT sum(n_tup_ins), sum(n_tup_upd), sum(n_tup_del), \
38 FROM pg_stat_user_tables;"
43 Column pg_n_tup_c hot_upd
49 Query "SELECT sum(seq_scan), sum(seq_tup_read), \
50 sum(idx_scan), sum(idx_tup_fetch) \
51 FROM pg_stat_user_tables;"
54 Column pg_scan seq_tup_read
56 Column pg_scan idx_tup_fetch
60 Query "SELECT sum(n_live_tup), sum(n_dead_tup) \
61 FROM pg_stat_user_tables;"
63 Column pg_n_tup_g live
64 Column pg_n_tup_g dead
70 Query "SELECT sum(heap_blks_read), sum(heap_blks_hit), \
71 sum(idx_blks_read), sum(idx_blks_hit), \
72 sum(toast_blks_read), sum(toast_blks_hit), \
73 sum(tidx_blks_read), sum(tidx_blks_hit) \
74 FROM pg_statio_user_tables;"
76 Column pg_blks heap_read
77 Column pg_blks heap_hit
78 Column pg_blks idx_read
79 Column pg_blks idx_hit
80 Column pg_blks toast_read
81 Column pg_blks toast_hit
82 Column pg_blks tidx_read
83 Column pg_blks tidx_hit
87 Query "SELECT pg_database_size($1);"