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.
Depending on how you need to access the information, you should also check out the logging options available to you:
