Skip site navigation (1) Skip section navigation (2)

pg_stat_activity versus ps

From: Jeff Amiel <jamiel(at)istreamimaging(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: pg_stat_activity versus ps
Date: 2004-08-24 14:56:54
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-general
I ran a home-grown self continuous stress test tool against my 7.4.2 

I banged 'ps' (running freebsd) while it was active and witnessed 
several of the 'back end' postgres processes exeucting queries, commits, 
inserts, etc....(the actual work the processes were doing was listed in 
the 'ps' output)
however, if I checked pg_stat_activity during the same time period, I 
saw nothing populated in the current_query column...ever.

Am I misunderstanding what the pg_stat_activity table is for?  I 
confirmed that the procpid listed in pg_stat_activity was the same as 
listed in my 'ps' process list....



pgsql-general by date

Next:From: Tom LaneDate: 2004-08-24 14:57:13
Subject: Re: Bad planner results
Previous:From: Tatsuo IshiiDate: 2004-08-24 14:52:23
Subject: Re: UTF-8 and LIKE vs =

Privacy Policy | About PostgreSQL
Copyright © 1996-2018 The PostgreSQL Global Development Group