explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9IQq

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.003 ↓ 0.0 0 1

Nested Loop (cost=29.23..8,911.56 rows=50,986 width=207) (actual time=0.003..0.003 rows=0 loops=1)

2. 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: forms.stop_id, (timezone(forms.tz, forms.effective_date))::date
3. 0.001 0.001 ↓ 0.0 0 1

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

4. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_forms_historical_stop_id_client_day on forms_historical (cost=14.43..77.27 rows=8 width=207) (never executed)

  • Index Cond: ((stop_id = forms.stop_id) AND ((timezone(tz, effective_date))::date = (timezone(forms.tz, forms.effective_date))::date))
  • Filter: (NOT (hashed SubPlan 1))
5.          

SubPlan (for Index Scan)

6. 0.000 0.000 ↓ 0.0 0

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