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 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq