Request a Demo
Home   >   mailing lists

[BUGS] BUG #14889: explain analyze is taking much more time than actualexecution - Mailing list pgsql-bugs

From [email protected]
Subject [BUGS] BUG #14889: explain analyze is taking much more time than actualexecution
Date
Msg-id [email protected]
Whole thread Raw
Responses Re: [BUGS] BUG #14889: explain analyze is taking much more time thanactual execution
List pgsql-bugs
Tree view 
The following bug has been logged on the website:

Bug reference:      14889
Logged by:          mahmoud alorfaly
Email address:      [email protected]
PostgreSQL version: 10.0
Operating system:   RHel 7
Description:

I am testing a simple query performance for an items table of one column and
has 4M entries.

Running a simple count(*) is finishing in 250ms While Explain Analyze is
reaching 4 seconds to complete !




--
Sent via pgsql-bugs mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

pgsql-bugs by date:

Previous
From: Daniel Migowski
Date:
Subject: Re: [BUGS] BUG #14888: Need to recheck contraints
Next
From: David Rowley
Date:
Subject: Re: [BUGS] BUG #14889: explain analyze is taking much more time thanactual execution