# Monitoring postgres does not show anything

**URL:** <https://community.netdata.cloud/t/monitoring-postgres-does-not-show-anything/2421>\
**Category:** Help\
**Tags:** agent-collector, agent\
**Created:** [January 17, 2022, 10:28am UTC](https://community.netdata.cloud/t/monitoring-postgres-does-not-show-anything/2421 "2022-01-17T10:28:33Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![Bernd](https://yyz1.discourse-cdn.com/flex029/user_avatar/community.netdata.cloud/bernd/32/1460_2.png) [@Bernd](https://community.netdata.cloud/u/Bernd)\
**Post date:** [January 17, 2022, 10:28am UTC](https://community.netdata.cloud/t/monitoring-postgres-does-not-show-anything/2421/1 "2022-01-17T10:28:33Z")

</div>

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:

```auto
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

---

<div class="post-metadata">

**Author:** ![GeorgiaTs](https://yyz1.discourse-cdn.com/flex029/user_avatar/community.netdata.cloud/georgiats/32/1195_2.png) [@GeorgiaTs](https://community.netdata.cloud/u/GeorgiaTs)\
**Post date:** [January 17, 2022, 1:23pm UTC](https://community.netdata.cloud/t/monitoring-postgres-does-not-show-anything/2421/2 "2022-01-17T13:23:59Z")

</div>

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](https://learn.netdata.cloud/docs/agent/daemon#log-files) with me?

Thanks!

---

<div class="post-metadata">

**Author:** ![Bernd](https://yyz1.discourse-cdn.com/flex029/user_avatar/community.netdata.cloud/bernd/32/1460_2.png) [@Bernd](https://community.netdata.cloud/u/Bernd)\
**Post date:** [January 17, 2022, 1:41pm UTC](https://community.netdata.cloud/t/monitoring-postgres-does-not-show-anything/2421/3 "2022-01-17T13:41:16Z")

</div>

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

```auto
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 …

---

<div class="post-metadata">

**Author:** ![Bernd](https://yyz1.discourse-cdn.com/flex029/user_avatar/community.netdata.cloud/bernd/32/1460_2.png) [@Bernd](https://community.netdata.cloud/u/Bernd)\
**Post date:** [January 17, 2022, 1:43pm UTC](https://community.netdata.cloud/t/monitoring-postgres-does-not-show-anything/2421/4 "2022-01-17T13:43:46Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![GeorgiaTs](https://yyz1.discourse-cdn.com/flex029/user_avatar/community.netdata.cloud/georgiats/32/1195_2.png) [@GeorgiaTs](https://community.netdata.cloud/u/GeorgiaTs)\
**Post date:** [January 17, 2022, 3:32pm UTC](https://community.netdata.cloud/t/monitoring-postgres-does-not-show-anything/2421/5 "2022-01-17T15:32:51Z")

</div>

Thanks for the context @Bernd  
Did you configure postgres as described in our [documentation](https://learn.netdata.cloud/docs/agent/collectors/python.d.plugin/postgres#configuration)?

I also found this reply from one of our team members with some steps you can follow in order to [safely restart the service](https://community.netdata.cloud/t/unable-to-start-netdata-service/535/8).

---

<div class="post-metadata">

**Author:** ![Bernd](https://yyz1.discourse-cdn.com/flex029/user_avatar/community.netdata.cloud/bernd/32/1460_2.png) [@Bernd](https://community.netdata.cloud/u/Bernd)\
**Post date:** [January 17, 2022, 4:11pm UTC](https://community.netdata.cloud/t/monitoring-postgres-does-not-show-anything/2421/6 "2022-01-17T16:11:52Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![GeorgiaTs](https://yyz1.discourse-cdn.com/flex029/user_avatar/community.netdata.cloud/georgiats/32/1195_2.png) [@GeorgiaTs](https://community.netdata.cloud/u/GeorgiaTs)\
**Post date:** [January 17, 2022, 4:15pm UTC](https://community.netdata.cloud/t/monitoring-postgres-does-not-show-anything/2421/7 "2022-01-17T16:15:18Z")

</div>

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