explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CCte

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 26,738.543 ↓ 0.0 0 1

Delete on modification_history (cost=87,319.15..2,343,902.44 rows=2,285,052 width=6) (actual time=26,738.543..26,738.543 rows=0 loops=1)

2. 25,657.445 26,738.542 ↓ 0.0 0 1

Seq Scan on modification_history (cost=87,319.15..2,343,902.44 rows=2,285,052 width=6) (actual time=26,738.542..26,738.542 rows=0 loops=1)

  • Filter: (NOT (hashed SubPlan 1))
  • Rows Removed by Filter: 2286265
3.          

SubPlan (forSeq Scan)

4. 1,081.097 1,081.097 ↓ 1.0 92,626 1

Seq Scan on users (cost=0.00..87,087.72 rows=92,572 width=4) (actual time=0.186..1,081.097 rows=92,626 loops=1)