Monitoring postgres does not show anything

Help
,
1

Hi, am having trouble to get the postgres plugin toproduce Charts

Environment

Debian Buster.
netdata Version v1.32.1-71-g4a50934c1

Problem/Question

It seems that the plugin works correct. See here:

netdata$ /opt/netdata/usr/libexec/netdata/plugins.d/python.d.plugin 1 debug trace postgres

022-01-17 11:22:24: python.d INFO: plugin[main] : using python v2
2022-01-17 11:22:24: python.d DEBUG: plugin[main] : looking for '/opt/netdata/etc/netdata/python.d.conf'
2022-01-17 11:22:24: python.d INFO: plugin[main] : '/opt/netdata/etc/netdata/python.d.conf' was not found
2022-01-17 11:22:24: python.d DEBUG: plugin[main] : looking for '/opt/netdata/usr/lib/netdata/conf.d/python.d.conf'
2022-01-17 11:22:24: python.d DEBUG: plugin[main] : '/opt/netdata/usr/lib/netdata/conf.d/python.d.conf' is loaded
2022-01-17 11:22:24: python.d DEBUG: plugin[main] : looking for 'pythond-jobs-statuses.json' in /opt/netdata/var/lib/netdata
2022-01-17 11:22:24: python.d DEBUG: plugin[main] : loading '/opt/netdata/var/lib/netdata/pythond-jobs-statuses.json'
2022-01-17 11:22:24: python.d DEBUG: plugin[main] : '/opt/netdata/var/lib/netdata/pythond-jobs-statuses.json' is loaded
2022-01-17 11:22:24: python.d DEBUG: plugin[main] : [postgres] looking for 'postgres.conf' in ['/opt/netdata/etc/netdata/python.d', '/opt/netdata/usr/lib/netdata/conf.d/python.d']
2022-01-17 11:22:24: python.d DEBUG: plugin[main] : [postgres] loading '/opt/netdata/etc/netdata/python.d/postgres.conf'
2022-01-17 11:22:24: python.d DEBUG: plugin[main] : [postgres] '/opt/netdata/etc/netdata/python.d/postgres.conf' is loaded
2022-01-17 11:22:24: python.d INFO: plugin[main] : [postgres] built 4 job(s) configs
2022-01-17 11:22:24: python.d DEBUG: postgres[socket] : server version: 90615
2022-01-17 11:22:24: python.d DEBUG: postgres[socket] : superuser: False
2022-01-17 11:22:24: python.d DEBUG: postgres[socket] : discovered databases ['Confluence', 'postgres']
2022-01-17 11:22:24: python.d DEBUG: postgres[socket] : discovered secondaries: []
2022-01-17 11:22:24: python.d INFO: plugin[main] : postgres[socket] : check success
CHART netdata.runtime_postgres_local '' 'Execution time for postgres_local' 'ms' 'python.d' netdata.pythond_runtime line 145000 1 '' 'python.d.plugin' 'postgres'
DIMENSION run_time 'run time' absolute 1 1

2022-01-17 11:22:24: python.d DEBUG: postgres[socket] : started, update frequency: 1
2022-01-17 11:22:24: python.d INFO: plugin[main] : postgres[tcp] : already served by another job, skipping it
2022-01-17 11:22:24: python.d INFO: plugin[main] : postgres[tcpipv4] : already served by another job, skipping it
2022-01-17 11:22:24: python.d INFO: plugin[main] : postgres[tcpipv6] : already served by another job, skipping it
CHART postgres_local.Confluence_db_stat_tuple_returned '' 'Tuples returned from db: Confluence' 'tuples/s' 'db Confluence' 'postgres.db_stat_tuple_returned' line 60004 1 '' 'python.d.plugin' 'postgres'
DIMENSION 'Confluence_tup_returned' 'sequential' incremental 1 1 ' '
DIMENSION 'Confluence_tup_fetched' 'bitmap' incremental 1 1 ' '

BEGIN postgres_local.Confluence_db_stat_tuple_returned 0
SET 'Confluence_tup_returned' = 160153894601
SET 'Confluence_tup_fetched' = 82415304805
END

