Re: Open connections details

[hubert depesz lubaczewski <depesz@xxxxxxxxx>]

On 11/8/05, Andrew Watters <andrew@xxxxxxxxxxxxx> 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