Re: Time of query result delivery

Поиск
Список
Период
Сортировка
От Josh Berkus
Тема Re: Time of query result delivery
Дата
Msg-id 52DEC2B5.9090700@agliodbs.com
обсуждение исходный текст
Ответ на Time of query result delivery  (ARCEnergo <it@kipspb.ru>)
Список 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 по дате отправления:

Предыдущее
От: Mark Kirkwood
Дата:
Сообщение: Re: Increasing query time after updates
Следующее
От: Josh Berkus
Дата:
Сообщение: Re: Time of query result delivery