Postgres Pro
Downloads
Home   >   mailing lists

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

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

Previous
From: mahmoud.alorfaly@gmail.com
Date:
Subject: [BUGS] BUG #14889: explain analyze is taking much more time than actualexecution
Next
From: mahmoud alorfaly
Date:
Subject: Re: [BUGS] BUG #14889: explain analyze is taking much more time thanactual execution