Performance Testing Metrics

From: Harry <shirlekar(dot)harshal(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Performance Testing Metrics
Date: 2012-11-20 11:54:21
Message-ID: 1353412461858-5732897.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message aasat 2012-11-20 12:30:55 fetch from cursor in pg_stats_activity and related SQL query
Previous Message Pavel Stehule 2012-11-20 10:40:00 Re: get source of udf