On 22/11/11 10:26, Kevin Grittner wrote:
Rudyar wrote:
what tool you recommend for measure the query "real" query
execution time?
The -hackers list is for discussion to coordinate development of the
PostgreSQL database product. For user questions like this, please
pick a more appropriate li
Rudyar wrote:
> what tool you recommend for measure the query "real" query
> execution time?
The -hackers list is for discussion to coordinate development of the
PostgreSQL database product. For user questions like this, please
pick a more appropriate list based on the descriptions here:
ht
On 22/11/11 02:58, Kevin Grittner wrote:
Rudyar wrote:
I try to get the execution time of a query workload. I try using
explain analyze but this time is allways higher than the execution
time of a query across a client like pgadmin3
what is the reason about that difference?
It's the "observ
Rudyar wrote:
> I try to get the execution time of a query workload. I try using
> explain analyze but this time is allways higher than the execution
> time of a query across a client like pgadmin3
>
> what is the reason about that difference?
It's the "observer effect" -- there is a cost to
On 11/21/11, Rudyar wrote:
> Hello,
>
> I try to get the execution time of a query workload. I try using explain
> analyze but this time is allways higher than
> the execution time of a query across a client like pgadmin3
>
> what is the reason about that difference?
Analyze has to do a lot of ge
Hello,
I try to get the execution time of a query workload. I try using explain
analyze but this time is allways higher than
the execution time of a query across a client like pgadmin3
what is the reason about that difference?
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.
