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?.
15 rows affected
| customer | orderid | event_date | sales_volume |
|---|---|---|---|
| Customer_A | Order_001 | 2020-01-08 | 130 |
| Customer_A | Order_002 | 2020-01-12 | 120 |
| Customer_A | Order_003 | 2020-01-22 | 115 |
| Customer_A | Order_004 | 2020-06-25 | 445 |
| Customer_B | Order_001 | 2020-04-08 | 325 |
| Customer_B | Order_002 | 2020-04-12 | 875 |
| Customer_B | Order_003 | 2020-04-15 | 910 |
| Customer_B | Order_004 | 2020-04-20 | 723 |
| Customer_B | Order_005 | 2020-06-01 | 982 |
| Customer_B | Order_006 | 2020-06-15 | 100 |
| Customer_C | Order_001 | 2020-01-22 | 300 |
| Customer_C | Order_002 | 2020-01-23 | 500 |
| Customer_C | Order_003 | 2020-04-30 | 665 |
| Customer_C | Order_004 | 2020-06-19 | 250 |
| Customer_C | Order_005 | 2020-06-20 | 322 |