Postgres Pro
Downloads
Home   >   mailing lists

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

From mahmoud.alorfaly@gmail.com
Subject [BUGS] BUG #14889: explain analyze is taking much more time than actualexecution
Date
Msg-id 20171106065021.1492.80384@wrigleys.postgresql.org
Whole thread Raw
Responses Re: [BUGS] BUG #14889: explain analyze is taking much more time thanactual execution  (David Rowley <david.rowley@2ndquadrant.com>)
List pgsql-bugs
Tree view 
The following bug has been logged on the website:

Bug reference:      14889
Logged by:          mahmoud alorfaly
Email address:      mahmoud.alorfaly@gmail.com
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 (pgsql-bugs@postgresql.org)
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