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 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
id label
26 DIRECTORY 0057
25 DIRECTORY 057
21 DIRECTORY 1000000
27 DIRECTORY 52
22 DIRECTORY 57
24 DIRECTORY 57000
23 DIRECTORY 9999
9 DISK 1
8 DISK 10
5 DISK 15
1 DISK 2
13 DISK 20
6 DISK 27
15 DISK 2A
16 DISK 2B
17 DISK 2B 33
18 DISK 2B 4
10 DISK 3
3 DISK 33
12 DISK 4
2 DISK 5
14 DISK 6
4 DISK 7
7 DISK 8
11 DISK 9
19 FILE 62
20 FILE 7
SELECT 27
CREATE COLLATION
id label
27 DIRECTORY 52
26 DIRECTORY 0057
25 DIRECTORY 057
22 DIRECTORY 57
23 DIRECTORY 9999
24 DIRECTORY 57000
21 DIRECTORY 1000000
9 DISK 1
1 DISK 2
15 DISK 2A
16 DISK 2B
18 DISK 2B 4
17 DISK 2B 33
10 DISK 3
12 DISK 4
2 DISK 5
14 DISK 6
4 DISK 7
7 DISK 8
11 DISK 9
8 DISK 10
5 DISK 15
13 DISK 20
6 DISK 27
3 DISK 33
20 FILE 7
19 FILE 62
SELECT 27