Re: procpid?

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