Re: [BUGS] BUG #14889: explain analyze is taking much more time thanactual execution

Поиск
Список
Период
Сортировка
От David Rowley
Тема Re: [BUGS] BUG #14889: explain analyze is taking much more time thanactual execution
Дата
Msg-id CAKJS1f8ZmMFfr6MWzKAPo0GGLgT5Sbfo+GDcjKQguzcyzdDbDw@mail.gmail.com
обсуждение исходный текст
Ответ на [BUGS] BUG #14889: explain analyze is taking much more time than actualexecution  (mahmoud.alorfaly@gmail.com)
Ответы Re: [BUGS] BUG #14889: explain analyze is taking much more time than actual execution  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
Дерево обсуждения 
On 6 November 2017 at 21:04, mahmoud alorfaly
<mahmoud.alorfaly@gmail.com> wrote:
> With EXPLAIN (ANALYZE, TIMING OFF), it is back to normal execution speed.

Then it's just the TIMING overhead that's causing the slowdown. This
will vary depending on how long gettimeofday() takes on your system.

This is known to be an overhead which is one of the reasons the TIMING
OFF option exists.


-- David Rowley                   http://www.2ndQuadrant.com/PostgreSQL Development, 24x7 Support, Training & Services


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

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

Предыдущее
От: mahmoud alorfaly
Дата:
Сообщение: Re: [BUGS] BUG #14889: explain analyze is taking much more time thanactual execution
Следующее
От: Alexander Korotkov
Дата:
Сообщение: Fwd: [BUGS] pg_trgm word_similarity inconsistencies or bug