distinguish index cost component from table component
Justin Pryzby <[email protected]> Fri, 3 Jan 2020 08:14:27 -0600
| Newsgroups | gmane.comp.db.postgresql.performance |
|---|---|
| Message-ID | <[email protected]> |
Is it possible to tell what component of the cost estimate of an index scan is from the index reads vs heap ? It would help to be able to set enable_bitmapscan=FORCE (to make all index scans go through a bitmap). Adding OR conditions can sometimes do this. That includes cost of bitmap manipulation, but it's good enough for me. Or maybe explain should report it.