Нет данных от Postgres12 в Zabbix5

[Vanchez]

Темплейты и агенты настроены, ps_state_statements есть, но не все данные доступны.

DB zabbix: Blocks hit per second 2225.8487
DB zabbix: Commits per second 21.415
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 340.3641
DB zabbix: Frozen XID before avtovacuum % 99.3161 %
DB zabbix: Frozen XID before stop % 99.9363 %
DB zabbix: Index scans per second 632
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.4486
DB zabbix: Sequential scans per second 9.2284
DB zabbix: Temp_bytes written per second 0 B
DB zabbix: Temp_files created per second 0
DB zabbix: Tuples deleted per second 0.04984
DB zabbix: Tuples fetched per second 1079.8382
DB zabbix: Tuples inserted per second 36.8491
DB zabbix: Tuples returned per second 3412.6623
DB zabbix: Tuples updated per second 0.5483

Посоветуйте плиз где посмотреть и что поправить.
Заранее спасибо.

[Hamardaban]

смотреть - в логи. постгреса и забикса

пробовать выполнить ручками выражения проблемных ЭД и смотреть что не так.

[Vanchez]

С Query time какие-то проблемы

bash-4.2$ psql -qtAX -h "$1" -p "$2" -U "$3" -d "$4" -v tmax=$5 -f "/var/lib/zabbix/postgresql/pgsql.query.time.sql"
psql:/var/lib/zabbix/postgresql/pgsql.query.time.sql:31: ERROR: syntax error at or near ")"
СТРОКА 22: ...'epoch' FROM (clock_timestamp() - query_start)) > )::integer...

В самом запросе не пойму нде ошибка, подскажите в чем проблема пожалуйста

WITH T AS
(SELECT db.datname,
coalesce(T.query_time_max, 0) query_time_max,
coalesce(T.tx_time_max, 0) tx_time_max,
coalesce(T.mro_time_max, 0) mro_time_max,
coalesce(T.query_time_sum, 0) query_time_sum,
coalesce(T.tx_time_sum, 0) tx_time_sum,
coalesce(T.mro_time_sum, 0) mro_time_sum,
coalesce(T.query_slow_count, 0) query_slow_count,
coalesce(T.tx_slow_count, 0) tx_slow_count,
coalesce(T.mro_slow_count, 0) mro_slow_count
FROM pg_database db NATURAL
LEFT JOIN (
SELECT datname,
extract(epoch FROM now())::integer ts,
coalesce(max(extract('epoch' FROM (clock_timestamp() - query_start))::integer * (state NOT IN ('idle', 'idle in transaction', 'idle in transaction (aborted)') AND query !~* E'^(\\s*(--[^\\n]*\\n|/\\*.*\\*/|\\n))*(autovacuum|VACUUM|ANALYZE|REINDEX|CLUSTER| CREATE|ALTER|TRUNCATE|DROP)')::integer), 0) query_time_max,
coalesce(max(extract('epoch' FROM (clock_timestamp() - query_start))::integer * (state NOT IN ('idle') AND query !~* E'^(\\s*(--[^\\n]*\\n|/\\*.*\\*/|\\n))*(autovacuum|VACUUM|ANALYZE|REINDEX|CLUSTER| CREATE|ALTER|TRUNCATE|DROP)')::integer), 0) tx_time_max,
coalesce(max(extract('epoch' FROM (clock_timestamp() - query_start))::integer * (state NOT IN ('idle') AND query ~* E'^(\\s*(--[^\\n]*\\n|/\\*.*\\*/|\\n))*(autovacuum|VACUUM|ANALYZE|REINDEX|CLUSTER| CREATE|ALTER|TRUNCATE|DROP)')::integer), 0) mro_time_max,
coalesce(sum(extract('epoch' FROM (clock_timestamp() - query_start))::integer * (state NOT IN ('idle', 'idle in transaction', 'idle in transaction (aborted)') AND query !~* E'^(\\s*(--[^\\n]*\\n|/\\*.*\\*/|\\n))*(autovacuum|VACUUM|ANALYZE|REINDEX|CLUSTER| CREATE|ALTER|TRUNCATE|DROP)')::integer), 0) query_time_sum,
coalesce(sum(extract('epoch' FROM (clock_timestamp() - query_start))::integer * (state NOT IN ('idle') AND query !~* E'^(\\s*(--[^\\n]*\\n|/\\*.*\\*/|\\n))*(autovacuum|VACUUM|ANALYZE|REINDEX|CLUSTER| CREATE|ALTER|TRUNCATE|DROP)')::integer), 0) tx_time_sum,
coalesce(sum(extract('epoch' FROM (clock_timestamp() - query_start))::integer * (state NOT IN ('idle') AND query ~* E'^(\\s*(--[^\\n]*\\n|/\\*.*\\*/|\\n))*(autovacuum|VACUUM|ANALYZE|REINDEX|CLUSTER| CREATE|ALTER|TRUNCATE|DROP)')::integer), 0) mro_time_sum,

coalesce(sum((extract('epoch' FROM (clock_timestamp() - query_start)) > :tmax)::integer * (state NOT IN ('idle', 'idle in transaction', 'idle in transaction (aborted)') AND query !~* E'^(\\s*(--[^\\n]*\\n|/\\*.*\\*/|\\n))*(autovacuum|VACUUM|ANALYZE|REINDEX|CLUSTER| CREATE|ALTER|TRUNCATE|DROP)')::integer), 0) query_slow_count,
coalesce(sum((extract('epoch' FROM (clock_timestamp() - query_start)) > :tmax)::integer * (state NOT IN ('idle') AND query !~* E'^(\\s*(--[^\\n]*\\n|/\\*.*\\*/|\\n))*(autovacuum|VACUUM|ANALYZE|REINDEX|CLUSTER| CREATE|ALTER|TRUNCATE|DROP)')::integer), 0) tx_slow_count,
coalesce(sum((extract('epoch' FROM (clock_timestamp() - query_start)) > :tmax)::integer * (state NOT IN ('idle') AND query ~* E'^(\\s*(--[^\\n]*\\n|/\\*.*\\*/|\\n))*(autovacuum|VACUUM|ANALYZE|REINDEX|CLUSTER| CREATE|ALTER|TRUNCATE|DROP)')::integer), 0) mro_slow_count
FROM pg_stat_activity
WHERE pid <> pg_backend_pid()
GROUP BY 1) T
WHERE NOT db.datistemplate )
SELECT json_object_agg(datname, row_to_json(T))
FROM T