Re: Configuration of statistical views

Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
>> If somebody wants to see an applications querystring (at
>> least the first 512 bytes) just in case something goes wrong
>> and the client hangs, he'd have to run querystring reporting
>> all the time either way.

> Agreed. That should be on all the time.

"On by default", sure. "On all the time", I'm not sold on.

But anyway, we seem to be converging on the conclusion that setting
up a GUC variable will do fine, at least until there is definite
evidence that it won't.

Probably there need to be at least 2 variables: (a) a PGC_POSTMASTER
variable that controls whether the stats collector is even started,
and (b) PGC_USERSET variable(s) that enable a particular backend to
send particular kinds of data to the collector. Note that, for example,
backend start/stop events probably need to be reported whenever the
postmaster variable is set, even if all the USERSET variables are off.

regards, tom lane