explain.depesz.com

PostgreSQL's explain analyze made readable

Result: n7dQ

Settings
# exclusive inclusive rows x rows loops node
1. 269.158 535.320 ↓ 0.0 0 1

Update on ifood_region.deliveries d (cost=333.12..77,050.33 rows=7,066 width=133) (actual time=535.320..535.320 rows=0 loops=1)

  • Buffers: shared hit=763 read=112 dirtied=79 written=61
2. 0.074 266.162 ↑ 294.4 24 1

Nested Loop (cost=333.12..77,050.33 rows=7,066 width=133) (actual time=172.419..266.162 rows=24 loops=1)

  • Output: d.del_id, d.pol_id, d.owner_id, d.mode, d.priority, 'REMOVED'::text, d.time_formula, d.fee_formula, d.creation_date, d.last_updated, d.ctid, p.ctid
  • Inner Unique: true
  • Buffers: shared hit=107 read=41 dirtied=4 written=24
3. 151.133 172.200 ↑ 516.8 24 1

Bitmap Heap Scan on ifood_region.deliveries d (cost=332.69..23,697.16 rows=12,404 width=95) (actual time=172.161..172.200 rows=24 loops=1)

  • Output: d.del_id, d.pol_id, d.owner_id, d.mode, d.priority, d.time_formula, d.fee_formula, d.creation_date, d.last_updated, d.ctid
  • Recheck Cond: ((d.owner_id = 'ef5e83ed-e7b2-4dbc-b0cf-ec9f940a8870'::uuid) AND (d.status <> 'REMOVED'::text))
  • Heap Blocks: exact=47
  • Buffers: shared hit=32 read=20 dirtied=3 written=11
4. 21.067 21.067 ↑ 57.4 216 1

Bitmap Index Scan on deliveries_owner_id_notremoved_idx (cost=0.00..329.59 rows=12,404 width=0) (actual time=21.067..21.067 rows=216 loops=1)

  • Index Cond: (d.owner_id = 'ef5e83ed-e7b2-4dbc-b0cf-ec9f940a8870'::uuid)
  • Buffers: shared hit=4 read=1
5. 93.888 93.888 ↑ 1.0 1 24

Index Scan using polygons_pkey on ifood_region.polygons p (cost=0.43..4.30 rows=1 width=22) (actual time=3.912..3.912 rows=1 loops=24)

  • Output: p.ctid, p.pol_id
  • Index Cond: (p.pol_id = d.pol_id)
  • Filter: (p.type = 'KML'::text)
  • Buffers: shared hit=75 read=21 dirtied=1 written=13