Harry wrote: > I need help to know how to get below things in Postgresql :- > 1) No. of active connections? Can be selected from pg_stat_activity. The exact query depends on PostgreSQL version and on what you consider "active" to mean. > 2) No. of non-responding connections? > 3) Queries which are running beyond time(i.e. time which 'll set in > database query)? How will you set that? What is the difference from "non-responding connections"? > 5) Dead Locked Queries? > 4) Process ID's of dead-locked queries? Deadlocks are automatically resolved and logged. Check the log. > 5) No. of queries in non-responding state? How is that different from "non-responding connections" in 2? You might want to check on the tools mentioned on this page: http://wiki.postgresql.org/wiki/Monitoring If points 2, 3, and the second point 5 are about blocking, you might be interested in these pages: http://wiki.postgresql.org/wiki/Lock_Monitoring http://wiki.postgresql.org/wiki/Lock_dependency_information -Kevin -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
