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
| name_1 | status | name_3 |
|---|---|---|
| info_1 | up | info_1 |
| info_2 (info_2_new) | down | |
| info_3 (info_3_new) | error | |
| info_4 | error | |
| info_5 | down | |
| info_6 | up | info_6 |
SELECT 6
CREATE TABLE
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
| name_1 | status | name_3 |
|---|---|---|
| info_1 | up | info_1 |
| info_2 (info_2_new) | down | info_2_new |
| info_3 (info_3_new) | error | info_3_new |
| info_4 | error | info_4 |
| info_5 | down | info_5 |
| info_6 | up | info_6 |
SELECT 6