Excluding Metrics from Postgres Collector

Help
1

I want to exclude metrics in the postgres netdata collector.

I followed the below guide for setup, but wasn’t able to determine the proper yaml input for excluding metrics.
Say for example, I wanted to exclude the collector from running this metric: postgres.table_bloat_size_perc
How is that accomplished?
File: sudo ./edit-config go.d/postgres.conf

Sample yaml entry (does not work):
jobs:

DB Env Name Here

  • name: local
    dsn: ‘postgresql://netdata:PWHere@IPHere:5432/dbNameHere’
    collect_databases_matching: ‘’
    labels:
    database: '    ’
    schema: ‘*’
    ‘!postgres.table_bloat_size_perc’

Suggestions?
Using netdata non-cloud local agent of netdata on our vm’s

Thanks.

2

Hi, @jfensterman. That is not possible. Wy do you want to exclude table bloat metrics?

3

I want to exclude most of the metrics as we are using citus and I don’t want to run all of the monitors through the workers and I also do not wish to run some of the metrics against our system as its heavy write then rotate to a new table and its using a bunch of resources to do so.

If its not possible that’s fine, we can just continue to expand our custom dashboards using pandas/python.

4

monitors through the workers
heavy write then rotate to a new table

Whare do you mean? What workers? What table?

5

Good morning. It’s a distributed database. But the main goal was to modify the collector and if that’s not possible then we will go in a different direction.

Ty

The contents of this e-mail message and any attachments are intended solely for the addressee(s) and may contain confidential and/or legally privileged information. If you are not the intended recipient of this message or if this message has been addressed to you in error, please immediately alert the sender by reply e-mail and then delete this message and any attachments. If you are not the intended recipient, you are notified that any use, dissemination, distribution, copying, or storage of this message or any attachment is strictly prohibited.