[BUGS] BUG #14889: explain analyze is taking much more time than actualexecution

Поиск
Список
Период
Сортировка
От mahmoud.alorfaly@gmail.com
Тема [BUGS] BUG #14889: explain analyze is taking much more time than actualexecution
Дата
Msg-id 20171106065021.1492.80384@wrigleys.postgresql.org
обсуждение исходный текст
Ответы Re: [BUGS] BUG #14889: explain analyze is taking much more time thanactual execution  (David Rowley <david.rowley@2ndquadrant.com>)
Список pgsql-bugs
Дерево обсуждения 
The following bug has been logged on the website:

Bug reference:      14889
Logged by:          mahmoud alorfaly
Email address:      mahmoud.alorfaly@gmail.com
PostgreSQL version: 10.0
Operating system:   RHel 7
Description:

I am testing a simple query performance for an items table of one column and
has 4M entries.

Running a simple count(*) is finishing in 250ms While Explain Analyze is
reaching 4 seconds to complete !




--
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 по дате отправления:

Предыдущее
От: Daniel Migowski
Дата:
Сообщение: Re: [BUGS] BUG #14888: Need to recheck contraints
Следующее
От: David Rowley
Дата:
Сообщение: Re: [BUGS] BUG #14889: explain analyze is taking much more time thanactual execution