Parse JSON string down to key and values in Postgres, PostgreSQL

Language: Layout:

drop table if exists my_table;
create table my_table(jdata jsonb);
insert into my_table values
('{
"route": {
    "coding": [
        {
            "code": 56,
            "display": "ORAL",
            "userSelected": true
        }
    ]
}
}');

with recursive extract_all as
(
    select
		null as parent,
        key, 
        value,
		jsonb_typeof(value) as type
    from my_table
    cross join lateral jsonb_each(jdata)
union all
    select
		key,
        coalesce(obj_key, (arr_key- 1)::text),
        coalesce(obj_value, arr_value),
		jsonb_typeof(coalesce(obj_value, arr_value))
    from extract_all
    left join lateral 
        jsonb_each(case jsonb_typeof(value) when 'object' then value end) 
        as o(obj_key, obj_value) 
        on jsonb_typeof(value) = 'object'
    left join lateral 
        jsonb_array_elements(case jsonb_typeof(value) when 'array' then value end) 
        with ordinality as a(arr_value, arr_key)
        on jsonb_typeof(value) = 'array'
    where obj_key is not null or arr_key is not null
)
select *
from extract_all;


absolute service time: 0,41 sec