Re: rows estimate in explain analyze for the BRIN index
От | Emre Hasegeli |
---|---|
Тема | Re: rows estimate in explain analyze for the BRIN index |
Дата | |
Msg-id | CAE2gYzyQTZihX9GbZTesWiJT55xPLrbtBwiRey3qhqMBOiSLmQ@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: rows estimate in explain analyze for the BRIN index (Oleksii Kliukin <alexk@hintbits.com>) |
Ответы |
Re: rows estimate in explain analyze for the BRIN index
|
Список | pgsql-hackers |
> I don’t see how to solve this problem without changing explain analyze output to accommodate for “unknown” value. I don’tthink “0” is a non-confusing representation of “unknown” for most people, and from the practical standpoint, a “besteffort” estimate is better than 0 (i.e. I will be able to estimate how efficient BRIN index is for my tables in termsof the number of tuples retrieved/thrown away) The number of retrieved and thrown away rows are already available on the upper part of the plan. Bitmap Index Scan should provide the rows that matched the index. Another alternative would be just returning the number of matching pages (by not multiplying with 10). It might be better understood. The users who can understand the EXPLAIN ANALYZE output shouldn't be expecting BRIN to return rows.
В списке pgsql-hackers по дате отправления: