explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ZyuL

Settings
# exclusive inclusive rows x rows loops node
1. 14.467 55.274 ↓ 0.0 0 1

Hash Semi Join (cost=17.84..3,849.20 rows=91 width=297) (actual time=55.274..55.274 rows=0 loops=1)

  • Hash Cond: (forms_historical.id = stg_attribute_values.form_id)
2. 40.746 40.769 ↓ 2.0 94,132 1

Seq Scan on forms_historical (cost=2.89..3,708.31 rows=46,897 width=297) (actual time=0.065..40.769 rows=94,132 loops=1)

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

SubPlan (for Seq Scan)

4. 0.023 0.023 ↑ 1.0 71 1

Seq Scan on stg_forms (cost=0.00..2.71 rows=71 width=16) (actual time=0.005..0.023 rows=71 loops=1)

5. 0.012 0.038 ↑ 5.4 41 1

Hash (cost=12.20..12.20 rows=220 width=16) (actual time=0.038..0.038 rows=41 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
6. 0.026 0.026 ↑ 5.4 41 1

Seq Scan on stg_attribute_values (cost=0.00..12.20 rows=220 width=16) (actual time=0.007..0.026 rows=41 loops=1)