Re: BUG #14889: explain analyze is taking much more time than actual execution

From: David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>
To: mahmoud(dot)alorfaly(at)gmail(dot)com
Cc: PostgreSQL mailing lists <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #14889: explain analyze is taking much more time than actual execution
Date: 2017-11-06 07:59:08
Message-ID: CAKJS1f8WLoQsBPd46EZcBWB2w3=BZc3PJgmNCHewndOrzkuyaA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On 6 November 2017 at 19:50, <mahmoud(dot)alorfaly(at)gmail(dot)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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message mahmoud alorfaly 2017-11-06 08:04:10 Re: BUG #14889: explain analyze is taking much more time than actual execution
Previous Message mahmoud.alorfaly 2017-11-06 06:50:21 BUG #14889: explain analyze is taking much more time than actual execution