explain.depesz.com

PostgreSQL's explain analyze made readable

Result: sSk

Settings
# exclusive inclusive rows x rows loops node
1. 87.938 87.941 ↓ 2.0 920,775 1

Seq Scan on addresses_task (cost=30.48..21,203.16 rows=460,388 width=53) (actual time=0.021..87.941 rows=920,775 loops=1)

  • Filter: (NOT (hashed SubPlan 2))
2.          

CTE results

3. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on addresses_results (cost=0.00..16.30 rows=630 width=4) (actual time=0.001..0.002 rows=0 loops=1)

4.          

SubPlan (forSeq Scan)

5. 0.003 0.003 ↓ 0.0 0 1

CTE Scan on results (cost=0.00..12.60 rows=630 width=4) (actual time=0.003..0.003 rows=0 loops=1)

Planning time : 0.122 ms
Execution time : 114.671 ms