Postgres Pro
Downloads
Home   >   mailing lists

Re: Strange query duration - Mailing list pgsql-sql

From Tom Lane
Subject Re: Strange query duration
Date
Msg-id 4240.1216759573@sss.pgh.pa.us
Whole thread Raw
In response to Strange query duration  ("Fernando Hevia" <fhevia@ip-tel.com.ar>)
List pgsql-sql
Tree view 
"Fernando Hevia" <fhevia@ip-tel.com.ar> writes:
> The 'f_tasador' procedure is quite fast. As per log output I can see the
> procedure completes its execution within one second. Nevertheless in the LOG
> duration entry it shows a statement duration of over 36 secs.

It says milliseconds, not seconds.
        regards, tom lane

pgsql-sql by date:

Previous
From: "Fernando Hevia"
Date:
Subject: Re: Strange query duration
Next
From: Steve Midgley
Date:
Subject: Re: index for group by