sub orders, PostgreSQL

Language: Layout:

create table "Order"(object_id varchar(50) primary key, sub_orders jsonb);
insert into "Order" 
  (object_id, sub_orders)
values 
  ('1', '[
   {
      "className":"SubOrder",
      "__type":"Pointer",
      "objectId":"tIENf1PCHO"
   },
   {
      "className":"SubOrder",
      "__type":"Pointer",
      "objectId":"yKVDFEuWx7"
   }
]');

create table sub_Order(object_id varchar(50), order_items jsonb);
insert into sub_order (object_id, order_items)
values
('tIENf1PCHO', '[
                 {
                    "className":"SubOrderItem",
                    "__type":"Pointer",
                    "objectId":"6d1DLrmOTD"
                 },
                 {
                    "className":"SubOrderItem",
                    "__type":"Pointer",
                    "objectId":"xK6mR2PDDU"
                 }
              ]');
              
select o.object_id, so.*
from "Order" o
  cross join lateral jsonb_array_elements(sub_orders) j(suborder)
  join sub_order so on so.object_id = j.suborder ->> 'objectId'


absolute service time: 0,62 sec