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?.
CREATE TABLE
INSERT 0 19
CREATE EXTENSION
key | jan | feb | mar | apr | may | jun | jul | aug | sep | oct | nov | dec |
---|---|---|---|---|---|---|---|---|---|---|---|---|
BOL-Course | 12.00 | null | 12.00 | null | null | null | null | null | null | null | null | null |
COL-Course | null | null | null | 24.00 | null | null | null | null | null | null | null | null |
COL-Subscription | 30.00 | null | null | null | null | 30.00 | null | null | null | null | null | 30.00 |
MXN-Course | null | null | null | null | 16.00 | null | null | null | null | null | null | null |
PEN-Course | 16.00 | 12.00 | 24.00 | null | null | null | 16.00 | null | 16.00 | null | null | 12.00 |
PEN-Subscription | null | null | null | 30.00 | 30.00 | 30.00 | null | 30.00 | null | 30.00 | 30.00 | null |
SELECT 6
country | type | jan | feb | mar | apr | may | jun | jul | aug | sep | oct | nov | dec |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
BOL | Course | 12.00 | null | 12.00 | null | null | null | null | null | null | null | null | null |
COL | Course | null | null | null | 24.00 | null | null | null | null | null | null | null | null |
COL | Subscription | 30.00 | null | null | null | null | 30.00 | null | null | null | null | null | 30.00 |
MXN | Course | null | null | null | null | 16.00 | null | null | null | null | null | null | null |
PEN | Course | 16.00 | 12.00 | 24.00 | null | null | null | 16.00 | null | 16.00 | null | null | 12.00 |
PEN | Subscription | null | null | null | 30.00 | 30.00 | 30.00 | null | 30.00 | null | 30.00 | 30.00 | null |
SELECT 6