Re: Selects query stats? - Mailing list pgsql-performance

From Tom Lane
Subject Re: Selects query stats?
Date
Msg-id 19283.1148414150@sss.pgh.pa.us
Whole thread Raw
In response to Re: Selects query stats?  (Alvaro Herrera <alvherre@commandprompt.com>)
Responses Re: Selects query stats?  (Simon Riggs <simon@2ndquadrant.com>)
List pgsql-performance
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

pgsql-performance by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Selects query stats?
Next
From: "Jim C. Nasby"
Date:
Subject: Re: Selects query stats?