With EXPLAIN (ANALYZE, TIMING OFF), it is back to normal execution speed.
Regards
Mahmoud
On Mon, Nov 6, 2017 at 10:59 AM, David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>
wrote:
> 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
>