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

Поиск
Список
Период
Сортировка
От mahmoud alorfaly
Тема Re: [BUGS] BUG #14889: explain analyze is taking much more time thanactual execution
Дата
Msg-id CALK5a+citfeN5=sprXybs-kOPV5uV_tfDHK5ErficgbF3wCtCQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [BUGS] BUG #14889: explain analyze is taking much more time thanactual execution  (David Rowley <david.rowley@2ndquadrant.com>)
Ответы Re: [BUGS] BUG #14889: explain analyze is taking much more time thanactual execution  (Jeff Janes <jeff.janes@gmail.com>)
Список pgsql-bugs
Дерево обсуждения
With EXPLAIN (ANALYZE, TIMING OFF), it is back to normal execution speed.

Regards
Mahmoud

On Mon, Nov 6, 2017 at 10:59 AM, David Rowley <david.rowley@2ndquadrant.com> wrote:
On 6 November 2017 at 19:50,  <mahmoud.alorfaly@gmail.com> wrote:
> Running a simple count(*) is finishing in 250ms While Explain Analyze is
> reaching 4 seconds to complete !

How about with: EXPLAIN (ANALYZE, TIMING OFF) ?


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

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

Предыдущее
От: David Rowley
Дата:
Сообщение: 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