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?.
CREATE TABLE
INSERT 0 33
CREATE TABLE
CREATE TYPE
data
null
0
00
0A
0A0B
00B
0B
00B0B00
0B000B
0B00B
0B0B
0B0B
0B0B0
1A
2A
10A
a111111111111111111111
A
AAA1BB
AAA10B
AAA11B
AAA20B
AAA21B
B
X1C1
X1C3
X1C4
X1C10
X1C30
X2C1
X10C2
X10C10
SELECT 33
data
0
00
0A
0A0B
00B
0B
00B0B00
0B000B
0B00B
0B0B
0B0B
0B0B0
1A
2A
10A
a111111111111111111111
A
AAA1BB
AAA10B
AAA11B
AAA20B
AAA21B
B
X1C1
X1C3
X1C4
X1C10
X1C30
X2C1
X10C2
X10C10
SELECT 32