explain.depesz.com

PostgreSQL's explain analyze made readable

Result: u2IV

Settings
# exclusive inclusive rows x rows loops node
1. 0.070 903.950 ↓ 10.0 10 1

Nested Loop Left Join (cost=2.12..3,587.35 rows=1 width=197) (actual time=17.951..903.950 rows=10 loops=1)

  • Join Filter: ((x.administrationid = fact.administrationid) AND (fact.organizationid = org.organizationid) AND (fact.subtestid = obj.subtestid) AND (fact.assessmentlevelid = frm.assessmentlevelid) AND (fact.assessmentformid = frm.assessmentformid) AND (fact.objectiveid = obj.objectiveid))
  • Rows Removed by Join Filter: 45
2. 0.035 903.750 ↓ 10.0 10 1

Nested Loop (cost=1.70..3,578.88 rows=1 width=189) (actual time=17.921..903.750 rows=10 loops=1)

  • Join Filter: ((frm.assessmentformid = ofrm.assessmentformid) AND (obj.objectiveid = ofrm.objectiveid))
  • Rows Removed by Join Filter: 68
3. 0.016 903.675 ↓ 10.0 10 1

Nested Loop (cost=1.70..3,577.36 rows=1 width=189) (actual time=17.914..903.675 rows=10 loops=1)

4. 0.020 903.609 ↓ 10.0 10 1

Nested Loop (cost=1.42..3,576.89 rows=1 width=189) (actual time=17.907..903.609 rows=10 loops=1)

5. 22.618 903.539 ↓ 10.0 10 1

Nested Loop (cost=1.14..3,568.58 rows=1 width=189) (actual time=17.900..903.539 rows=10 loops=1)

  • Join Filter: (frm.assessmentformid = asmt.assessmentformid)
  • Rows Removed by Join Filter: 3
6. 67.439 406.201 ↓ 237,360.0 237,360 1

Nested Loop (cost=0.85..3,568.24 rows=1 width=173) (actual time=0.065..406.201 rows=237,360 loops=1)

7. 0.048 0.315 ↓ 19.0 19 1

Nested Loop (cost=0.43..20.51 rows=1 width=58) (actual time=0.050..0.315 rows=19 loops=1)

  • Join Filter: ((frm.assessmentlevelid = lvl.assessmentlevelid) AND (tst.subtestid = lvl.subtestid))
  • Rows Removed by Join Filter: 19
8. 0.035 0.115 ↓ 38.0 38 1

Nested Loop (cost=0.29..17.81 rows=1 width=62) (actual time=0.023..0.115 rows=38 loops=1)

  • Join Filter: (tst.subtestid = obj.subtestid)
  • Rows Removed by Join Filter: 38
9. 0.008 0.032 ↓ 4.0 4 1

Nested Loop (cost=0.29..16.33 rows=1 width=28) (actual time=0.016..0.032 rows=4 loops=1)

10. 0.012 0.012 ↓ 2.0 2 1

Index Scan using udx_dim_assessmentform on dim_assessmentform frm (cost=0.14..8.16 rows=1 width=16) (actual time=0.009..0.012 rows=2 loops=1)

  • Index Cond: (administrationid = 525994)
11. 0.012 0.012 ↓ 2.0 2 2

Index Scan using udx_dim_subtest on dim_subtest tst (cost=0.14..8.16 rows=1 width=12) (actual time=0.004..0.006 rows=2 loops=2)

  • Index Cond: (administrationid = 525994)
12. 0.048 0.048 ↑ 1.0 19 4

Seq Scan on dim_objective obj (cost=0.00..1.24 rows=19 width=34) (actual time=0.003..0.012 rows=19 loops=4)

  • Filter: (administrationid = 525994)
13. 0.152 0.152 ↑ 1.0 1 38

Index Scan using udx_dim_assessmentlevel on dim_assessmentlevel lvl (cost=0.15..2.69 rows=1 width=20) (actual time=0.004..0.004 rows=1 loops=38)

  • Index Cond: ((administrationid = 525994) AND (subtestid = obj.subtestid))
14. 338.447 338.447 ↓ 1.1 12,493 19

Index Scan using pk_stg_subtestobjective_score on stg_subtestobjective_score x (cost=0.42..3,435.00 rows=11,272 width=159) (actual time=0.008..17.813 rows=12,493 loops=19)

  • Index Cond: ((administrationid = 525994) AND ((objectivecode)::text = (obj.objectivecode)::text))
15. 474.720 474.720 ↓ 0.0 0 237,360

Index Scan using udx_dim_assessmentparticipant on dim_assessmentparticipant asmt (cost=0.29..0.34 rows=1 width=48) (actual time=0.002..0.002 rows=0 loops=237,360)

  • Index Cond: ((administrationid = 525994) AND (documentidcode = x.documentidcode) AND (testeventidcode = x.testeventidcode))
  • Filter: (assessmentparticipantid = 23)
  • Rows Removed by Filter: 1
16. 0.050 0.050 ↑ 1.0 1 10

Index Scan using pk_dim_assessmentsession on dim_assessmentsession ses (cost=0.28..8.30 rows=1 width=20) (actual time=0.005..0.005 rows=1 loops=10)

  • Index Cond: (assessmentsessionid = asmt.assessmentsessionid)
  • Filter: (administrationid = 525994)
17. 0.050 0.050 ↑ 1.0 1 10

Index Scan using pk_dim_organizations on dim_organizations org (cost=0.28..0.47 rows=1 width=12) (actual time=0.005..0.005 rows=1 loops=10)

  • Index Cond: (organizationid = ses.organizationid)
  • Filter: ((administrationid = 525994) AND (orglevel = 2))
18. 0.040 0.040 ↑ 2.4 8 10

Seq Scan on dim_objectiveform ofrm (cost=0.00..1.24 rows=19 width=20) (actual time=0.003..0.004 rows=8 loops=10)

  • Filter: (administrationid = 525994)
19. 0.130 0.130 ↓ 6.0 6 10

Index Scan using idx_fact_subtestobjectiveresult_1 on fact_subtestobjectiveresult fact (cost=0.42..8.45 rows=1 width=68) (actual time=0.010..0.013 rows=6 loops=10)

  • Index Cond: ((administrationid = 525994) AND (participantid = asmt.participantid) AND (assessmentparticipantid = asmt.assessmentparticipantid) AND (assessmentparticipantid = 23))