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)?
>
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 a
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
