Re: Selects query stats?

Alvaro Herrera <alvherre@commandprompt.com> writes:
> OTOH ISTM it would be easy to modify Postgres so as to count statements
> in the stat collector, by turning pgstat_report_activity into a routine
> that sent a count (presumably always 1) instead of the query string, and
> then just add the count to a counter on receiving.

You wouldn't have to change the backends at all, just modify the
collector to count the number of report_activity messages received.
Might have to play some games with ignoring "<IDLE>" messages, but
otherwise simple (and simplistic...)

            regards, tom lane