By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Help with an interesting Postgres question: Why isn't an Index Only Scan used on a partition accessed via the parent table?.
| tfrom | tto |
|---|---|
| -99 | -47 |
| i |
|---|
| -99 |
| -98 |
| -97 |
| -96 |
| -95 |
| -94 |
| -93 |
| -92 |
| -91 |
| -90 |
| -89 |
| -88 |
| -87 |
| -86 |
| -85 |
| -84 |
| -83 |
| -82 |
| -81 |
| -80 |
| -79 |
| -78 |
| -77 |
| -76 |
| -75 |
| -74 |
| -73 |
| -72 |
| -71 |
| -70 |
| -69 |
| -68 |
| -67 |
| -66 |
| -65 |
| -64 |
| -63 |
| -62 |
| -61 |
| -60 |
| -59 |
| -58 |
| -57 |
| -56 |
| -55 |
| -54 |
| -53 |
| -52 |
| -51 |
| -50 |
| -49 |
| -48 |
| -47 |
| -46 |