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 3
| data | message | result |
|---|---|---|
| {"key1": 1, "key2": "first"} | this ${key2} is a test of ${key1} | this first is a test of 1 |
| {"key1": 2, "key2": "second"} | this ${key2} is a test | this second is a test |
| {"key1": 3, "key2": "third"} | this ${key1} is a test of ${key2} | this 3 is a test of third |
SELECT 3