Postgres Pro
Downloads
Home   >   mailing lists

Re: [BUGS] BUG #14889: explain analyze is taking much more time thanactual execution - Mailing list pgsql-bugs

From mahmoud alorfaly
Subject Re: [BUGS] BUG #14889: explain analyze is taking much more time thanactual execution
Date
Msg-id CALK5a+citfeN5=sprXybs-kOPV5uV_tfDHK5ErficgbF3wCtCQ@mail.gmail.com
Whole thread Raw
In response to Re: [BUGS] BUG #14889: explain analyze is taking much more time thanactual execution  (David Rowley <david.rowley@2ndquadrant.com>)
Responses Re: [BUGS] BUG #14889: explain analyze is taking much more time thanactual execution
List pgsql-bugs
Tree view
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 by date:

Previous
From: David Rowley
Date:
Subject: Re: [BUGS] BUG #14889: explain analyze is taking much more time thanactual execution
Next
From: David Rowley
Date:
Subject: Re: [BUGS] BUG #14889: explain analyze is taking much more time thanactual execution