explain.depesz.com

PostgreSQL's explain analyze made readable

Result: mX4K

Settings
# exclusive inclusive rows x rows loops node
1. 402.451 4,965.588 ↑ 1,817.2 6 1

Hash Semi Join (cost=29.50..113,271.71 rows=10,903 width=341) (actual time=1,088.318..4,965.588 rows=6 loops=1)

  • Hash Cond: ((attribute_values.stop_id = stg_forms.stop_id) AND ((timezone((attribute_values.tz)::text, attribute_values.effective_date))::date = (timezone(stg_forms.tz, stg_forms.effective_date))::date))
2. 4,562.855 4,562.860 ↓ 2.1 661,593 1

Seq Scan on attribute_values (cost=13.50..109,366.38 rows=317,555 width=341) (actual time=3.138..4,562.860 rows=661,593 loops=1)

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

SubPlan (for Seq Scan)

4. 0.005 0.005 ↑ 93.3 3 1

Seq Scan on stg_attribute_values (cost=0.00..12.80 rows=280 width=16) (actual time=0.004..0.005 rows=3 loops=1)

5. 0.259 0.277 ↑ 48.0 5 1

Hash (cost=12.40..12.40 rows=240 width=40) (actual time=0.277..0.277 rows=5 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
6. 0.018 0.018 ↑ 48.0 5 1

Seq Scan on stg_forms (cost=0.00..12.40 rows=240 width=40) (actual time=0.013..0.018 rows=5 loops=1)

Planning time : 8.453 ms