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?.
| rn | dt |
|---|---|
| 1 | 2023-07-08 |
| 1 | 2023-07-07 |
| 1 | 2023-07-06 |
| 1 | 2023-07-05 |
| 1 | 2023-07-04 |
| 1 | 2023-07-03 |
| 1 | 2023-07-02 |
| 2 | 2023-07-01 |
| 2 | 2023-06-30 |
| 2 | 2023-06-29 |
| 2 | 2023-06-28 |
| 2 | 2023-06-27 |
| 2 | 2023-06-26 |
| 2 | 2023-06-25 |
| 3 | 2023-06-24 |
| 3 | 2023-06-23 |
| 3 | 2023-06-22 |
| 3 | 2023-06-21 |
| 3 | 2023-06-20 |
| 3 | 2023-06-19 |
| 3 | 2023-06-18 |
| 4 | 2023-06-17 |
| 4 | 2023-06-16 |
| 4 | 2023-06-15 |
| 4 | 2023-06-14 |
| 4 | 2023-06-13 |
| 4 | 2023-06-12 |
| 4 | 2023-06-11 |
| 5 | 2023-06-10 |
| 5 | 2023-06-09 |
| 5 | 2023-06-08 |
| 5 | 2023-06-07 |
| 5 | 2023-06-06 |
| 5 | 2023-06-05 |
| 5 | 2023-06-04 |
SELECT 35