Postgres Pro
Downloads
Home   >   mailing lists

Re: Open connections details - Mailing list pgsql-admin

From hubert depesz lubaczewski
Subject Re: Open connections details
Date
Msg-id 9e4684ce0511082224i52cdc6b8te0de74f779dd2968@mail.gmail.com
Whole thread Raw
In response to Open connections details  (Andrew Watters <andrew@gocontent.com>)
Responses Re: Open connections details
List pgsql-admin
Tree view
On 11/8/05, Andrew Watters <andrew@gocontent.com> wrote:
I am trying to find details about open connections. I can see that there
are open connections through Tools | Server Status in pgAdmin III. How
can I find what the current and/or last SQL statement was that was run
in those open connections please?

select * from pg_stat_activity;
you might have to turn on stats_command_string in postgresql.conf.

depesz

pgsql-admin by date:

Previous
From: shenanigans
Date:
Subject: Roomity.com v 1.5 is a web 2.01
Next
From: "Marc A. Donis"
Date:
Subject: Fwd: resetting superuser password