Marcin Krol <mrkafk(at)gmail(dot)com> writes:
> I use an app (developed by someone else) that uses Postgres 8.3 as
> backend. The app in question starts up for a rather long time, about 10
> minutes, during which Postgres is heavily loaded (several processes each
> eating 50%-100% of CPU on the multicore server).
> However, when I do "select * from pg_stat_activity" during the startup,
> all the connections seem to be idle (see below).
You seem to have missed the load --- most of those connections have been
idle for a minute or two.
> I have found here info that current query stats have to be explicitly
> turned on in postgresql.conf - is that true?
As of 8.3 they're on by default, see track_activities.
regards, tom lane
In response to
pgsql-novice by date
|Next:||From: Robert Hollingsworth||Date: 2008-11-05 17:34:33|
|Subject: basic security|
|Previous:||From: Tom Lane||Date: 2008-11-05 15:28:12|
|Subject: Re: Does pg_dumpall support BLOBs? |