Re: Problems monitoring DB activity

On Fri, Oct 08, 2004 at 10:46:56AM -0400, Doug Y wrote:
> Michael Fuhr wrote:
> >
> >Does postgresql.conf have stats_command_string = true?
> >
> Thanks, setting that did the trick.... whats the performance hit for
> having it enabled?

I haven't done any tests to determine the performance penalty; maybe
one of the developers or somebody who's done some benchmarks can
comment.

The "Annotated postgresql.conf and Global User Configuration (GUC)
Guide"[1] says that "Enabling statistics collection costs a small
amount of time per query, but is invaluable for debugging and
performance tuning."

[1] http://www.varlena.com/varlena/GeneralBits/Tidbits/annotated_conf_e.html

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/