Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id C98D8475FD9
	for <pgsql-general@postgresql.org>;
	Mon, 23 Sep 2002 11:05:09 -0400 (EDT)
Received: from sss.pgh.pa.us (unknown [192.204.191.242])
	by postgresql.org (Postfix) with ESMTP id BBEC3475D20
	for <pgsql-general@postgresql.org>;
	Mon, 23 Sep 2002 11:05:08 -0400 (EDT)
Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1])
	by sss.pgh.pa.us (8.12.5/8.12.5) with ESMTP id g8NF365D021725;
	Mon, 23 Sep 2002 11:03:06 -0400 (EDT)
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
Subject: Re: [SQL] Monitoring a Query 
In-reply-to: <200209231449.g8NEnrl11375@candle.pha.pa.us> 
References: <200209231449.g8NEnrl11375@candle.pha.pa.us>
Comments: In-reply-to Bruce Momjian <pgman@candle.pha.pa.us>
	message dated "Mon, 23 Sep 2002 10:49:53 -0400"
Date: Mon, 23 Sep 2002 11:03:06 -0400
Message-ID: <21724.1032793386@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200209/1000
X-Sequence-Number: 30581

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