explain.depesz.com

PostgreSQL's explain analyze made readable

Result: PbD9

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 3.125 ↑ 200.0 1 1

Unique (cost=1,733.53..1,736.24 rows=200 width=226) (actual time=3.125..3.125 rows=1 loops=1)

2. 0.004 3.124 ↑ 200.0 1 1

Merge Anti Join (cost=1,733.53..1,735.74 rows=200 width=226) (actual time=3.124..3.124 rows=1 loops=1)

  • Merge Cond: (forms_h.id = forms.id)
3. 0.016 3.109 ↑ 100.0 2 1

Sort (cost=1,711.64..1,712.14 rows=200 width=226) (actual time=3.109..3.109 rows=2 loops=1)

  • Sort Key: forms_h.id
  • Sort Method: quicksort Memory: 25kB
4. 0.005 3.093 ↑ 100.0 2 1

Nested Loop (cost=0.43..1,704.00 rows=200 width=226) (actual time=3.080..3.093 rows=2 loops=1)

5. 0.004 0.004 ↑ 100.0 2 1

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

6. 3.084 3.084 ↑ 1.0 1 2

Index Scan using forms_historical_pkey on forms_historical forms_h (cost=0.43..8.45 rows=1 width=226) (actual time=1.541..1.542 rows=1 loops=2)

  • Index Cond: (id = sav.form_id)
7. 0.009 0.011 ↑ 240.0 1 1

Sort (cost=21.89..22.49 rows=240 width=16) (actual time=0.011..0.011 rows=1 loops=1)

  • Sort Key: forms.id
  • Sort Method: quicksort Memory: 25kB
8. 0.002 0.002 ↑ 240.0 1 1

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