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 coalesce(sum(heap_blks_read), 0), \
71 coalesce(sum(heap_blks_hit), 0), \
72 coalesce(sum(idx_blks_read), 0), \
73 coalesce(sum(idx_blks_hit), 0), \
74 coalesce(sum(toast_blks_read), 0), \
75 coalesce(sum(toast_blks_hit), 0), \
76 coalesce(sum(tidx_blks_read), 0), \
77 coalesce(sum(tidx_blks_hit), 0) \
78 FROM pg_statio_user_tables;"
80 Column pg_blks heap_read
81 Column pg_blks heap_hit
82 Column pg_blks idx_read
83 Column pg_blks idx_hit
84 Column pg_blks toast_read
85 Column pg_blks toast_hit
86 Column pg_blks tidx_read
87 Column pg_blks tidx_hit
91 Query "SELECT pg_database_size($1);"
98 # vim: set ft=config :