Hello, Thursday, November 6, 2003, 1:48:25 PM, I wrote:
BP> Is there a way to tell which session from 'select * from BP> pg_stat_activity' is a current session? Obviously if there's way BP> to find out pid of a current session by some other means I could BP> then look the rest in pg_stat_activity. Please nevermind, I must have missed it in the docs the first time. select * from pg_stat_activity where procpid = pg_backend_pid(); -- -Boris ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
