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
node | connections | nodes_in_chain |
---|---|---|
a | {a,b} | null |
b | {a,b,c,d} | null |
c | {b,c} | null |
d | {b,d} | null |
e | {e,f} | null |
f | {e,f} | null |
node | connections | nodes_in_chain |
---|---|---|
a | {a,b} | {a,b,c,d} |
b | {a,b,c,d} | {a,b,c,d} |
c | {b,c} | {a,b,c,d} |
d | {b,d} | {a,b,c,d} |
e | {e,f} | {e,f} |
f | {e,f} | {e,f} |
1 rows affected
3 rows affected
src | nodes_in_chain |
---|---|
a | {a,b,c,d} |
b | {a,b,c,d} |
c | {a,b,c,d} |
d | {a,b,c,d} |
e | {e,f,g,h} |
f | {e,f,g,h} |
g | {e,f,g,h} |
h | {e,f,g,h} |
node | connections | nodes_in_chain |
---|---|---|
a | {a,b} | {a,b,c,d} |
b | {a,b,c,d} | {a,b,c,d} |
c | {b,c} | {a,b,c,d} |
d | {b,d} | {a,b,c,d} |
e | {e,f} | {e,f,g} |
f | {e,f,g} | {e,f,g} |
g | {f,g,h} | {f,g,h} |
h | {g,h} | {f,g,h} |