explain.depesz.com

PostgreSQL's explain analyze made readable

Result: r4Y5

Settings
# exclusive inclusive rows x rows loops node
1. 0.011 0.080 ↓ 0.0 0 1

Delete on c_bpartner_location (cost=0.56..8.58 rows=1 width=6) (actual time=0.080..0.080 rows=0 loops=1)

  • Buffers: shared hit=7 dirtied=1
2. 0.069 0.069 ↑ 1.0 1 1

Index Scan using c_bpartner_location_key on c_bpartner_location (cost=0.56..8.58 rows=1 width=6) (actual time=0.068..0.069 rows=1 loops=1)

  • Index Cond: ((c_bpartner_location_id)::text = 'B78935B1603E4364826DE9C1B70A2E4E'::text)
  • Buffers: shared hit=5 dirtied=1