CHART postgres_local.Confluence_db_stat_tuple_write '' 'Tuples written to db: Confluence' 'writes/s' 'db Confluence' 'postgres.db_stat_tuple_write' line 60003 1 '' 'python.d.plugin' 'postgres'
DIMENSION 'Confluence_tup_inserted' 'inserted' incremental 1 1 ' '
DIMENSION 'Confluence_tup_updated' 'updated' incremental 1 1 ' '
DIMENSION 'Confluence_tup_deleted' 'deleted' incremental 1 1 ' '
DIMENSION 'Confluence_conflicts' 'conflicts' incremental 1 1 ' '

BEGIN postgres_local.Confluence_db_stat_tuple_write 0
SET 'Confluence_tup_inserted' = 30152082
SET 'Confluence_tup_updated' = 2321650
SET 'Confluence_tup_deleted' = 25995643
SET 'Confluence_conflicts' = 0
END

CHART postgres_local.backend_usage '' '% of Connections in use' 'percentage' 'backend processes' 'postgres.backend_usage' stacked 60026 1 '' 'python.d.plugin' 'postgres'
DIMENSION 'available' 'available' percentage-of-absolute-row 1 1 ' '
DIMENSION 'used' 'used' percentage-of-absolute-row 1 1 ' '

BEGIN postgres_local.backend_usage 0
SET 'available' = 76
SET 'used' = 21
END

CHART postgres_local.postgres_db_stat_connections '' 'Current connections to db: postgres' 'count' 'db postgres' 'postgres.db_stat_connections' line 60009 1 '' 'python.d.plugin' 'postgres'
DIMENSION 'postgres_connections' 'connections' absolute 1 1 ' '

BEGIN postgres_local.postgres_db_stat_connections 0
SET 'postgres_connections' = 1
END

CHART postgres_local.postgres_db_stat_temp_files '' 'Temp files written to disk: postgres' 'files' 'db postgres' 'postgres.db_stat_temp_files' line 60015 1 '' 'python.d.plugin' 'postgres'
DIMENSION 'postgres_temp_files' 'files' incremental 1 1 ' '

BEGIN postgres_local.postgres_db_stat_temp_files 0
SET 'postgres_temp_files' = 0
END

CHART postgres_local.Confluence_db_stat_connections '' 'Current connections to db: Confluence' 'count' 'db Confluence' 'postgres.db_stat_connections' line 60001 1 '' 'python.d.plugin' 'postgres'
DIMENSION 'Confluence_connections' 'connections' absolute 1 1 ' '

BEGIN postgres_local.Confluence_db_stat_connections 0
SET 'Confluence_connections' = 20
END

CHART postgres_local.postgres_db_stat_temp_bytes '' 'Temp files written to disk: postgres' 'KiB/s' 'db postgres' 'postgres.db_stat_temp_bytes' line 60014 1 '' 'python.d.plugin' 'postgres'
DIMENSION 'postgres_temp_bytes' 'size' incremental 1 1024 ' '

BEGIN postgres_local.postgres_db_stat_temp_bytes 0
SET 'postgres_temp_bytes' = 0
END

CHART postgres_local.postgres_db_stat_tuple_write '' 'Tuples written to db: postgres' 'writes/s' 'db postgres' 'postgres.db_stat_tuple_write' line 60011 1 '' 'python.d.plugin' 'postgres'
DIMENSION 'postgres_tup_inserted' 'inserted' incremental 1 1 ' '
DIMENSION 'postgres_tup_updated' 'updated' incremental 1 1 ' '
DIMENSION 'postgres_tup_deleted' 'deleted' incremental 1 1 ' '
DIMENSION 'postgres_conflicts' 'conflicts' incremental 1 1 ' '

BEGIN postgres_local.postgres_db_stat_tuple_write 0
SET 'postgres_tup_inserted' = 0
SET 'postgres_tup_updated' = 0
SET 'postgres_tup_deleted' = 0
SET 'postgres_conflicts' = 0
END

