On Wednesday March 23 2005 5:14, Mark Kirkwood wrote:
> - decide on a snapshot interval (e.g. 30 seconds)
> - capture pg_stat_activity every interval and save the results
> in a timestamped copy of this view (e.g. add a column
> 'snap_time')
That might serve for some purposes, but log-parsing sounds far
simpler and closer to our objectives. For example, I want to be
able to identify a query that normally takes 10ms but is now
taking 200ms...
Thanks.
Ed