On Tue, 2007-10-23 at 09:28 -0500, Erik Jones wrote:
> > Ow Mun Heng wrote:
> >> Hi,
> >>
> >> Is there a method to obtain the query's runtime from any of the pg_*
> >> tables?
> query_start does, however, give you the time that the query started.
> I use something like
>
> SELECT procpid, cli
On Oct 23, 2007, at 8:43 AM, Alvaro Herrera wrote:
Ow Mun Heng wrote:
Hi,
Is there a method to obtain the query's runtime from any of the pg_*
tables?
No. You can use log_durations and log_statement for that. We don't
store that info in tables.
Right now, I'm only seeing the backend_star
Ow Mun Heng wrote:
> Hi,
>
> Is there a method to obtain the query's runtime from any of the pg_*
> tables?
No. You can use log_durations and log_statement for that. We don't
store that info in tables.
> Right now, I'm only seeing the backend_start_time (from
> pg_stat_activity) (and I'm also
