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 7
id | location | product | quantity |
---|---|---|---|
1 | London | Macbook | 10 |
2 | London | iMac | 15 |
3 | San Francisco | Macbook | 50 |
4 | San Francisco | iMac | 70 |
5 | San Francisco | Mac Pro | 40 |
6 | Shanghai | iMac | 70 |
7 | Shanghai | Macbook | 150 |
SELECT 7
location | sum |
---|---|
null | 405 |
Shanghai | 220 |
San Francisco | 160 |
London | 25 |
SELECT 4
location | product | sum |
---|---|---|
London | iMac | 15 |
London | Macbook | 10 |
London | null | 25 |
San Francisco | iMac | 70 |
San Francisco | Macbook | 50 |
San Francisco | Mac Pro | 40 |
San Francisco | null | 160 |
Shanghai | iMac | 70 |
Shanghai | Macbook | 150 |
Shanghai | null | 220 |
null | null | 405 |
SELECT 11
location | product | sum |
---|---|---|
All locations | All products | 405 |
London | All products | 25 |
London | iMac | 15 |
London | Macbook | 10 |
San Francisco | All products | 160 |
San Francisco | iMac | 70 |
San Francisco | Macbook | 50 |
San Francisco | Mac Pro | 40 |
Shanghai | All products | 220 |
Shanghai | iMac | 70 |
Shanghai | Macbook | 150 |
SELECT 11
location | product | sum |
---|---|---|
All locations | All products | 405 |
All locations | iMac | 155 |
All locations | Macbook | 210 |
All locations | Mac Pro | 40 |
London | All products | 25 |
London | iMac | 15 |
London | Macbook | 10 |
San Francisco | All products | 160 |
San Francisco | iMac | 70 |
San Francisco | Macbook | 50 |
San Francisco | Mac Pro | 40 |
Shanghai | All products | 220 |
Shanghai | iMac | 70 |
Shanghai | Macbook | 150 |
SELECT 14