Excerpts from Greg Sabino Mullane's message of jue jun 16 15:33:35 UTC 2011:
>
> Hash: RIPEMD160
>
> >> Or perhaps pg_connections. Yes, +1 to making things fully backwards
> >> compatible by keeping pg_stat_activity around but making a better
> >> designed and better named table (view/SRF/whatever).
>
> > I thought about that too when reading the thread the first time, but
> > "pg_stat_sessions" sounds better. Our documentation also primarily refers to a
> > database connection as a "session", i think.
>
> 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)
That doesn't include autovacuum, though, whereas the new view would.
--
Álvaro Herrera <alvherre@commandprompt.com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support