Re: How to identify long-running queries, not just long-running backends?

From: Jeff Boes <jboes(at)nexcerpt(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: How to identify long-running queries, not just long-running backends?
Date: 2005-03-31 15:35:21
Message-ID: d2h5bk$2451$2@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Jeff Boes wrote:

> What I'm really hoping for is a way to get the "start time" for a query
> in pg_stat_activity.

... which I guess is pg_stat_activity.query_start. Duh. I will now hide
under my desk for a while.

(Don't know how I missed this; maybe I was looking at old documentation
for the pg_stat_activity view.)

--
Jeff Boes Vox 269-226-9550 x24
Director of Software Development Fax 269-349-9076

Exfacto! Exceptional Online Content http://www.exfacto.com
Nexcerpt ...Extend Your Expertise... http://www.nexcerpt.com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Patrick.FICHE 2005-03-31 15:40:30 Re: truncate/create slowness
Previous Message Jeff Boes 2005-03-31 15:33:07 How to identify long-running queries, not just long-running backends?