Re: BUG #14107: Major query planner bug regarding subqueries and indices

From: Victor Yegorov <vyegorov(at)gmail(dot)com>
To: Francisco Olarte <folarte(at)peoplecall(dot)com>
Cc: Mathias Kunter <mathiaskunter(at)gmail(dot)com>, "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #14107: Major query planner bug regarding subqueries and indices
Date: 2016-04-22 16:57:02
Message-ID: CAGnEbogfdNPxN7vvY_8b4bPj4VVDzEw5NaXVBRSWUMQgKZE-CA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

2016-04-22 19:24 GMT+03:00 Francisco Olarte <folarte(at)peoplecall(dot)com>:

> IIRC plain-EXPLAIN returns estimates, you need explain analyze to be
> comparable.

Of course, sorry for this.

Well, then `EXPLAIN (analyze, buffers)` is also wanted, together with
object definitions.

--
Victor Y. Yegorov

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Andres Freund 2016-04-22 17:07:36 Re: [BUGS] Breakage with VACUUM ANALYSE + partitions
Previous Message Francisco Olarte 2016-04-22 16:24:47 Re: BUG #14107: Major query planner bug regarding subqueries and indices