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?.
SELECT 15
rid |
---|
41 |
42 |
43 |
44 |
SELECT 4
rid |
---|
41 |
42 |
43 |
44 |
SELECT 4
rid |
---|
43 |
44 |
SELECT 2
rid |
---|
43 |
44 |
SELECT 2
SELECT 3
b |
---|
1 |
2 |
3 |
SELECT 3
rid | root_id | id | sent_date | max |
---|---|---|---|---|
41 | 41 | 41 | 2024-02-02 | 2024-04-02 |
41 | 41 | 51 | 2024-03-02 | 2024-04-02 |
42 | 42 | 42 | 2024-02-03 | 2024-04-03 |
42 | 42 | 52 | 2024-03-03 | 2024-04-03 |
43 | 43 | 43 | 2024-02-04 | 2024-04-04 |
43 | 43 | 53 | 2024-03-04 | 2024-04-04 |
44 | 44 | 44 | 2024-02-05 | 2024-04-05 |
44 | 44 | 54 | 2024-03-05 | 2024-04-05 |
SELECT 8