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?.
16 rows affected
id | type | master_guid |
---|---|---|
1 | a | uuid-1 |
2 | a | uuid-2 |
3 | a | uuid-3 |
4 | a | uuid-4 |
5 | a | uuid-5 |
6 | b | uuid-1 |
7 | b | uuid-2 |
8 | b | uuid-3 |
9 | b | uuid-6 |
10 | c | uuid-1 |
11 | c | uuid-2 |
12 | c | uuid-3 |
13 | c | uuid-6 |
14 | c | uuid-7 |
15 | d | uuid-6 |
16 | d | uuid-2 |
id | type | uuid | mapped_ids |
---|---|---|---|
1 | a | uuid-1 | {10,6,1} |
2 | a | uuid-2 | {16,2,7,11} |
3 | a | uuid-3 | {8,3,12} |
4 | a | uuid-4 | {4} |
5 | a | uuid-5 | {5} |
6 | b | uuid-1 | {10,6,1} |
7 | b | uuid-2 | {16,2,7,11} |
8 | b | uuid-3 | {8,3,12} |
9 | b | uuid-6 | {15,13,9} |
10 | c | uuid-1 | {10,6,1} |
11 | c | uuid-2 | {16,2,7,11} |
12 | c | uuid-3 | {8,3,12} |
13 | c | uuid-6 | {15,13,9} |
14 | c | uuid-7 | {14} |
15 | d | uuid-6 | {15,13,9} |
16 | d | uuid-2 | {16,2,7,11} |
id | type | uuid | mapped_ids |
---|---|---|---|
1 | a | uuid-1 | {10,6} |
2 | a | uuid-2 | {16,7,11} |
3 | a | uuid-3 | {8,12} |
4 | a | uuid-4 | {} |
5 | a | uuid-5 | {} |
6 | b | uuid-1 | {10,1} |
7 | b | uuid-2 | {16,2,11} |
8 | b | uuid-3 | {3,12} |
9 | b | uuid-6 | {15,13} |
10 | c | uuid-1 | {6,1} |
11 | c | uuid-2 | {16,2,7} |
12 | c | uuid-3 | {8,3} |
13 | c | uuid-6 | {15,9} |
14 | c | uuid-7 | {} |
15 | d | uuid-6 | {13,9} |
16 | d | uuid-2 | {2,7,11} |
id | type | uuid | mapped_ids |
---|---|---|---|
1 | a | uuid-1 | {10,6} |
2 | a | uuid-2 | {16,7,11} |
3 | a | uuid-3 | {8,12} |
4 | a | uuid-4 | null |
5 | a | uuid-5 | null |
6 | b | uuid-1 | {10,1} |
7 | b | uuid-2 | {16,2,11} |
8 | b | uuid-3 | {3,12} |
9 | b | uuid-6 | {15,13} |
10 | c | uuid-1 | {6,1} |
11 | c | uuid-2 | {16,2,7} |
12 | c | uuid-3 | {8,3} |
13 | c | uuid-6 | {15,9} |
14 | c | uuid-7 | null |
15 | d | uuid-6 | {13,9} |
16 | d | uuid-2 | {2,7,11} |