Ow Mun Heng wrote: > Hi, > > Is there a method to obtain the query's runtime from any of the pg_* > tables?
No. You can use log_durations and log_statement for that. We don't store that info in tables. > Right now, I'm only seeing the backend_start_time (from > pg_stat_activity) (and I'm also not sure how to interpret this. This is the time that the session was started. Nothing to do with the query itself. -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
