Re: Performance Testing Metrics

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