Re: Time of query result delivery - Mailing list pgsql-performance

From Josh Berkus
Subject Re: Time of query result delivery
Date
Msg-id 52DEC2B5.9090700@agliodbs.com
Whole thread Raw
In response to Time of query result delivery  (ARCEnergo <it@kipspb.ru>)
List pgsql-performance
On 01/20/2014 05:55 AM, ARCEnergo wrote:
> Time: 1.211 ms
>                            | Physical  | Virtaul
> --------------------------------------------------
> from PC "Total runtime"    | 0.05x ms  | 0.05x ms
> --------------------------------------------------
> from PC timing             | 0.7 ms    | 1.211 ms  <-- strange
> --------------------------------------------------
> from server "Total runtime"| 0.05x ms  | 0.05x ms
> --------------------------------------------------
> from server timing         | 0.55 ms   | 0.6 ms

I'm really not clear on what you're trying to measure here.  If you're
doing "time" from your PC, then network transmission time completely
dominates your reponse time ... and that can be affected by all kinds of
random variables.

--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com


pgsql-performance by date:

Previous
From: Mark Kirkwood
Date:
Subject: Re: Increasing query time after updates
Next
From: Josh Berkus
Date:
Subject: Re: Time of query result delivery