Monitoring postgresql database

Help
1

Hi Guys,

I’m having problems getting the postgresql monitoring to work.

I’ve configured the postgres plugin according to the general consensus on the internet and have it running happily through python.d.plugin debug postgres and can see the tcp connection getting set up correctly and some data being generated.

However, nothing appears on the cloud dashboard for postgresql.

When I look in the netdata logs (error.log) I’m getting

2020-12-17 12:43:58: python.d INFO: postgres[tcp] : chart ‘postgres_BangoProd.db_stat_temp_files’ was suppressed due to non updating
2020-12-17 12:43:58: python.d INFO: postgres[tcp] : chart ‘postgres_BangoProd.db_stat_temp_bytes’ was suppressed due to non updating
2020-12-17 12:43:58: python.d INFO: postgres[tcp] : chart ‘postgres_BangoProd.db_stat_blks’ was suppressed due to non updating
2020-12-17 12:43:58: python.d INFO: postgres[tcp] : chart ‘postgres_BangoProd.db_stat_tuple_returned’ was suppressed due to non updating
2020-12-17 12:43:58: python.d INFO: postgres[tcp] : chart ‘postgres_BangoProd.db_stat_tuple_write’ was suppressed due to non updating
2020-12-17 12:43:58: python.d INFO: postgres[tcp] : chart ‘postgres_BangoProd.db_stat_transactions’ was suppressed due to non updating
2020-12-17 12:43:58: python.d INFO: postgres[tcp] : chart ‘postgres_BangoProd.db_stat_connections’ was suppressed due to non updating
2020-12-17 12:43:58: python.d INFO: postgres[tcp] : chart ‘postgres_BangoProd.index_count’ was suppressed due to non updating
2020-12-17 12:43:58: python.d INFO: postgres[tcp] : chart ‘postgres_BangoProd.index_size’ was suppressed due to non updating
2020-12-17 12:43:58: python.d INFO: postgres[tcp] : chart ‘postgres_BangoProd.table_count’ was suppressed due to non updating
2020-12-17 12:43:58: python.d INFO: postgres[tcp] : chart ‘postgres_BangoProd.table_size’ was suppressed due to non updating
2020-12-17 12:43:58: python.d INFO: postgres[tcp] : chart ‘postgres_BangoProd.replication_slot’ was suppressed due to non updating
2020-12-17 12:43:58: python.d INFO: postgres[tcp] : chart ‘postgres_BangoProd.standby_delta’ was suppressed due to non updating

which I guess explains the lack of any chart, but I’m not sure why.

Admittedly the database isn’t very busy yet, but its not empty either.

Any ideas?

1 Like
2

Hey @pnunn,

This sound bizzare, so we are going to fix it! Can you please verify that you have followed the documentation for that particular plugin?

Moreover, can you verify that the charts are not showing on the Netdata Agent local dashboard? (not cloud).

If they aren’t, please try to run (change the directory if you installed netdata in another path):

sudo su -s /bin/bash netdata
/usr/libexec/netdata/plugins.d/python.d.plugin 1 debug trace postgres

and share the results with us.

Cheers!

3

OK, found it… the data is showing on the overview dashboard, not on the individual site dashboard (a bit odd, but I guess that works).

Thanks for the info.