explain.depesz.com

PostgreSQL's explain analyze made readable

Result: iYj

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

Hash Semi Join (cost=30.30..9,874.31 rows=20 width=207) (actual time=0.013..0.013 rows=0 loops=1)

  • Hash Cond: (forms_historical.id = stg_attribute_values.form_id)
2. 0.000 0.000 ↓ 0.0 0

Seq Scan on forms_historical (cost=14.00..9,500.31 rows=136,132 width=207) (never executed)

  • Filter: (NOT (hashed SubPlan 1))
3.          

SubPlan (for Seq Scan)

4. 0.000 0.000 ↓ 0.0 0

Seq Scan on stg_forms (cost=0.00..13.20 rows=320 width=16) (never executed)

5. 0.000 0.002 ↓ 0.0 0 1

Hash (cost=12.80..12.80 rows=280 width=16) (actual time=0.002..0.002 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
6. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on stg_attribute_values (cost=0.00..12.80 rows=280 width=16) (actual time=0.002..0.002 rows=0 loops=1)

Planning time : 1.272 ms