Postgres Pro
Downloads
Home   >   mailing lists

Determine query run-time from pg_* tables - Mailing list pgsql-general

From Ow Mun Heng
Subject Determine query run-time from pg_* tables
Date
Msg-id 1193119334.29348.19.camel@neuromancer.home.net
Whole thread Raw
Responses Re: Determine query run-time from pg_* tables  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-general
Tree view 
Hi,

Is there a method to obtain the query's runtime from any of the pg_*
tables?

Right now, I'm only seeing the backend_start_time (from
pg_stat_activity) (and I'm also not sure how to interpret this.

pgsql-general by date:

Previous
From: Benjamin Weaver
Date:
Subject: Re: unicode searches failing that use % and LIKE operators
Next
From: Alvaro Herrera
Date:
Subject: Re: Bitmap Heap scan 8.1/8.2