explain.depesz.com

PostgreSQL's explain analyze made readable

Result: K2YP

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

Nested Loop (cost=33.05..41,858.37 rows=199,526 width=305) (actual time=0.002..0.002 rows=0 loops=1)

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

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

4. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on attribute_values (cost=19.45..491.66 rows=62 width=305) (never executed)

  • Recheck Cond: ((stop_id = stg_forms.stop_id) AND ((timezone((tz)::text, effective_date))::date = (timezone(stg_forms.tz, stg_forms.effective_date))::date))
  • Filter: (NOT (hashed SubPlan 1))
5. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on idx_attribute_values_stopid_effectivedate (cost=0.00..5.68 rows=125 width=0) (never executed)

  • Index Cond: ((stop_id = stg_forms.stop_id) AND ((timezone((tz)::text, effective_date))::date = (timezone(stg_forms.tz, stg_forms.effective_date))::date))
6.          

SubPlan (for Bitmap Heap Scan)

7. 0.000 0.000 ↓ 0.0 0

Seq Scan on stg_attribute_values (cost=0.00..13.00 rows=300 width=16) (never executed)