CHART postgres_local.Confluence_locks '' 'Locks on db: Confluence' 'locks' 'db Confluence' 'postgres.db_locks' line 60048 1 '' 'python.d.plugin' 'postgres'
DIMENSION 'Confluence_ExclusiveLock' 'ExclusiveLock' absolute 1 1 ' '
DIMENSION 'Confluence_RowShareLock' 'RowShareLock' absolute 1 1 ' '
DIMENSION 'Confluence_SIReadLock' 'SIReadLock' absolute 1 1 ' '
DIMENSION 'Confluence_ShareUpdateExclusiveLock' 'ShareUpdateExclusiveLock' absolute 1 1 ' '
DIMENSION 'Confluence_AccessExclusiveLock' 'AccessExclusiveLock' absolute 1 1 ' '
DIMENSION 'Confluence_AccessShareLock' 'AccessShareLock' absolute 1 1 ' '
DIMENSION 'Confluence_ShareRowExclusiveLock' 'ShareRowExclusiveLock' absolute 1 1 ' '
DIMENSION 'Confluence_ShareLock' 'ShareLock' absolute 1 1 ' '
DIMENSION 'Confluence_RowExclusiveLock' 'RowExclusiveLock' absolute 1 1 ' '

BEGIN postgres_local.Confluence_locks 0
SET 'Confluence_ExclusiveLock' = 0
SET 'Confluence_RowShareLock' = 0
SET 'Confluence_SIReadLock' = 0
SET 'Confluence_ShareUpdateExclusiveLock' = 0
SET 'Confluence_AccessExclusiveLock' = 0
SET 'Confluence_AccessShareLock' = 0
SET 'Confluence_ShareRowExclusiveLock' = 0
SET 'Confluence_ShareLock' = 0
SET 'Confluence_RowExclusiveLock' = 0
END

CHART postgres_local.tx_wraparound_percent_towards_wraparound '' 'Percent towards wraparound' 'percent' 'tx_wraparound' 'postgres.percent_towards_wraparound' line 60049 1 '' 'python.d.plugin' 'postgres'
DIMENSION 'percent_towards_wraparound' 'percent' absolute 1 1 ' '

BEGIN postgres_local.tx_wraparound_percent_towards_wraparound 0
SET 'percent_towards_wraparound' = 2
END

CHART postgres_local.postgres_db_stat_transactions '' 'Transactions on db: postgres' 'transactions/s' 'db postgres' 'postgres.db_stat_transactions' line 60010 1 '' 'python.d.plugin' 'postgres'
DIMENSION 'postgres_xact_commit' 'committed' incremental 1 1 ' '
DIMENSION 'postgres_xact_rollback' 'rolled back' incremental 1 1 ' '

BEGIN postgres_local.postgres_db_stat_transactions 0
SET 'postgres_xact_commit' = 2177118
SET 'postgres_xact_rollback' = 774
END

CHART postgres_local.postgres_db_stat_tuple_returned '' 'Tuples returned from db: postgres' 'tuples/s' 'db postgres' 'postgres.db_stat_tuple_returned' line 60012 1 '' 'python.d.plugin' 'postgres'
DIMENSION 'postgres_tup_returned' 'sequential' incremental 1 1 ' '
DIMENSION 'postgres_tup_fetched' 'bitmap' incremental 1 1 ' '

BEGIN postgres_local.postgres_db_stat_tuple_returned 0
SET 'postgres_tup_returned' = 1096071131
SET 'postgres_tup_fetched' = 15620182
END

CHART postgres_local.stat_bgwriter_alloc '' 'Buffers allocated' 'KiB/s' 'bgwriter' 'postgres.stat_bgwriter_alloc' line 60035 1 '' 'python.d.plugin' 'postgres'
DIMENSION 'buffers_alloc' 'alloc' incremental 1 1024 ' '

BEGIN postgres_local.stat_bgwriter_alloc 0
SET 'buffers_alloc' = 247867736064
END

CHART postgres_local.checkpointer '' 'Checkpoints' 'writes' 'checkpointer' 'postgres.checkpointer' line 60034 1 '' 'python.d.plugin' 'postgres'
DIMENSION 'checkpoint_scheduled' 'scheduled' incremental 1 1 ' '
DIMENSION 'checkpoint_requested' 'requested' incremental 1 1 ' '

BEGIN postgres_local.checkpointer 0
SET 'checkpoint_scheduled' = 215616
SET 'checkpoint_requested' = 0
END

