I
I
Ivan2020-08-20 15:15:14
PostgreSQL
Ivan, 2020-08-20 15:15:14

No data from Postgres12 to Zabbix5?

Templates and agents are configured, ps_state_statements are there, but not all data is available.

DB zabbix: Blocks hit per second	1451.5625
DB zabbix: Commits per second	12.4837
DB zabbix: Database size	1.78 GB
DB zabbix: Detected conflicts per second	0
DB zabbix: Detected deadlocks per second	0
DB zabbix: Disk blocks read per second	0.3963
DB zabbix: Frozen XID before avtovacuum %	99.3164 %
DB zabbix: Frozen XID before stop %	99.9363 %
DB zabbix: Index scans per second	434
DB zabbix: Locks total	0
DB zabbix: Queries max maintenance time	0
DB zabbix: Queries max query time	0
DB zabbix: Queries max transaction time	0
DB zabbix: Queries slow maintenance count	0
DB zabbix: Queries slow query count	0
DB zabbix: Queries slow transaction count	0
DB zabbix: Queries sum maintenance time	0
DB zabbix: Queries sum query time	0
DB zabbix: Queries sum transaction time	0
DB zabbix: Rollbacks per second	0.3303
DB zabbix: Sequential scans per second	5.8557
DB zabbix: Temp_bytes written per second	0 B
DB zabbix: Temp_files created per second	0
DB zabbix: Tuples deleted per second	0
DB zabbix: Tuples fetched per second	693.6555
DB zabbix: Tuples inserted per second	36.3283
DB zabbix: Tuples returned per second	2530.7436
DB zabbix: Tuples updated per second	0.3798


Advise pliz where to look and what to fix.
Thanks in advance.

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question