Postgres Pro
Downloads
Home   >   mailing lists

Re: How to identify long-running queries, not just long-running backends? - Mailing list pgsql-general

From Jeff Boes
Subject Re: How to identify long-running queries, not just long-running backends?
Date
Msg-id d2h5bk$2451$2@news.hub.org
Whole thread Raw
In response to How to identify long-running queries, not just long-running backends?  (Jeff Boes <jboes@nexcerpt.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Jeff Boes
Date:
Subject: How to identify long-running queries, not just long-running backends?
Next
From: Patrick.FICHE@AQSACOM.COM
Date:
Subject: Re: truncate/create slowness