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?.
version |
---|
PostgreSQL 14.1 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.5.0 20210514 (Red Hat 8.5.0-4), 64-bit |
15 rows affected
dte | sales |
---|---|
2022-05-01 | 4 |
2022-05-02 | 8 |
2022-05-02 | 2 |
2022-05-04 | 4 |
2022-05-05 | 4 |
2022-05-05 | 9 |
2022-05-06 | 7 |
2022-05-07 | 10 |
2022-05-08 | 1 |
2022-05-09 | 3 |
2022-05-10 | 2 |
2022-05-11 | 8 |
2022-05-12 | 1 |
2022-05-13 | 6 |
2022-06-14 | 3 |
Week Ending | Total Sales |
---|---|
2022-05-01 | 4 |
2022-05-08 | 45 |
2022-05-15 | 20 |
2022-06-19 | 3 |
?column? |
---|
38 |
Week Ending | Total Sales |
---|---|
2022-05-06 | 38 |
2022-05-13 | 31 |
2022-06-17 | 3 |