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

Поиск
Список
Период
Сортировка
От Jeff Janes
Тема Re: [BUGS] BUG #14889: explain analyze is taking much more time thanactual execution
Дата
Msg-id CAMkU=1wOXy_twqTSgSNAEM0OMX4O-DY2ns9MvH8J=aPYcrsCPg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [BUGS] BUG #14889: explain analyze is taking much more time thanactual execution  (mahmoud alorfaly <mahmoud.alorfaly@gmail.com>)
Список pgsql-bugs
Дерево обсуждения
On Mon, Nov 6, 2017 at 12:04 AM, mahmoud alorfaly <mahmoud.alorfaly@gmail.com> wrote:
With EXPLAIN (ANALYZE, TIMING OFF), it is back to normal execution speed.


What do you get out of the command line tool "pg_test_timing"?
 
Is the server otherwise idle while you run your query, or is it busy with other stuff?
 
Cheers,

Jeff

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