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 Lane||Date: 2004-08-24 14:57:13|
|Subject: Re: Bad planner results |
|Previous:||From: Tatsuo Ishii||Date: 2004-08-24 14:52:23|
|Subject: Re: UTF-8 and LIKE vs =|