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

From: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
To: mahmoud alorfaly <mahmoud(dot)alorfaly(at)gmail(dot)com>
Cc: David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>, 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 19:46:32
Message-ID: CAMkU=1wOXy_twqTSgSNAEM0OMX4O-DY2ns9MvH8J=aPYcrsCPg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Mon, Nov 6, 2017 at 12:04 AM, mahmoud alorfaly <
mahmoud(dot)alorfaly(at)gmail(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Thomas Munro 2017-11-06 21:20:39 Re: BUG #14889: explain analyze is taking much more time than actual execution
Previous Message Tom Lane 2017-11-06 14:43:38 Re: BUG #14889: explain analyze is taking much more time than actual execution