Postgres Pro
Downloads
Home   >   mailing lists

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

From Jeff Janes
Subject Re: [BUGS] BUG #14889: explain analyze is taking much more time thanactual execution
Date
Msg-id CAMkU=1wOXy_twqTSgSNAEM0OMX4O-DY2ns9MvH8J=aPYcrsCPg@mail.gmail.com
Whole thread Raw
In response to 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 Mon, Nov 6, 2017 at 12:04 AM, mahmoud alorfaly <mahmoud.alorfaly@gmail.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

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: [BUGS] BUG #14889: explain analyze is taking much more time than actual execution
Next
From: Thomas Munro
Date:
Subject: Re: [BUGS] BUG #14889: explain analyze is taking much more time thanactual execution