Re: Rethinking stats communication mechanisms

Greg Stark <gsstark(at)mit(dot)edu> writes:

> PFC <lists(at)peufeu(dot)com> writes:
>
>> - Will only be of use if the command is taking a long, long time.
>> So, it need not be realtime ; no problem if the data comes with a
>> little delay, or not at all if the command executes quickly.
>
> I would dispute this point. Picture a system running a very short very very
> often. It may still be the main problem, may even be taking 90+% of the cpu
> time. If you got an accurate snapshot of all the currently executing queries
> you'll see it popping up suspiciously often.

Yeah, but if you turn on query logging in that case you'll see the
bajillions of short queries, so you don't need the accurate snapshot
to diagnose that.

-Doug