zabbix_DB_monitoring

https://www.zabbix.com/documentation/current/ru/manual/config/items/itemtypes/odbc_checks

yum search postgre | grep odbc
yum install postgresql-odbc.x86_64 unixODBC-devel -y
odbcinst -j
vim /etc/odbc.ini
[zabbix]
Description         = PostgreSQL connection to ZabbixDB
Driver              = PostgreSQL
Database            = zabbix
Servername          = localhost
UserName            = zabbix
Password            = Z@bbix123
Port                = 5432
isql -v zabbix

select pg_database_size('zabbix');
Discovery rule
select table_name from information_schema.tables where table_schema='public' ;
item_prototype
SELECT pg_total_relation_size('{#TABLE_NAME}');
SELECT pg_total_relation_size('history');