Monitoring tool for PostgreSQL database server. Prints full sql code for the query in pg_top with lot of related parameters like CPU and memory usage, run time and client command, etc. It designed for use with zabbix, but may be invoked as standalone script as well.
Requirements include software it depends on:
They both are available in most Linux distributions as packages.
as simple as run
sudo make
after pulling this repository. To remove is not less easy:
sudo make uninstall
Do configure zabbix with key pg_top.query (don't forget restart zabbix_agentd on target server) and see "latest data" or become postgres user:
su - postgres
and enjoy with command line:
pg_top_query