select
  b.id, b.fdate,
  c.code, c.name
from ta_bundle b
left join ta_entity c on (c.id = b.entity_id)
rows 1000 to 1010

Select Expression
    -> First N Records
        -> Skip N Records
            -> Nested Loop Join (outer)
                -> Table "TA_BUNDLE" as "B" Full Scan
                -> Filter
                    -> Table "TA_ENTITY" as "C" Access By ID
                        -> Bitmap
                            -> Index "PK_TA_ENTITY" Unique Scan

TA_BUNDLE - 1010
TA_ENTITY - 1010

select
  b.id, b.fdate,
  c.code, c.name
from ta_bundle b
left join lateral (
  select c.code, c.name
  from ta_entity c
  where c.id = b.entity_id) c on true
rows 1000 to 1010

select
  b.id, b.fdate,
  -- ? c.code
  (select c.name from ta_entity c where c.id = b.entity_id)
from ta_bundle b
rows 1000 to 1010

with b as (
  select
    b.id, b.fdate, b.entity_id
  from ta_bundle b
  rows 1000 to 1010
  )
select
  b.id, b.fdate,
  c.code, c.name
from b
left join ta_entity c on (c.id = b.entity_id)

    -> Filter
        -> Table "TA_ENTITY" as "C" Access By ID
            -> Bitmap
                -> Index "PK_TA_ENTITY" Unique Scan