pgadmin3 could be an option. Server status will tell you what queries are being running, from what clients, and what tables are being locked. It should come with your linux distro. -----Original Message----- From: Khangelani Gama <Khangelani.Gama@xxxxxxxxxxxxxxxxxx> To: pgsql-admin@xxxxxxxxxxxxxx <pgsql-admin@xxxxxxxxxxxxxx> Subject: Postgres Monitoring Tool we can use Date: Fri, 16 Jul 2010 14:10:58 +0200 Hi Can someone suggest the best monitoring tool we can use in out enterprise db running on version 8.3 with Linux Redhat 5. We just need something that can tell us if there is any activity inside the database and what that activity is. Thanks in Advanced Khangelani (Junior DBA) |