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?.
1 rows affected
| ip |
|---|
| 0:0:0:0:0:ffff:1.0.80.255 |
| ip |
|---|
| ::ffff:1.0.80.255 |
2 rows affected
| ip |
|---|
| ::ffff:1.0.80.255 |
| ::4a18:e00b:80ff |
| 224.0.0.1 |