add batch remove batch split batch comment selection show hidden batches hide batch highlight batch
db<>fiddle
donate feedback about
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}