Hello,
I noticed in the Zabbix template pg.table.n_live_tup[{$PG_CONN},{#DATABASE}] and pg.table.n_dead_tup[{$PG_CONN},{#DATABASE}] and I tried using them to calculate the garbage ratio / DB.
The problem is that they are always returned 0. This works fine for the table ones, but after a bit of digging the query in the docs will never work, because relname will never equal {#DATABASE}.
Is there any other way to get the garbage ratio? I do have some other custom queries which I use and involve a join between pg_class and pg_stat_all_tables on oid=relid. But I preferred to use this module instead.
Thank you very much for your work
Hello,
I noticed in the Zabbix template
pg.table.n_live_tup[{$PG_CONN},{#DATABASE}]andpg.table.n_dead_tup[{$PG_CONN},{#DATABASE}]and I tried using them to calculate the garbage ratio / DB.The problem is that they are always returned 0. This works fine for the table ones, but after a bit of digging the query in the docs will never work, because
relnamewill never equal{#DATABASE}.Is there any other way to get the garbage ratio? I do have some other custom queries which I use and involve a join between
pg_classandpg_stat_all_tablesonoid=relid. But I preferred to use this module instead.Thank you very much for your work