That was it. (not having it turned on. duh).
Guess I should have read section 23.2 of the docs..."The Statistics
Collector"
Thanks for the heads up.
Jeff
Tom Lane wrote:
Jeff Amiel <[EMAIL PROTECTED]> writes:
however, if I checked pg_stat_activity during the same time period, I
saw nothing
Jeff Amiel <[EMAIL PROTECTED]> writes:
> however, if I checked pg_stat_activity during the same time period, I
> saw nothing populated in the current_query column...ever.
Did you have it turned on? (stats_command_string config parameter)
Were you checking as superuser?
I ran a home-grown self continuous stress test tool against my 7.4.2
database.
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