CHART postgres_local.postgres_locks '' 'Locks on db: postgres' 'locks' 'db postgres' 'postgres.db_locks' line 60047 1 '' 'python.d.plugin' 'postgres'
DIMENSION 'postgres_ExclusiveLock' 'ExclusiveLock' absolute 1 1 ' '
DIMENSION 'postgres_RowShareLock' 'RowShareLock' absolute 1 1 ' '
DIMENSION 'postgres_SIReadLock' 'SIReadLock' absolute 1 1 ' '
DIMENSION 'postgres_ShareUpdateExclusiveLock' 'ShareUpdateExclusiveLock' absolute 1 1 ' '
DIMENSION 'postgres_AccessExclusiveLock' 'AccessExclusiveLock' absolute 1 1 ' '
DIMENSION 'postgres_AccessShareLock' 'AccessShareLock' absolute 1 1 ' '
DIMENSION 'postgres_ShareRowExclusiveLock' 'ShareRowExclusiveLock' absolute 1 1 ' '
DIMENSION 'postgres_ShareLock' 'ShareLock' absolute 1 1 ' '
DIMENSION 'postgres_RowExclusiveLock' 'RowExclusiveLock' absolute 1 1 ' '

BEGIN postgres_local.postgres_locks 0
SET 'postgres_ExclusiveLock' = 0
SET 'postgres_RowShareLock' = 0
SET 'postgres_SIReadLock' = 0
SET 'postgres_ShareUpdateExclusiveLock' = 0
SET 'postgres_AccessExclusiveLock' = 0
SET 'postgres_AccessShareLock' = 1
SET 'postgres_ShareRowExclusiveLock' = 0
SET 'postgres_ShareLock' = 0
SET 'postgres_RowExclusiveLock' = 0
END

CHART postgres_local.Confluence_db_stat_transactions '' 'Transactions on db: Confluence' 'transactions/s' 'db Confluence' 'postgres.db_stat_transactions' line 60002 1 '' 'python.d.plugin' 'postgres'
DIMENSION 'Confluence_xact_commit' 'committed' incremental 1 1 ' '
DIMENSION 'Confluence_xact_rollback' 'rolled back' incremental 1 1 ' '

BEGIN postgres_local.Confluence_db_stat_transactions 0
SET 'Confluence_xact_commit' = 2104351066
SET 'Confluence_xact_rollback' = 2585842
END

CHART postgres_local.Confluence_db_stat_temp_files '' 'Temp files written to disk: Confluence' 'files' 'db Confluence' 'postgres.db_stat_temp_files' line 60007 1 '' 'python.d.plugin' 'postgres'
DIMENSION 'Confluence_temp_files' 'files' incremental 1 1 ' '

BEGIN postgres_local.Confluence_db_stat_temp_files 0
SET 'Confluence_temp_files' = 0
END

CHART postgres_local.autovacuum '' 'Autovacuum workers' 'workers' 'autovacuum' 'postgres.autovacuum' line 60044 1 '' 'python.d.plugin' 'postgres'
DIMENSION 'analyze' 'analyze' absolute 1 1 ' '
DIMENSION 'vacuum' 'vacuum' absolute 1 1 ' '
DIMENSION 'vacuum_analyze' 'vacuum analyze' absolute 1 1 ' '
DIMENSION 'vacuum_freeze' 'vacuum freeze' absolute 1 1 ' '
DIMENSION 'brin_summarize' 'brin summarize' absolute 1 1 ' '

BEGIN postgres_local.autovacuum 0
SET 'analyze' = 0
SET 'vacuum' = 0
SET 'vacuum_analyze' = 0
SET 'vacuum_freeze' = 0
SET 'brin_summarize' = 0
END

CHART postgres_local.postgres_db_stat_blks '' 'Disk blocks reads from db: postgres' 'reads/s' 'db postgres' 'postgres.db_stat_blks' line 60013 1 '' 'python.d.plugin' 'postgres'
DIMENSION 'postgres_blks_read' 'disk' incremental 1 1 ' '
DIMENSION 'postgres_blks_hit' 'cache' incremental 1 1 ' '

BEGIN postgres_local.postgres_db_stat_blks 0
SET 'postgres_blks_read' = 327807
SET 'postgres_blks_hit' = 79023500
END

CHART postgres_local.Confluence_db_stat_blks '' 'Disk blocks reads from db: Confluence' 'reads/s' 'db Confluence' 'postgres.db_stat_blks' line 60005 1 '' 'python.d.plugin' 'postgres'
DIMENSION 'Confluence_blks_read' 'disk' incremental 1 1 ' '
DIMENSION 'Confluence_blks_hit' 'cache' incremental 1 1 ' '

BEGIN postgres_local.Confluence_db_stat_blks 0
SET 'Confluence_blks_read' = 241340858
SET 'Confluence_blks_hit' = 167786366393
END

