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?.
6 rows affected
point | stop | nxt | grp |
---|---|---|---|
1 | t | 2 | 1 |
2 | f | 3 | 1 |
3 | t | 4 | 2 |
4 | f | 5 | 2 |
5 | f | 6 | 2 |
6 | t | null | 3 |
grp | points |
---|---|
1 | {"(1,2)","(2,3)"} |
2 | {"(3,4)","(4,5)","(5,6)"} |
grp | lines |
---|---|
1 | 010200000002000000000000000000F03F000000000000004000000000000000400000000000000840 |
2 | 010200000003000000000000000000084000000000000010400000000000001040000000000000144000000000000014400000000000001840 |