explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4fLQ

Settings
# exclusive inclusive rows x rows loops node
1. 0.006 0.020 ↓ 0.0 0 1

Hash Join (cost=28.72..9,828.06 rows=62,549 width=269) (actual time=0.020..0.020 rows=0 loops=1)

  • Hash Cond: ((forms_historical.stop_id = forms.stop_id) AND ((timezone(forms_historical.tz, forms_historical.effective_date))::date = (timezone(forms.tz, forms.effective_date))::date))
2. 0.013 0.013 ↑ 125,098.0 1 1

Seq Scan on forms_historical (cost=13.00..8,237.44 rows=125,098 width=269) (actual time=0.013..0.013 rows=1 loops=1)

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

SubPlan (for Seq Scan)

4. 0.000 0.000 ↓ 0.0 0 1

Seq Scan on stg_forms (cost=0.00..12.40 rows=240 width=16) (actual time=0.000..0.000 rows=0 loops=1)

5. 0.000 0.001 ↓ 0.0 0 1

Hash (cost=14.45..14.45 rows=85 width=40) (actual time=0.001..0.001 rows=0 loops=1)

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

HashAggregate (cost=13.60..14.45 rows=85 width=40) (actual time=0.001..0.001 rows=0 loops=1)

  • Group Key: forms.stop_id, (timezone(forms.tz, forms.effective_date))::date
7. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on stg_forms forms (cost=0.00..12.40 rows=240 width=40) (actual time=0.001..0.001 rows=0 loops=1)

Planning time : 0.283 ms