Re: Time of query result delivery

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


-- 
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance




[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux