LEFT OUTER JOIN ervice service2_ on ser0_1_.service_id = service2_. ID

CREATE UNIQUE INDEX service_pk ON service USING btree (id)

Seq Scan on service service2_ (cost=0.00..107,922.71 rows=1,962,771 width=236) (actual time=0.025..678.385 rows=1,962,771 loops=1)
Buffers: shared hit=88295

LEFT OUTER JOIN lateral (select 
	service2_.code,
	service2_. NAME,
	service2_.is_complex from
service service2_ where ser0_1_.service_id = service2_. ID limit 1) service2_ on true

Index Scan using service_pk on service service2_ (cost=0.43..8.45 rows=1 width=232) (actual time=0.009..0.009 rows=1 loops=56,677)
Index Cond: (ser0_1_.service_id = id)
Buffers: shared hit=226592 read=137
I/O Timings: read=333.080