query performance, where goes time?

Поиск
Список
Период
Сортировка
От Anibal David Acosta
Тема query performance, where goes time?
Дата
Msg-id 00c801cd8bb0$2a0bbe10$7e233a30$@devshock.com
обсуждение исходный текст
Ответы Re: query performance, where goes time?  (Craig Ringer <ringerc@ringerc.id.au>)
Список pgsql-performance

Using explain analyze I saw that many of my queries run really fast, less than 1 milliseconds, for example the analyze output of a simple query over a table with 5millions of records return  "Total runtime: 0.078 ms"

 

But the real time is a lot  more, about 15 ms, in fact the pgadmin show this value.

 

So, where goes the others 14.2 ms?

 

Network transfer (TCP)?

 

Or analyze Total runtime don’t represent the query runtime?

 

Thanks!

В списке pgsql-performance по дате отправления:

Предыдущее
От: Jeff Janes
Дата:
Сообщение: Re: exponential performance decrease in ISD transaction
Следующее
От: Craig Ringer
Дата:
Сообщение: Re: query performance, where goes time?