explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4NSv

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0 0 1

Delete on audit_evs_all_arc todel (cost=0.56..5,620.67 rows=1,000 width=38) (actual rows=0 loops=1)

  • Buffers: shared hit=6,058 read=1,531,086 dirtied=22,383 written=148
  • I/O Timings: read=80,401.617 write=1.479
2. 0.000 0.000 ↑ 1.0 1,000 1

Nested Loop (cost=0.56..5,620.67 rows=1,000 width=38) (actual rows=1,000 loops=1)

  • Buffers: shared hit=5,009 read=1,531,086 dirtied=22,339 written=148
  • I/O Timings: read=80,401.617 write=1.479
3. 0.000 0.000 ↑ 1.0 1,000 1

Subquery Scan on del_ids (cost=0.00..2,045.17 rows=1,000 width=40) (actual rows=1,000 loops=1)

  • Buffers: shared hit=10 read=1,531,085 dirtied=22,339 written=148
  • I/O Timings: read=80,380.117 write=1.479
4. 0.000 0.000 ↑ 1.0 1,000 1

Limit (cost=0.00..2,035.17 rows=1,000 width=8) (actual rows=1,000 loops=1)

  • Buffers: shared hit=10 read=1,531,085 dirtied=22,339 written=148
  • I/O Timings: read=80,380.117 write=1.479
5. 0.000 0.000 ↑ 963.0 1,000 1

Seq Scan on audit_evs_all_arc (cost=0.00..1,959,849.25 rows=962,991 width=8) (actual rows=1,000 loops=1)

  • Filter: ((when_created <= '2020-07-12 20:32:16.234+00'::timestamp with time zone) OR (when_created IS NULL))
  • Rows Removed by Filter: 32,778,930
  • Buffers: shared hit=10 read=1,531,085 dirtied=22,339 written=148
  • I/O Timings: read=80,380.117 write=1.479
6. 0.000 0.000 ↑ 1.0 1 1,000

Index Scan using audit_evs_all_arc_pk on audit_evs_all_arc todel (cost=0.56..3.58 rows=1 width=14) (actual rows=1 loops=1,000)

  • Index Cond: (audit_ev_id = del_ids.audit_ev_id)
  • Buffers: shared hit=4,999 read=1
  • I/O Timings: read=21.500