pid of current session?
Started by Boris Popovover 22 years ago2 messagesgeneral
Hello pgsql-general,
Is there a way to tell which session from 'select * from
pg_stat_activity' is a current session? Obviously if there's way to
find out pid of a current session by some other means I could then
look the rest in pg_stat_activity.
Thanks!
--
-Boris
Re: pid of current session?
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