CHART postgres_local.stat_bgwriter_backend_fsync '' 'Fsync by backend' 'times' 'bgwriter' 'postgres.stat_bgwriter_backend_fsync' line 60038 1 '' 'python.d.plugin' 'postgres'
DIMENSION 'buffers_backend_fsync' 'backend fsync' incremental 1 1 ' '

BEGIN postgres_local.stat_bgwriter_backend_fsync 0
SET 'buffers_backend_fsync' = 0
END

CHART postgres_local.wal_writes '' 'Write-Ahead Logs' 'KiB/s' 'wal_writes' 'postgres.wal_writes' line 60032 1 '' 'python.d.plugin' 'postgres'
DIMENSION 'wal_writes' 'writes' incremental 1 1024 ' '

BEGIN postgres_local.wal_writes 0
SET 'wal_writes' = 291405861432
END

CHART postgres_local.tx_wraparound_oldest_current_xid '' 'Oldest current XID' 'xid' 'tx_wraparound' 'postgres.tx_wraparound_oldest_current_xid' line 60046 1 '' 'python.d.plugin' 'postgres'
DIMENSION 'oldest_current_xid' 'xid' absolute 1 1 ' '

BEGIN postgres_local.tx_wraparound_oldest_current_xid 0
SET 'oldest_current_xid' = 49807441
END

CHART postgres_local.database_size '' 'Database size' 'MiB' 'database size' 'postgres.db_size' stacked 60024 1 '' 'python.d.plugin' 'postgres'
DIMENSION 'postgres_size' 'postgres' absolute 1 1048576 ' '
DIMENSION 'Confluence_size' 'Confluence' absolute 1 1048576 ' '

BEGIN postgres_local.database_size 0
SET 'postgres_size' = 7027224
SET 'Confluence_size' = 3636386328
END

CHART postgres_local.backend_process '' 'Current Backend Processes' 'processes' 'backend processes' 'postgres.backend_process' line 60025 1 '' 'python.d.plugin' 'postgres'
DIMENSION 'backends_active' 'active' absolute 1 1 ' '
DIMENSION 'backends_idle' 'idle' absolute 1 1 ' '

BEGIN postgres_local.backend_process 0
SET 'backends_active' = 21
SET 'backends_idle' = 0
END

CHART postgres_local.stat_bgwriter_checkpoint '' 'Buffers written during checkpoints' 'KiB/s' 'bgwriter' 'postgres.stat_bgwriter_checkpoint' line 60036 1 '' 'python.d.plugin' 'postgres'
DIMENSION 'buffers_checkpoint' 'checkpoint' incremental 1 1024 ' '

BEGIN postgres_local.stat_bgwriter_checkpoint 0
SET 'buffers_checkpoint' = 265283649536
END

CHART postgres_local.stat_bgwriter_bgwriter '' 'Buffers written by the background writer' 'KiB/s' 'bgwriter' 'postgres.bgwriter_bgwriter' line 60039 1 '' 'python.d.plugin' 'postgres'
DIMENSION 'buffers_clean' 'clean' incremental 1 1024 ' '

BEGIN postgres_local.stat_bgwriter_bgwriter 0
SET 'buffers_clean' = 6839205888
END

CHART postgres_local.Confluence_db_stat_temp_bytes '' 'Temp files written to disk: Confluence' 'KiB/s' 'db Confluence' 'postgres.db_stat_temp_bytes' line 60006 1 '' 'python.d.plugin' 'postgres'
DIMENSION 'Confluence_temp_bytes' 'size' incremental 1 1024 ' '

BEGIN postgres_local.Confluence_db_stat_temp_bytes 0
SET 'Confluence_temp_bytes' = 0
END

CHART postgres_local.stat_bgwriter_backend '' 'Buffers written directly by a backend' 'KiB/s' 'bgwriter' 'postgres.stat_bgwriter_backend' line 60037 1 '' 'python.d.plugin' 'postgres'
DIMENSION 'buffers_backend' 'backend' incremental 1 1024 ' '

BEGIN postgres_local.stat_bgwriter_backend 0
SET 'buffers_backend' = 28070150144
END

CHART postgres_local.stat_bgwriter_maxwritten '' 'Too many buffers written' 'times' 'bgwriter' 'postgres.stat_bgwriter_maxwritten' line 60040 1 '' 'python.d.plugin' 'postgres'
DIMENSION 'maxwritten_clean' 'maxwritten' incremental 1 1 ' '

