explain.depesz.com

PostgreSQL's explain analyze made readable

Result: OtpZ

Settings
# exclusive inclusive rows x rows loops node
1. 16.869 42.687 ↓ 0.0 0 1

Update on ifood_region.deliveries d (cost=303.12..77,020.33 rows=7,066 width=133) (actual time=42.687..42.687 rows=0 loops=1)

  • Buffers: shared hit=721 read=143 dirtied=78
2. 0.036 25.818 ↑ 294.4 24 1

Nested Loop (cost=303.12..77,020.33 rows=7,066 width=133) (actual time=18.739..25.818 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=73 read=74 dirtied=12
3. 17.556 18.294 ↑ 516.8 24 1

Bitmap Heap Scan on ifood_region.deliveries d (cost=302.69..23,667.16 rows=12,404 width=95) (actual time=18.250..18.294 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=44
  • Buffers: shared hit=6 read=45 dirtied=5
4. 0.738 0.738 ↑ 64.6 192 1

Bitmap Index Scan on deliveries_owner_id_pol_id_idx (cost=0.00..299.59 rows=12,404 width=0) (actual time=0.738..0.738 rows=192 loops=1)

  • Index Cond: (d.owner_id = 'ef5e83ed-e7b2-4dbc-b0cf-ec9f940a8870'::uuid)
  • Buffers: shared hit=3 read=4
5. 7.488 7.488 ↑ 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=0.312..0.312 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=67 read=29 dirtied=7
Planning time : 0.432 ms
Execution time : 46.025 ms
Trigger times:
Trigger Name:Total time:Calls:Average time:
deliveries_last_updated 0.172 ms 24 0.007 ms
tg_deliveries_audit 3.278 ms 24 0.137 ms