explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ltjI

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 0.068 ↑ 20.0 1 1

Nested Loop (cost=25.93..892.87 rows=20 width=226) (actual time=0.067..0.068 rows=1 loops=1)

2. 0.011 0.017 ↑ 20.5 2 1

HashAggregate (cost=12.50..12.91 rows=41 width=16) (actual time=0.015..0.017 rows=2 loops=1)

  • Group Key: stg_attribute_values.form_id
3. 0.006 0.006 ↑ 100.0 2 1

Seq Scan on stg_attribute_values (cost=0.00..12.00 rows=200 width=16) (actual time=0.005..0.006 rows=2 loops=1)

4. 0.045 0.048 ↓ 0.0 0 2

Index Scan using forms_historical_pkey on forms_historical (cost=13.43..21.45 rows=1 width=226) (actual time=0.024..0.024 rows=0 loops=2)

  • Index Cond: (id = stg_attribute_values.form_id)
  • Filter: (NOT (hashed SubPlan 1))
  • Rows Removed by Filter: 0
5.          

SubPlan (for Index Scan)

6. 0.003 0.003 ↑ 240.0 1 1

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