--On 16. Juni 2011 15:33:35 +0000 Greg Sabino Mullane <g...@turnstep.com> wrote:
No, this is clearly connections, not sessions. At least based on the items in the postgresql.conf file, especially max_connections (probably one of the items most closely associated with pg_stat_activity)
Well, but it doesn't show database connection(s) only, it also shows what actions are currently performed through the various connections on the databases and state information about them. I'm not a native english speaker, but i have the feeling that "sessions" is better suited for this kind of interactive monitoring. I believe Oracle also has a v$session view to query various information about what's going on.
-- Thanks Bernd -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers