2ndquadrant / zabbix_templates Goto Github PK

View Code? Open in Web Editor NEW

7.0 12.0 21.0 29 KB

Various templates for Zabbix

License: MIT License

zabbix_templates's People

Contributors

Stargazers

Watchers

zabbix_templates's Issues

pgstattuple、pg_buffercache这两个扩展在每个数据库上都要装吗？还是只装到zabbix数据库就行了？

pgstattuple - Used by Table Bloat monitoring
pg_buffercache - Buffer Statistics

这两个扩展在每个数据库上都要装吗？还是只装到zabbix数据库就行了？

Wrong UserParameter for "WAL segments count" and "WAL write" for PG10+

Hi.

Actualy the UserParameters are

UserParameter=pgsql.wal.write[*],psql -qAtX $1 -c "select pg_xlog_location_diff(pg_current_xlog_location(),'0/00000000')"
UserParameter=pgsql.wal.count[*],psql -qAtX $1 -c "select count(*) from pg_ls_dir('pg_xlog')"

But they don't work on PG10+, so they should be modified to

UserParameter=pgsql.wal.write[*],psql -qAtX $1 -c "select pg_wal_lsn_diff(pg_current_wal_lsn(),'0/00000000')"
UserParameter=pgsql.wal.count[*],psql -qAtX $1 -c "select count(*) from pg_ls_dir('pg_wal')"

We've tested those changes on our environment end they works well.

Best Regards.

Recommend Projects