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?.
288 rows affected
animal | start | mid | end |
---|---|---|---|
dog | 40 | 24 | 39 |
cat | 23 | 24 | 25 |
bird | 38 | 44 | 31 |
animal | num | section |
---|---|---|
bird | 0 | end |
bird | 1 | mid |
bird | 0 | start |
bird | 1 | end |
bird | 0 | mid |
bird | 0 | start |
bird | 0 | end |
bird | 3 | mid |
bird | 0 | start |
bird | 2 | end |
bird | 0 | mid |
bird | 0 | start |
bird | 0 | end |
bird | 1 | mid |
bird | 0 | start |
bird | 1 | start |
bird | 0 | mid |
bird | 0 | end |
bird | 0 | start |
bird | 3 | mid |
bird | 0 | end |
bird | 2 | end |
bird | 1 | mid |
bird | 0 | start |
bird | 0 | start |
bird | 0 | mid |
bird | 1 | end |
bird | 0 | end |
bird | 0 | mid |
bird | 1 | start |
bird | 4 | start |
bird | 1 | mid |
bird | 0 | end |
bird | 0 | end |
bird | 2 | mid |
bird | 0 | start |
bird | 1 | end |
bird | 2 | mid |
bird | 0 | start |
bird | 0 | end |
bird | 0 | mid |
bird | 2 | start |
bird | 1 | start |
bird | 0 | mid |
bird | 0 | end |
bird | 1 | end |
bird | 0 | mid |
bird | 0 | start |
bird | 0 | end |
bird | 1 | mid |
bird | 2 | start |
bird | 1 | start |
bird | 0 | mid |
bird | 0 | end |
bird | 0 | start |
bird | 0 | mid |
bird | 1 | end |
bird | 1 | end |
bird | 0 | mid |
bird | 0 | start |
bird | 0 | start |
bird | 0 | mid |
bird | 4 | end |
bird | 0 | end |
bird | 1 | mid |
bird | 0 | start |
bird | 0 | end |
bird | 2 | mid |
bird | 0 | start |
bird | 0 | end |
bird | 2 | mid |
bird | 0 | start |
bird | 0 | start |
bird | 3 | mid |
bird | 0 | end |
bird | 0 | end |
bird | 1 | mid |
bird | 2 | start |
bird | 1 | end |
bird | 1 | mid |
bird | 1 | start |
bird | 0 | end |
bird | 0 | mid |
bird | 1 | start |
bird | 0 | end |
bird | 2 | mid |
bird | 0 | start |
bird | 2 | start |
bird | 0 | mid |
bird | 0 | end |
bird | 0 | start |
bird | 0 | mid |
bird | 1 | end |
bird | 0 | end |
bird | 0 | mid |
bird | 1 | start |
bird | 0 | end |
bird | 2 | mid |
bird | 2 | start |
bird | 0 | end |
bird | 1 | mid |
bird | 0 | start |
bird | 1 | end |
bird | 0 | mid |
bird | 0 | start |
bird | 1 | end |
bird | 0 | mid |
bird | 0 | start |
bird | 2 | end |
bird | 0 | mid |
bird | 0 | start |
bird | 0 | start |
bird | 1 | mid |
bird | 0 | end |
bird | 6 | start |
bird | 0 | mid |
bird | 0 | end |
bird | 0 | start |
bird | 0 | mid |
bird | 1 | end |
bird | 1 | start |
bird | 0 | mid |
bird | 0 | end |
bird | 0 | end |
bird | 0 | mid |
bird | 1 | start |
bird | 1 | start |
bird | 0 | mid |
bird | 0 | end |
bird | 0 | start |
bird | 1 | mid |
bird | 1 | end |
bird | 2 | end |
bird | 0 | mid |
bird | 0 | start |
bird | 1 | end |
bird | 1 | mid |
bird | 0 | start |
bird | 1 | start |
bird | 0 | mid |
bird | 1 | end |
bird | 0 | start |
bird | 1 | mid |
bird | 0 | end |
bird | 0 | end |
bird | 1 | mid |
bird | 0 | start |
bird | 0 | end |
bird | 0 | mid |
bird | 1 | start |
bird | 0 | end |
bird | 3 | mid |
bird | 0 | start |
bird | 0 | end |
bird | 3 | mid |
bird | 0 | start |
bird | 1 | end |
bird | 0 | mid |
bird | 0 | start |
bird | 0 | start |
bird | 1 | mid |
bird | 0 | end |
bird | 2 | end |
bird | 1 | mid |
bird | 0 | start |
bird | 6 | start |
bird | 0 | mid |
bird | 2 | end |
bird | 0 | start |
bird | 1 | mid |
bird | 0 | end |
cat | 0 | start |
cat | 1 | mid |
cat | 0 | end |
cat | 0 | start |
cat | 1 | mid |
cat | 0 | end |
cat | 1 | start |
cat | 0 | mid |
cat | 0 | end |
cat | 0 | start |
cat | 1 | mid |
cat | 0 | end |
cat | 0 | start |
cat | 0 | mid |
cat | 1 | end |
cat | 1 | start |
cat | 0 | mid |
cat | 0 | end |
cat | 0 | start |
cat | 2 | mid |
cat | 4 | end |
cat | 0 | start |
cat | 1 | mid |
cat | 0 | end |
cat | 0 | start |
cat | 0 | mid |
cat | 1 | end |
cat | 0 | start |
cat | 1 | mid |
cat | 0 | end |
cat | 1 | start |
cat | 0 | mid |
cat | 0 | end |
cat | 0 | start |
cat | 1 | mid |
cat | 0 | end |
cat | 0 | start |
cat | 1 | mid |
cat | 0 | end |
cat | 0 | start |
cat | 0 | mid |
cat | 1 | end |
cat | 0 | start |
cat | 1 | mid |
cat | 0 | end |
cat | 2 | start |
cat | 0 | mid |
cat | 0 | end |
cat | 1 | start |
cat | 0 | mid |
cat | 0 | end |
cat | 0 | start |
cat | 0 | mid |
cat | 1 | end |
cat | 1 | start |
cat | 0 | mid |
cat | 0 | end |
cat | 1 | start |
cat | 0 | mid |
cat | 0 | end |
cat | 2 | start |
cat | 0 | mid |
cat | 0 | end |
cat | 0 | start |
cat | 0 | mid |
cat | 1 | end |
cat | 0 | start |
cat | 1 | mid |
cat | 0 | end |
cat | 0 | start |
cat | 0 | mid |
cat | 2 | end |
cat | 0 | start |
cat | 0 | mid |
cat | 3 | end |
cat | 1 | start |
cat | 0 | mid |
cat | 0 | end |
cat | 4 | start |
cat | 0 | mid |
cat | 0 | end |
cat | 0 | start |
cat | 0 | mid |
cat | 2 | end |
cat | 0 | start |
cat | 2 | mid |
cat | 0 | end |
cat | 1 | start |
cat | 0 | mid |
cat | 0 | end |
cat | 2 | start |
cat | 0 | mid |
cat | 0 | end |
cat | 0 | start |
cat | 2 | mid |
cat | 0 | end |
cat | 0 | start |
cat | 1 | mid |
cat | 0 | end |
cat | 0 | start |
cat | 0 | mid |
cat | 1 | end |
cat | 0 | start |
cat | 0 | mid |
cat | 1 | end |
cat | 0 | start |
cat | 0 | mid |
cat | 1 | end |
cat | 0 | start |
cat | 1 | mid |
cat | 0 | end |
cat | 1 | start |
cat | 0 | mid |
cat | 0 | end |
cat | 1 | start |
cat | 0 | mid |
cat | 0 | end |
cat | 0 | start |
cat | 0 | mid |
cat | 1 | end |
cat | 0 | start |
cat | 0 | mid |
cat | 1 | end |
cat | 0 | start |
cat | 0 | mid |
cat | 1 | end |
cat | 0 | start |
cat | 2 | mid |
cat | 0 | end |
cat | 0 | start |
cat | 2 | mid |
cat | 0 | end |
cat | 1 | start |
cat | 0 | mid |
cat | 0 | end |
cat | 0 | start |
cat | 1 | mid |
cat | 0 | end |
cat | 1 | start |
cat | 0 | mid |
cat | 0 | end |
cat | 1 | start |
cat | 0 | mid |
cat | 0 | end |
cat | 0 | start |
cat | 2 | mid |
cat | 3 | end |
dog | 0 | start |
dog | 3 | mid |
dog | 0 | end |
dog | 0 | end |
dog | 1 | mid |
dog | 0 | start |
dog | 1 | start |
dog | 0 | mid |
dog | 0 | end |
dog | 0 | start |
dog | 0 | mid |
dog | 1 | end |
dog | 1 | start |
dog | 0 | mid |
dog | 0 | end |
dog | 0 | end |
dog | 0 | mid |
dog | 2 | start |
dog | 0 | start |
dog | 1 | mid |
dog | 0 | end |
dog | 1 | end |
dog | 0 | mid |
dog | 0 | start |
dog | 1 | end |
dog | 0 | mid |
dog | 0 | start |
dog | 0 | start |
dog | 2 | mid |
dog | 0 | end |
dog | 0 | end |
dog | 0 | mid |
dog | 1 | start |
dog | 0 | end |
dog | 0 | mid |
dog | 1 | start |
dog | 1 | start |
dog | 0 | mid |
dog | 0 | end |
dog | 0 | start |
dog | 0 | mid |
dog | 4 | end |
dog | 1 | start |
dog | 0 | mid |
dog | 0 | end |
dog | 0 | start |
dog | 2 | mid |
dog | 1 | end |
dog | 0 | end |
dog | 0 | mid |
dog | 1 | start |
dog | 0 | start |
dog | 0 | mid |
dog | 1 | end |
dog | 0 | end |
dog | 1 | mid |
dog | 1 | start |
dog | 0 | start |
dog | 0 | mid |
dog | 1 | end |
dog | 1 | start |
dog | 0 | mid |
dog | 0 | end |
dog | 1 | start |
dog | 0 | mid |
dog | 0 | end |
dog | 0 | start |
dog | 0 | mid |
dog | 1 | end |
dog | 0 | end |
dog | 0 | mid |
dog | 1 | start |
dog | 1 | end |
dog | 0 | mid |
dog | 0 | start |
dog | 1 | end |
dog | 0 | mid |
dog | 0 | start |
dog | 0 | end |
dog | 1 | mid |
dog | 0 | start |
dog | 0 | end |
dog | 0 | mid |
dog | 1 | start |
dog | 0 | end |
dog | 2 | mid |
dog | 0 | start |
dog | 1 | start |
dog | 0 | mid |
dog | 0 | end |
dog | 0 | end |
dog | 1 | mid |
dog | 0 | start |
dog | 1 | start |
dog | 0 | mid |
dog | 0 | end |
dog | 0 | start |
dog | 0 | mid |
dog | 1 | end |
dog | 0 | start |
dog | 1 | mid |
dog | 0 | end |
dog | 0 | start |
dog | 1 | mid |
dog | 0 | end |
dog | 0 | end |
dog | 0 | mid |
dog | 1 | start |
dog | 1 | start |
dog | 0 | mid |
dog | 0 | end |
dog | 0 | end |
dog | 0 | mid |
dog | 4 | start |
dog | 0 | start |
dog | 1 | mid |
dog | 0 | end |
dog | 2 | end |
dog | 0 | mid |
dog | 0 | start |
dog | 0 | end |
dog | 1 | mid |
dog | 2 | start |
dog | 0 | end |
dog | 0 | mid |
dog | 1 | start |
dog | 1 | end |
dog | 0 | mid |
dog | 0 | start |
dog | 1 | start |
dog | 0 | mid |
dog | 0 | end |
dog | 0 | start |
dog | 0 | mid |
dog | 1 | end |
dog | 1 | end |
dog | 0 | mid |
dog | 0 | start |
dog | 1 | end |
dog | 0 | mid |
dog | 0 | start |
dog | 2 | start |
dog | 0 | mid |
dog | 0 | end |
dog | 0 | start |
dog | 0 | mid |
dog | 1 | end |
dog | 1 | start |
dog | 0 | mid |
dog | 1 | end |
dog | 0 | start |
dog | 0 | mid |
dog | 3 | end |
dog | 1 | end |
dog | 0 | mid |
dog | 0 | start |
dog | 0 | end |
dog | 0 | mid |
dog | 1 | start |
dog | 1 | end |
dog | 0 | mid |
dog | 0 | start |
dog | 0 | start |
dog | 1 | mid |
dog | 1 | end |
dog | 0 | end |
dog | 1 | mid |
dog | 1 | start |
dog | 1 | end |
dog | 0 | mid |
dog | 0 | start |
dog | 0 | start |
dog | 0 | mid |
dog | 1 | end |
dog | 0 | end |
dog | 0 | mid |
dog | 2 | start |
dog | 0 | end |
dog | 1 | mid |
dog | 0 | start |
dog | 0 | start |
dog | 1 | mid |
dog | 0 | end |
dog | 0 | end |
dog | 1 | mid |
dog | 0 | start |
dog | 0 | end |
dog | 0 | mid |
dog | 1 | start |
dog | 2 | start |
dog | 0 | mid |
dog | 0 | end |
dog | 0 | start |
dog | 0 | mid |
dog | 1 | end |
dog | 0 | end |
dog | 0 | mid |
dog | 1 | start |
dog | 0 | end |
dog | 0 | mid |
dog | 1 | start |
dog | 0 | start |
dog | 0 | mid |
dog | 3 | end |
dog | 0 | end |
dog | 0 | mid |
dog | 1 | start |
dog | 0 | start |
dog | 0 | mid |
dog | 3 | end |
dog | 1 | start |
dog | 1 | mid |
dog | 2 | end |
animal | num | month | section |
---|---|---|---|
bird | 6 | 1977-06 | start |
cat | 4 | 1977-06 | end |
dog | 4 | 1971-05 | start |