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 101
id | a |
---|---|
0 | null |
1 | 1 |
2 | 2 |
3 | 3 |
4 | null |
5 | 5 |
6 | null |
7 | 7 |
8 | null |
9 | 9 |
10 | 10 |
11 | null |
12 | 12 |
13 | 13 |
14 | 14 |
15 | 15 |
16 | null |
17 | null |
18 | null |
19 | 19 |
20 | null |
21 | 21 |
22 | null |
23 | 23 |
24 | 24 |
25 | null |
26 | 26 |
27 | 27 |
28 | 28 |
29 | 29 |
30 | null |
31 | null |
32 | 32 |
33 | null |
34 | 34 |
35 | null |
36 | 36 |
37 | null |
38 | null |
39 | null |
40 | null |
41 | 41 |
42 | 42 |
43 | 43 |
44 | 44 |
45 | 45 |
46 | 46 |
47 | null |
48 | null |
49 | null |
50 | null |
51 | null |
52 | null |
53 | null |
54 | null |
55 | 55 |
56 | 56 |
57 | null |
58 | null |
59 | 59 |
60 | 60 |
61 | null |
62 | 62 |
63 | 63 |
64 | null |
65 | null |
66 | null |
67 | 67 |
68 | 68 |
69 | 69 |
70 | null |
71 | null |
72 | 72 |
73 | null |
74 | 74 |
75 | 75 |
76 | null |
77 | 77 |
78 | 78 |
79 | 79 |
80 | null |
81 | null |
82 | 82 |
83 | 83 |
84 | null |
85 | 85 |
86 | 86 |
87 | null |
88 | null |
89 | 89 |
90 | 90 |
91 | null |
92 | null |
93 | null |
94 | 94 |
95 | 95 |
96 | null |
97 | null |
98 | 98 |
99 | 99 |
100 | null |
SELECT 101
CREATE FUNCTION
CREATE AGGREGATE
id | a | lnn |
---|---|---|
0 | null | null |
1 | 1 | 1 |
2 | 2 | 2 |
3 | 3 | 3 |
4 | null | 3 |
5 | 5 | 5 |
6 | null | 5 |
7 | 7 | 7 |
8 | null | 7 |
9 | 9 | 9 |
10 | 10 | 10 |
11 | null | 10 |
12 | 12 | 12 |
13 | 13 | 13 |
14 | 14 | 14 |
15 | 15 | 15 |
16 | null | 15 |
17 | null | 15 |
18 | null | 15 |
19 | 19 | 19 |
20 | null | 19 |
21 | 21 | 21 |
22 | null | 21 |
23 | 23 | 23 |
24 | 24 | 24 |
25 | null | 24 |
26 | 26 | 26 |
27 | 27 | 27 |
28 | 28 | 28 |
29 | 29 | 29 |
30 | null | 29 |
31 | null | 29 |
32 | 32 | 32 |
33 | null | 32 |
34 | 34 | 34 |
35 | null | 34 |
36 | 36 | 36 |
37 | null | 36 |
38 | null | 36 |
39 | null | 36 |
40 | null | 36 |
41 | 41 | 41 |
42 | 42 | 42 |
43 | 43 | 43 |
44 | 44 | 44 |
45 | 45 | 45 |
46 | 46 | 46 |
47 | null | 46 |
48 | null | 46 |
49 | null | 46 |
50 | null | 46 |
51 | null | 46 |
52 | null | 46 |
53 | null | 46 |
54 | null | 46 |
55 | 55 | 55 |
56 | 56 | 56 |
57 | null | 56 |
58 | null | 56 |
59 | 59 | 59 |
60 | 60 | 60 |
61 | null | 60 |
62 | 62 | 62 |
63 | 63 | 63 |
64 | null | 63 |
65 | null | 63 |
66 | null | 63 |
67 | 67 | 67 |
68 | 68 | 68 |
69 | 69 | 69 |
70 | null | 69 |
71 | null | 69 |
72 | 72 | 72 |
73 | null | 72 |
74 | 74 | 74 |
75 | 75 | 75 |
76 | null | 75 |
77 | 77 | 77 |
78 | 78 | 78 |
79 | 79 | 79 |
80 | null | 79 |
81 | null | 79 |
82 | 82 | 82 |
83 | 83 | 83 |
84 | null | 83 |
85 | 85 | 85 |
86 | 86 | 86 |
87 | null | 86 |
88 | null | 86 |
89 | 89 | 89 |
90 | 90 | 90 |
91 | null | 90 |
92 | null | 90 |
93 | null | 90 |
94 | 94 | 94 |
95 | 95 | 95 |
96 | null | 95 |
97 | null | 95 |
98 | 98 | 98 |
99 | 99 | 99 |
100 | null | 99 |
SELECT 101
id | a | find_last_ignore_nulls |
---|---|---|
0 | null | null |
1 | 1 | 1 |
2 | 2 | 2 |
3 | 3 | 3 |
4 | null | 3 |
5 | 5 | 5 |
6 | null | 5 |
7 | 7 | 7 |
8 | null | 7 |
9 | 9 | 9 |
10 | 10 | 10 |
11 | null | 10 |
12 | 12 | 12 |
13 | 13 | 13 |
14 | 14 | 14 |
15 | 15 | 15 |
16 | null | 15 |
17 | null | 15 |
18 | null | 15 |
19 | 19 | 19 |
20 | null | 19 |
21 | 21 | 21 |
22 | null | 21 |
23 | 23 | 23 |
24 | 24 | 24 |
25 | null | 24 |
26 | 26 | 26 |
27 | 27 | 27 |
28 | 28 | 28 |
29 | 29 | 29 |
30 | null | 29 |
31 | null | 29 |
32 | 32 | 32 |
33 | null | 32 |
34 | 34 | 34 |
35 | null | 34 |
36 | 36 | 36 |
37 | null | 36 |
38 | null | 36 |
39 | null | 36 |
40 | null | 36 |
41 | 41 | 41 |
42 | 42 | 42 |
43 | 43 | 43 |
44 | 44 | 44 |
45 | 45 | 45 |
46 | 46 | 46 |
47 | null | 46 |
48 | null | 46 |
49 | null | 46 |
50 | null | 46 |
51 | null | 46 |
52 | null | 46 |
53 | null | 46 |
54 | null | 46 |
55 | 55 | 55 |
56 | 56 | 56 |
57 | null | 56 |
58 | null | 56 |
59 | 59 | 59 |
60 | 60 | 60 |
61 | null | 60 |
62 | 62 | 62 |
63 | 63 | 63 |
64 | null | 63 |
65 | null | 63 |
66 | null | 63 |
67 | 67 | 67 |
68 | 68 | 68 |
69 | 69 | 69 |
70 | null | 69 |
71 | null | 69 |
72 | 72 | 72 |
73 | null | 72 |
74 | 74 | 74 |
75 | 75 | 75 |
76 | null | 75 |
77 | 77 | 77 |
78 | 78 | 78 |
79 | 79 | 79 |
80 | null | 79 |
81 | null | 79 |
82 | 82 | 82 |
83 | 83 | 83 |
84 | null | 83 |
85 | 85 | 85 |
86 | 86 | 86 |
87 | null | 86 |
88 | null | 86 |
89 | 89 | 89 |
90 | 90 | 90 |
91 | null | 90 |
92 | null | 90 |
93 | null | 90 |
94 | 94 | 94 |
95 | 95 | 95 |
96 | null | 95 |
97 | null | 95 |
98 | 98 | 98 |
99 | 99 | 99 |
100 | null | 99 |
SELECT 101