BEGIN postgres_local.stat_bgwriter_maxwritten 0
SET 'maxwritten_clean' = 960
END

BEGIN netdata.runtime_postgres_local 0
SET run_time = 32
END

2022-01-17 11:22:25: python.d DEBUG: postgres[socket] : update => [OK] (elapsed time: 32, failed retries in a row: 0)
BEGIN postgres_local.Confluence_db_stat_tuple_returned 999433
SET 'Confluence_tup_returned' = 160153894604
SET 'Confluence_tup_fetched' = 82415304808
END

BEGIN postgres_local.Confluence_db_stat_tuple_write 999433
SET 'Confluence_tup_inserted' = 30152083
SET 'Confluence_tup_updated' = 2321650
SET 'Confluence_tup_deleted' = 25995643
SET 'Confluence_conflicts' = 0
END

BEGIN postgres_local.backend_usage 999433
SET 'available' = 76
SET 'used' = 21
END

BEGIN postgres_local.postgres_db_stat_connections 999433
SET 'postgres_connections' = 1
END

BEGIN postgres_local.postgres_db_stat_temp_files 999433
SET 'postgres_temp_files' = 0
END

BEGIN postgres_local.Confluence_db_stat_connections 999433
SET 'Confluence_connections' = 20
END

BEGIN postgres_local.postgres_db_stat_temp_bytes 999433
SET 'postgres_temp_bytes' = 0
END

BEGIN postgres_local.postgres_db_stat_tuple_write 999433
SET 'postgres_tup_inserted' = 0
SET 'postgres_tup_updated' = 0
SET 'postgres_tup_deleted' = 0
SET 'postgres_conflicts' = 0
END

BEGIN postgres_local.Confluence_locks 999433
SET 'Confluence_ExclusiveLock' = 0
SET 'Confluence_RowShareLock' = 0
SET 'Confluence_SIReadLock' = 0
SET 'Confluence_ShareUpdateExclusiveLock' = 0
SET 'Confluence_AccessExclusiveLock' = 0
SET 'Confluence_AccessShareLock' = 0
SET 'Confluence_ShareRowExclusiveLock' = 0
SET 'Confluence_ShareLock' = 0
SET 'Confluence_RowExclusiveLock' = 0
END

BEGIN postgres_local.tx_wraparound_percent_towards_wraparound 999433
SET 'percent_towards_wraparound' = 2
END

BEGIN postgres_local.postgres_db_stat_transactions 999433
SET 'postgres_xact_commit' = 2177129
SET 'postgres_xact_rollback' = 774
END

BEGIN postgres_local.postgres_db_stat_tuple_returned 999433
SET 'postgres_tup_returned' = 1096071679
SET 'postgres_tup_fetched' = 15620730
END

BEGIN postgres_local.stat_bgwriter_alloc 999433
SET 'buffers_alloc' = 247867736064
END

BEGIN postgres_local.checkpointer 999433
SET 'checkpoint_scheduled' = 215616
SET 'checkpoint_requested' = 0
END

BEGIN postgres_local.postgres_locks 999433
SET 'postgres_ExclusiveLock' = 0
SET 'postgres_RowShareLock' = 0
SET 'postgres_SIReadLock' = 0
SET 'postgres_ShareUpdateExclusiveLock' = 0
SET 'postgres_AccessExclusiveLock' = 0
SET 'postgres_AccessShareLock' = 1
SET 'postgres_ShareRowExclusiveLock' = 0
SET 'postgres_ShareLock' = 0
SET 'postgres_RowExclusiveLock' = 0
END

BEGIN postgres_local.Confluence_db_stat_transactions 999433
SET 'Confluence_xact_commit' = 2104351077
SET 'Confluence_xact_rollback' = 2585842
END

BEGIN postgres_local.Confluence_db_stat_temp_files 999433
SET 'Confluence_temp_files' = 0
END

BEGIN postgres_local.autovacuum 999433
SET 'analyze' = 0
SET 'vacuum' = 0
SET 'vacuum_analyze' = 0
SET 'vacuum_freeze' = 0
SET 'brin_summarize' = 0
END

