On Mon, Mar 12, 2012 at 17:23, Tom Lane wrote:
> EXPLAIN ANALYZE *necessarily* does less work than the real query,
> because it doesn't transmit the results to the client (which is going
> to be a dominant cost in a lot of situations). I'm not sure whether
> running the I/O functions would provid
Robert Haas writes:
> ... I think that if there's an actual bug here, it's that
> EXPLAIN ANALYZE is skipping the formation of the actual output tuples,
> and therefore it's doing less work than an actual execution of the
> real query would. I am not sure whether it would be a good idea to
> chan
On Sun, Mar 4, 2012 at 11:22 PM, wrote:
> I got hit by that bug when explored reasons of one very slow production
> query again.
> And I lost a lot time trying reproduce the problem query on production
> server with explain analyze.
> Finally I found I need some workaround to get explain perform
The following bug has been logged on the website:
Bug reference: 6513
Logged by: Maxim Boguk
Email address: maxim.bo...@gmail.com
PostgreSQL version: 9.0.7
Operating system: Linux
Description:
I got hit by that bug when explored reasons of one very slow production
que