Hi hackers, We already have xact_start, query_start and backend_start to get the timestamptz for when different things happened.
I would like to propose adding a fourth such column, "waiting_start", which would tell how long time a backend has been waiting. The column would be NULL when waiting=FALSE. While it's trivial to write a script that just polls pg_stat_activity every second and keeps tack of when a backend started waiting by just checking for any new waiting=TRUE rows, it would be more convenient to just get the information from pg_stat_activity directly. The use-case would be e.g. monitoring tools when you want to know how long time queries are waiting. -- Joel Jacobson -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
