Re: Time of query result delivery

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