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?.
5 rows affected
| start | stop |
|---|---|
| 4018010000 | 4018019999 |
| 4018200000 | 4018299999 |
| 42320000 | 42329999 |
| 423200000 | 423299999 |
| 4232000000 | 4232999999 |
| 42400000 | 42499999 |
| 43691000000 | 43691999999 |