In my environment we have 18 postgres servers with ~25 databases each, containing ~4000 schemas per database. I've only just started using the Zenpack, but from what I understand each table, per schema, is monitored/gathered statistics from. For me, that would mean in-the-millions RRDs and an unacceptable load on the servers for each poll.
I propose two mutually exclusive settings that either includes or excludes schemas from being monitored. This could be implemented as (a list of?) regular expressions against the schemaname and/or relname columns of pg_stat_user_tables.
In my environment we have 18 postgres servers with ~25 databases each, containing ~4000 schemas per database. I've only just started using the Zenpack, but from what I understand each table, per schema, is monitored/gathered statistics from. For me, that would mean in-the-millions RRDs and an unacceptable load on the servers for each poll.
I propose two mutually exclusive settings that either includes or excludes schemas from being monitored. This could be implemented as (a list of?) regular expressions against the schemaname and/or relname columns of pg_stat_user_tables.