Skip to content

Opt-in/out collecting stats per database/table/schema #6

@magnusp

Description

@magnusp

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.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions