How to monitor PostgreSQL processes
pg_top is ‘top’ for PostgreSQL. It is derived from Unix Top. Similar to top, pg_top allows you to monitor PostgreSQL processes. It also allows you to:
- View currently running SQL statement of a process.
- View query plan of a currently running SQL statement.
- View locks held by a process.
- View user table statistics.
- View user index statistics.
You can download it here…
How to install it :
- tar xvzf pg_top-3.6.2.tar.gz
- yum install postgresql-devel
- yum install ncurses-devel
- ./configure
- make
A quick example :
- ./pg_top -U username-d database -h localhost -W
More information :
- ./pg_top –help
An interestesting slideshare :
December 2, 2008 | Filed Under IT
Comments
Leave a Reply