</Query>
<Query queries>
+ Query "SELECT sum(n_tup_ins), sum(n_tup_upd), sum(n_tup_del) \
+ FROM pg_stat_user_tables;"
+
+ Column pg_n_tup_c ins
+ Column pg_n_tup_c upd
+ Column pg_n_tup_c del
+
+ MaxPGVersion 80299
+</Query>
+
+<Query queries>
Query "SELECT sum(n_tup_ins), sum(n_tup_upd), sum(n_tup_del), \
sum(n_tup_hot_upd) \
FROM pg_stat_user_tables;"
Column pg_n_tup_c upd
Column pg_n_tup_c del
Column pg_n_tup_c hot_upd
+
+ MinPGVersion 80300
</Query>
<Query query_plans>
Column pg_n_tup_g live
Column pg_n_tup_g dead
+
+ MinPGVersion 80300
</Query>
<Query disk_io>
- Query "SELECT sum(heap_blks_read), sum(heap_blks_hit), \
- sum(idx_blks_read), sum(idx_blks_hit), \
- sum(toast_blks_read), sum(toast_blks_hit), \
- sum(tidx_blks_read), sum(tidx_blks_hit) \
+ Query "SELECT coalesce(sum(heap_blks_read), 0), \
+ coalesce(sum(heap_blks_hit), 0), \
+ coalesce(sum(idx_blks_read), 0), \
+ coalesce(sum(idx_blks_hit), 0), \
+ coalesce(sum(toast_blks_read), 0), \
+ coalesce(sum(toast_blks_hit), 0), \
+ coalesce(sum(tidx_blks_read), 0), \
+ coalesce(sum(tidx_blks_hit), 0) \
FROM pg_statio_user_tables;"
Column pg_blks heap_read
Column pg_db_size
</Query>
+# vim: set ft=config :
+