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 name genres
1 Kraftwerk ["electronic"]
2 Daft Punk ["electronic", "house"]
3 Maroon 5 ["pop", "rock"]
4 One Republic ["pop", "rock"]
5 Lil Nas X ["hip-hop", "country rap", "rap"]
6 Post Malone ["hip-hop", "rap", "trap"]
7 Drake ["hip-hop", "rap"]
SELECT 7
genre
"electronic"
"electronic"
"house"
"pop"
"rock"
"pop"
"rock"
"hip-hop"
"country rap"
"rap"
"hip-hop"
"rap"
"trap"
"hip-hop"
"rap"
SELECT 15
genre popularity
"rap" 3
"hip-hop" 3
"pop" 2
"rock" 2
"electronic" 2
"house" 1
"country rap" 1
"trap" 1
SELECT 8