BEGIN postgres_local.postgres_db_stat_blks 999433
SET 'postgres_blks_read' = 327807
SET 'postgres_blks_hit' = 79024267
END

BEGIN postgres_local.Confluence_db_stat_blks 999433
SET 'Confluence_blks_read' = 241340858
SET 'Confluence_blks_hit' = 167786366422
END

BEGIN postgres_local.stat_bgwriter_backend_fsync 999433
SET 'buffers_backend_fsync' = 0
END

BEGIN postgres_local.wal_writes 999433
SET 'wal_writes' = 291405867344
END

BEGIN postgres_local.tx_wraparound_oldest_current_xid 999433
SET 'oldest_current_xid' = 49807443
END

BEGIN postgres_local.database_size 999433
SET 'postgres_size' = 7027224
SET 'Confluence_size' = 3636386328
END

BEGIN postgres_local.backend_process 999433
SET 'backends_active' = 21
SET 'backends_idle' = 0
END

BEGIN postgres_local.stat_bgwriter_checkpoint 999433
SET 'buffers_checkpoint' = 265283649536
END

BEGIN postgres_local.stat_bgwriter_bgwriter 999433
SET 'buffers_clean' = 6839205888
END

BEGIN postgres_local.Confluence_db_stat_temp_bytes 999433
SET 'Confluence_temp_bytes' = 0
END

BEGIN postgres_local.stat_bgwriter_backend 999433
SET 'buffers_backend' = 28070150144
END

BEGIN postgres_local.stat_bgwriter_maxwritten 999433
SET 'maxwritten_clean' = 960
END

BEGIN netdata.runtime_postgres_local 999433
SET run_time = 29
END

2022-01-17 11:22:26: python.d DEBUG: postgres[socket] : update => [OK] (elapsed time: 29, failed retries in a row: 0)
^C2022-01-17 11:22:26: python.d INFO: plugin[main] : exiting from main..

What I expected to happen

I cannot find any Chart graphics in the dashboard.
Am I missing anything?

Thanks
Bernd

2

Hi @Bernd ,
I’d just like to check, did you restart the Netdata agent?
If you restart the agent and postgres doesn’t appear could you please share the error.log with me?

Thanks!

3

Thank you for your response!
Yes I did restart and refresh the site as well
in Error log is this:

2022-01-17 14:35:54: netdata INFO  : MAIN : TIMEZONE: using the contents of /etc/timezone
2022-01-17 14:35:54: netdata INFO  : MAIN : TIMEZONE: fixed as 'Europe/Berlin'
2022-01-17 14:35:54: netdata INFO  : MAIN : SIGNAL: Not enabling reaper
2022-01-17 14:35:54: netdata ERROR : MAIN : LISTENER: IPv4 bind() on ip '0.0.0.0' port 19999, socktype 1 failed. (errno 98, Address in use)
2022-01-17 14:35:54: netdata ERROR : MAIN : LISTENER: Cannot bind to ip '0.0.0.0', port 19999
2022-01-17 14:35:54: netdata ERROR : MAIN : LISTENER: IPv6 bind() on ip '::' port 19999, socktype 1 failed. (errno 98, Address in use)
2022-01-17 14:35:54: netdata ERROR : MAIN : LISTENER: Cannot bind to ip '::', port 19999
2022-01-17 14:35:54: netdata FATAL : MAIN : LISTENER: Cannot listen on any API socket. Exiting... # : Invalid argument

2022-01-17 14:35:54: netdata INFO  : MAIN : EXIT: netdata prepares to exit with code 1...
2022-01-17 14:35:54: netdata INFO  : MAIN : EXIT: cleaning up the database...
2022-01-17 14:35:54: netdata INFO  : MAIN : Cleaning up database [0 hosts(s)]...
2022-01-17 14:35:54: netdata INFO  : MAIN : EXIT: removing netdata PID file '/opt/netdata/var/run/netdata/netdata.pid'...
2022-01-17 14:35:54: netdata ERROR : MAIN : EXIT: cannot unlink pidfile '/opt/netdata/var/run/netdata/netdata.pid'. (errno 2, No such file or directory)
2022-01-17 14:35:54: netdata INFO  : MAIN : EXIT: all done - netdata is now exiting - bye bye...
2022-01-17 14:36:02: netdata INFO  : MAIN : TIMEZONE: using the contents of /etc/timezone
2022-01-17 14:36:02: netdata INFO  : MAIN : TIMEZONE: fixed as 'Europe/Berlin'
2022-01-17 14:36:02: netdata INFO  : MAIN : SIGNAL: Not enabling reaper
2022-01-17 14:36:02: netdata ERROR : MAIN : LISTENER: IPv4 bind() on ip '0.0.0.0' port 19999, socktype 1 failed. (errno 98, Address in use)
2022-01-17 14:36:02: netdata ERROR : MAIN : LISTENER: Cannot bind to ip '0.0.0.0', port 19999
2022-01-17 14:36:02: netdata ERROR : MAIN : LISTENER: IPv6 bind() on ip '::' port 19999, socktype 1 failed. (errno 98, Address in use)
2022-01-17 14:36:02: netdata ERROR : MAIN : LISTENER: Cannot bind to ip '::', port 19999
2022-01-17 14:36:02: netdata FATAL : MAIN : LISTENER: Cannot listen on any API socket. Exiting... # : Invalid argument

