On Tue, 2006-05-23 at 15:55 -0400, Tom Lane wrote: > Alvaro Herrera <alvherre@xxxxxxxxxxxxxxxxx> 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...) The OP wanted statements/sec rather than just a total. Having stats logged by time would be very useful, but I wouldn't limit that just to numbers of statements in each time period. stats_logging_interval = 60 by default, 0 to disable, range 5-3600 -- Simon Riggs EnterpriseDB http://www.enterprisedb.com
