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 CAKJS1f8WLoQsBPd46EZcBWB2w3=BZc3PJgmNCHewndOrzkuyaA@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 thanactual execution  (mahmoud alorfaly <mahmoud.alorfaly@gmail.com>)
Список pgsql-bugs
Дерево обсуждения 
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


-- 
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@gmail.com
Дата:
Сообщение: [BUGS] BUG #14889: explain analyze is taking much more time than actualexecution
Следующее
От: mahmoud alorfaly
Дата:
Сообщение: Re: [BUGS] BUG #14889: explain analyze is taking much more time thanactual execution