2022-01-17 14:36:02: netdata INFO  : MAIN : EXIT: netdata prepares to exit with code 1...
2022-01-17 14:36:02: netdata INFO  : MAIN : EXIT: cleaning up the database...
2022-01-17 14:36:02: netdata INFO  : MAIN : Cleaning up database [0 hosts(s)]...
2022-01-17 14:36:02: netdata INFO  : MAIN : EXIT: removing netdata PID file '/opt/netdata/var/run/netdata/netdata.pid'...
2022-01-17 14:36:02: netdata ERROR : MAIN : EXIT: cannot unlink pidfile '/opt/netdata/var/run/netdata/netdata.pid'. (errno 2, No such file or directory)
2022-01-17 14:36:02: netdata INFO  : MAIN : EXIT: all done - netdata is now exiting - bye bye...
2022-01-17 14:36:33: netdata INFO  : MAIN : TIMEZONE: using the contents of /etc/timezone
2022-01-17 14:36:33: netdata INFO  : MAIN : TIMEZONE: fixed as 'Europe/Berlin'
2022-01-17 14:36:33: netdata INFO  : MAIN : SIGNAL: Not enabling reaper
2022-01-17 14:36:33: netdata ERROR : MAIN : LISTENER: IPv4 bind() on ip '0.0.0.0' port 19999, socktype 1 failed. (errno 98, Address in use)
2022-01-17 14:36:33: netdata ERROR : MAIN : LISTENER: Cannot bind to ip '0.0.0.0', port 19999
2022-01-17 14:36:33: netdata ERROR : MAIN : LISTENER: IPv6 bind() on ip '::' port 19999, socktype 1 failed. (errno 98, Address in use)
2022-01-17 14:36:33: netdata ERROR : MAIN : LISTENER: Cannot bind to ip '::', port 19999
2022-01-17 14:36:33: netdata FATAL : MAIN : LISTENER: Cannot listen on any API socket. Exiting... # : Invalid argument

2022-01-17 14:36:33: netdata INFO  : MAIN : EXIT: netdata prepares to exit with code 1...
2022-01-17 14:36:33: netdata INFO  : MAIN : EXIT: cleaning up the database...
2022-01-17 14:36:33: netdata INFO  : MAIN : Cleaning up database [0 hosts(s)]...
2022-01-17 14:36:33: netdata INFO  : MAIN : EXIT: removing netdata PID file '/opt/netdata/var/run/netdata/netdata.pid'...
2022-01-17 14:36:33: netdata ERROR : MAIN : EXIT: cannot unlink pidfile '/opt/netdata/var/run/netdata/netdata.pid'. (errno 2, No such file or directory)
2022-01-17 14:36:33: netdata INFO  : MAIN : EXIT: all done - netdata is now exiting - bye bye...

The errorlog has “exiting” at last. But is running …

4

Because I did a service restart netdata did try to early, the port was not free enough. but this shall not the problem

5

Thanks for the context @Bernd
Did you configure postgres as described in our documentation?

I also found this reply from one of our team members with some steps you can follow in order to safely restart the service.

6

What can I say? You have hit the nail on the head.
The hint with killall netdata was spot on.
Apparently the service restart did not work completely.
Unfortunately I didn’t check for leftover processes before.
Anyway - the charts of postgres are there now!
Thanks! @georgia
–Bernd

7

Happy it worked for you Bernd!
Have a good one!