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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
