explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ETNN5

Settings
# exclusive inclusive rows x rows loops node
1. 0.009 7.694 ↓ 0.0 0 1

Hash Join (cost=31.18..518,446.87 rows=524,337 width=574) (actual time=7.694..7.694 rows=0 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. 7.681 7.683 ↑ 1,513,635.0 1 1

Seq Scan on attribute_values (cost=13.50..499,453.38 rows=1,513,635 width=574) (actual time=7.683..7.683 rows=1 loops=1)

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

SubPlan (for Seq Scan)

4. 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)

5. 0.000 0.002 ↓ 0.0 0 1

Hash (cost=15.95..15.95 rows=115 width=40) (actual time=0.002..0.002 rows=0 loops=1)

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

HashAggregate (cost=14.80..15.95 rows=115 width=40) (actual time=0.002..0.002 rows=0 loops=1)

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

Seq Scan on stg_forms (cost=0.00..13.20 rows=320 width=40) (actual time=0.001..0.001 rows=0 loops=1)

Planning time : 4.322 ms