explain.depesz.com

PostgreSQL's explain analyze made readable

Result: L9wd

Settings
# exclusive inclusive rows x rows loops node
1. 0.018 2.325 ↓ 10.0 10 1

Nested Loop (cost=2.13..108.31 rows=1 width=488) (actual time=1.986..2.325 rows=10 loops=1)

  • Join Filter: ((x.administrationid = ofrm.administrationid) AND (frm.assessmentformid = ofrm.assessmentformid) AND (sset.scoresetid = ofrm.scoresetid))
  • Rows Removed by Join Filter: 43
2. 0.050 2.217 ↓ 10.0 10 1

Nested Loop (cost=1.85..107.66 rows=1 width=512) (actual time=1.930..2.217 rows=10 loops=1)

  • Join Filter: ((x.administrationid = sset.administrationid) AND (tst.subtestid = sset.subtestid) AND ((x.scoresetcode)::text = (sset.scoresetcode)::text))
  • Rows Removed by Join Filter: 299
3. 0.007 0.247 ↓ 10.0 10 1

Nested Loop (cost=1.72..106.47 rows=1 width=514) (actual time=0.088..0.247 rows=10 loops=1)

  • Join Filter: ((x.administrationid = tst.administrationid) AND (lvl.subtestid = tst.subtestid))
  • Rows Removed by Join Filter: 10
4. 0.008 0.230 ↓ 10.0 10 1

Nested Loop (cost=1.72..105.37 rows=1 width=506) (actual time=0.083..0.230 rows=10 loops=1)

  • Join Filter: (x.administrationid = lvl.administrationid)
5. 0.009 0.202 ↓ 10.0 10 1

Nested Loop (cost=1.58..105.14 rows=1 width=498) (actual time=0.074..0.202 rows=10 loops=1)

  • Join Filter: (x.administrationid = frm.administrationid)
6. 0.006 0.173 ↓ 10.0 10 1

Nested Loop (cost=1.43..104.96 rows=1 width=486) (actual time=0.067..0.173 rows=10 loops=1)

  • Join Filter: (x.administrationid = org.administrationid)
7. 0.005 0.137 ↓ 10.0 10 1

Nested Loop (cost=1.15..104.62 rows=1 width=482) (actual time=0.058..0.137 rows=10 loops=1)

  • Join Filter: (x.administrationid = ses.administrationid)
8. 0.014 0.102 ↓ 10.0 10 1

Nested Loop (cost=0.86..104.29 rows=1 width=478) (actual time=0.048..0.102 rows=10 loops=1)

9. 0.038 0.038 ↓ 1.2 10 1

Index Scan using idx_stg_subtestobjective_score_1 on stg_subtestobjective_score x (cost=0.43..36.59 rows=8 width=470) (actual time=0.021..0.038 rows=10 loops=1)

  • Index Cond: ((row_num >= 1) AND (row_num <= 10))
10. 0.050 0.050 ↑ 1.0 1 10

Index Scan using idx_dim_assessmentparticipant_2 on dim_assessmentparticipant asmt (cost=0.43..8.45 rows=1 width=32) (actual time=0.005..0.005 rows=1 loops=10)

  • Index Cond: ((administrationid = x.administrationid) AND (documentidcode = x.documentidcode))
  • Filter: ((x.studentidcode = studentidcode) AND (x.testeventidcode = testeventidcode))
11. 0.030 0.030 ↑ 1.0 1 10

Index Scan using pk_dim_assessmentsession on dim_assessmentsession ses (cost=0.29..0.31 rows=1 width=12) (actual time=0.003..0.003 rows=1 loops=10)

  • Index Cond: (assessmentsessionid = asmt.assessmentsessionid)
  • Filter: (asmt.administrationid = administrationid)
12. 0.030 0.030 ↑ 1.0 1 10

Index Scan using idx_dim_organizations_2 on dim_organizations org (cost=0.28..0.33 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=10)

  • Index Cond: ((administrationid = ses.administrationid) AND (organizationid = ses.organizationid))
  • Filter: (orglevel = 2)
13. 0.020 0.020 ↑ 1.0 1 10

Index Scan using pk_dim_assessmentform on dim_assessmentform frm (cost=0.14..0.17 rows=1 width=12) (actual time=0.002..0.002 rows=1 loops=10)

  • Index Cond: (assessmentformid = asmt.assessmentformid)
  • Filter: (asmt.administrationid = administrationid)
14. 0.020 0.020 ↑ 1.0 1 10

Index Scan using pk_dim_assessmentlevel on dim_assessmentlevel lvl (cost=0.14..0.22 rows=1 width=12) (actual time=0.002..0.002 rows=1 loops=10)

  • Index Cond: (assessmentlevelid = frm.assessmentlevelid)
  • Filter: (frm.administrationid = administrationid)
15. 0.010 0.010 ↑ 2.0 2 10

Seq Scan on dim_subtest tst (cost=0.00..1.04 rows=4 width=8) (actual time=0.001..0.001 rows=2 loops=10)

16. 1.920 1.920 ↓ 1.0 31 10

Index Scan using udx_dim_scoreset on dim_scoreset sset (cost=0.14..0.66 rows=30 width=17) (actual time=0.186..0.192 rows=31 loops=10)

  • Index Cond: (administrationid = asmt.administrationid)
17. 0.090 0.090 ↑ 2.0 5 10

Index Only Scan using pk_dim_scoresetform on dim_scoresetform ofrm (cost=0.28..0.48 rows=10 width=12) (actual time=0.007..0.009 rows=5 loops=10)

  • Index Cond: ((administrationid = asmt.administrationid) AND (assessmentformid = asmt.assessmentformid))
  • Heap Fetches: 53
Planning time : 88.075 ms
Execution time : 2.513 ms