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?.
version |
---|
PostgreSQL 11.2 (Debian 11.2-1.pgdg90+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 6.3.0-18+deb9u1) 6.3.0 20170516, 64-bit |
1 rows affected
1 rows affected
id | fromval | toval |
---|---|---|
001 | {"subject":"Foo","id":"D4014"} | {"subject":"Bar","id":"D4014"} |
002 | {"id":"D4014","state":{"id":"GP2","name":"In progress"}} | {"id":"D4014","state":{"id":"GP8","name":"Closed"}} |
id | ?column? |
---|---|
001 | null |
002 | null |
id | json_each |
---|---|
001 | (subject,"""Foo""") |
001 | (id,"""D4014""") |
002 | (id,"""D4014""") |
002 | (state,"{""id"":""GP2"",""name"":""In progress""}") |