explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CMBR : ewere

Settings
# exclusive inclusive rows x rows loops node
1. 1,125.065 73,600.838 ↓ 0.0 0 1

Delete on delete_test (cost=76,378.11..3,666,682.39 rows=1,000,000 width=63) (actual time=73,600.838..73,600.838 rows=0 loops=1)

  • Buffers: shared hit=3363336 read=138203 dirtied=40151 written=22
2. 40,853.024 72,475.773 ↑ 1.0 1,000,000 1

Hash Semi Join (cost=76,378.11..3,666,682.39 rows=1,000,000 width=63) (actual time=4,685.705..72,475.773 rows=1,000,000 loops=1)

  • Hash Cond: ((delete_test.delete_test_id)::text = ("ANY_subquery".delete_test_id)::text)
  • Buffers: shared hit=2363336 read=138203 dirtied=5777 written=22
3. 28,606.834 28,606.834 ↑ 1.0 96,000,000 1

Seq Scan on delete_test (cost=0.00..3,319,388.64 rows=98,967,864 width=39) (actual time=0.017..28,606.834 rows=96,000,000 loops=1)

  • Buffers: shared hit=2260295 read=69415 written=9
4. 956.896 3,015.915 ↑ 1.0 1,000,000 1

Hash (cost=63,878.11..63,878.11 rows=1,000,000 width=90) (actual time=3,015.915..3,015.915 rows=1,000,000 loops=1)

  • Buckets: 1048576 Batches: 1 Memory Usage: 124403kB
  • Buffers: shared hit=103041 read=68788 dirtied=5777 written=13
  • -> Subquery Scan on "ANY_subquery" (cost=0.00..63878.11 rows=1000000 width=90) (actual time=1052.531..2572.626 rows=1000000 loops=
  • Buffers: shared hit=103041 read=68788 dirtied=5777 written=13
5. 2,059.019 2,059.019 ↑ 1.0 1,000,000 1

Limit (cost=0.00..53,878.11 rows=1,000,000 width=33) (actual time=1,052.522..2,059.019 rows=1,000,000 loops=1)

  • Buffers: shared hit=103041 read=68788 dirtied=5777 written=13
  • -> Seq Scan on delete_test delete_test_1 (cost=0.00..3566808.30 rows=66201442 width=33) (actual time=1052.520..1662.34
  • Filter: ((order_date)::text >= '2012-01-01'::text)
  • Rows Removed by Filter: 2375492
  • Buffers: shared hit=103041 read=68788 dirtied=5777 written=13
Planning time : 0.131 ms
Execution time : 73,605.008 ms