Thread: Performance Testing Metrics
Hello All, I need help to know how to get below things in Postgresql :- 1) No. of active connections? 2) No. of non-responding connections? 3) Queries which are running beyond time(i.e. time which 'll set in database query)? 5) Dead Locked Queries? 4) Process ID's of dead-locked queries? 5) No. of queries in non-responding state? -- View this message in context: http://postgresql.1045698.n5.nabble.com/Performance-Testing-Metrics-tp5732897.html Sent from the PostgreSQL - general mailing list archive at Nabble.com.
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
Le mardi 20 novembre 2012 à 03:54 -0800, Harry a écrit : > Hello All, > > I need help to know how to get below things in Postgresql :- > 1) No. of active connections? > 2) No. of non-responding connections? > 3) Queries which are running beyond time(i.e. time which 'll set in database > query)? > 5) Dead Locked Queries? > 4) Process ID's of dead-locked queries? > 5) No. of queries in non-responding state? > > Most of this is explained here : http://www.postgresql.org/docs/9.2/static/monitoring.html > > -- > View this message in context: http://postgresql.1045698.n5.nabble.com/Performance-Testing-Metrics-tp5732897.html > Sent from the PostgreSQL - general mailing list archive at Nabble.com. > > -- Vincent Veyron http://marica.fr/ Logiciel de gestion des assurances sinistres et des dossiers contentieux pour le service juridique