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?.
3 rows affected
| text |
|---|
| {"type": "something-else", "params": [{"value": {"path": "", "value": "not-id"}}]} |
| {"type": "something", "params": [{"value": {"id": "00de1be5-f75b-4072-ba30-c67e4fdf2333", "path": "/hardcoded/string"}}]} |
| {"type": "something", "params": [{"value": {"id": "00de1be5-f75b-4072-ba30-c67e4fdf2333", "path": "/hardcoded/string"}}, {"value": {"path": "", "value": "not-id"}}]} |