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?.
| start_date | gs |
|---|---|
| 2008-03-01 00:00:00 | 1 |
| 2008-03-01 00:00:00 | 2 |
| 2008-03-01 00:00:00 | 3 |
| 2008-03-01 00:00:00 | 4 |
| 2008-03-01 00:00:00 | 5 |
| 2008-03-01 00:00:00 | 6 |
| 2008-03-01 00:00:00 | 7 |
| 2008-03-01 00:00:00 | 8 |
| 2008-03-01 00:00:00 | 9 |
| 2008-03-01 00:00:00 | 10 |
| ?column? |
|---|
| 2008-03-01 10:00:00 |
| 2008-03-01 20:00:00 |
| 2008-03-02 06:00:00 |
| 2008-03-02 16:00:00 |
| 2008-03-03 02:00:00 |
| 2008-03-03 12:00:00 |
| 2008-03-03 22:00:00 |
| 2008-03-04 08:00:00 |
| 2008-03-04 18:00:00 |
| 2008-03-05 04:00:00 |