Horton

Re: [SQL] Monitoring a Query

Tom Lane <tgl@sss.pgh.pa.us>

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Bruce Momjian <pgman@candle.pha.pa.us>
Cc: Aaron Held <aaron@MetroNY.com>, Roberto Mello <rmello@cc.usu.edu>, Neil Conway <neilc@samurai.com>, pgsql-sql@postgresql.org, pgsql-general@postgresql.org
Date: 2002-09-23T15:03:06Z
Lists: pgsql-hackers, pgsql-general, pgsql-sql 
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> OK, added to TODO:
> 	* Add start time to pg_stat_activity

It would be nearly free to include the start time of the current
transaction, because we already save that for use by now().  Is
that good enough, or do we need start time of the current query?

			regards, tom lane