Re: [SQL] Monitoring a Query

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: Aaron Held <aaron(at)MetroNY(dot)com>, Roberto Mello <rmello(at)cc(dot)usu(dot)edu>, Neil Conway <neilc(at)samurai(dot)com>, pgsql-sql(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org
Subject: Re: [SQL] Monitoring a Query
Date: 2002-09-23 15:03:06
Message-ID: 21724.1032793386@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers pgsql-sql

Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2002-09-23 15:06:19 Re: [SQL] Monitoring a Query
Previous Message Bruce Momjian 2002-09-23 14:58:45 Re: output format for dates

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2002-09-23 15:06:19 Re: [SQL] Monitoring a Query
Previous Message Bruce Momjian 2002-09-23 14:49:53 Re: [SQL] Monitoring a Query

Browse pgsql-sql by date

  From Date Subject
Next Message Bruce Momjian 2002-09-23 15:06:19 Re: [SQL] Monitoring a Query
Previous Message Bruce Momjian 2002-09-23 14:49:53 Re: [SQL] Monitoring a Query