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?.
19 rows affected
created_at | num_orders |
---|---|
2017-05-04 | 3 |
2017-05-05 | 3 |
2017-05-06 | 3 |
2017-05-07 | 3 |
2017-05-08 | 3 |
2017-05-09 | 3 |
AvgOrderVelocity | AvgLast7Days | Last24h |
---|---|---|
3.00 | 2.57 | 1 |