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?.
4 rows affected
tuple |
---|
BIRD |
CAT |
DOG |
TREE |
BIRD,CAT |
BIRD,DOG |
BIRD,TREE |
CAT,DOG |
CAT,TREE |
DOG,TREE |
BIRD,CAT,DOG |
BIRD,CAT,TREE |
BIRD,DOG,TREE |
CAT,DOG,TREE |
BIRD,CAT,DOG,TREE |