On 6 November 2017 at 21:04, mahmoud alorfaly
<mahmoud(dot)alorfaly(at)gmail(dot)com> wrote:
> With EXPLAIN (ANALYZE, TIMING OFF), it is back to normal execution speed.
Then it's just the TIMING overhead that's causing the slowdown. This
will vary depending on how long gettimeofday() takes on your system.
This is known to be an overhead which is one of the reasons the TIMING
OFF option exists.
--
David Rowley http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services