add batch remove batch split batch comment selection show hidden batches hide batch highlight batch
db<>fiddle
donate feedback about
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