explain.depesz.com

PostgreSQL's explain analyze made readable

Result: nct1

Settings
# exclusive inclusive rows x rows loops node
1. 0.058 43.523 ↓ 9.0 9 1

Nested Loop Left Join (cost=9.30..7,302.71 rows=1 width=197) (actual time=16.115..43.523 rows=9 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: 72
2. 0.030 43.420 ↓ 9.0 9 1

Nested Loop (cost=8.88..7,294.23 rows=1 width=189) (actual time=16.078..43.420 rows=9 loops=1)

  • Join Filter: ((frm.assessmentformid = ofrm.assessmentformid) AND (obj.objectiveid = ofrm.objectiveid))
  • Rows Removed by Join Filter: 162
3. 0.011 43.372 ↓ 9.0 9 1

Nested Loop (cost=8.88..7,292.71 rows=1 width=189) (actual time=16.064..43.372 rows=9 loops=1)

  • Join Filter: (lvl.subtestid = tst.subtestid)
  • Rows Removed by Join Filter: 9
4. 0.013 43.352 ↓ 9.0 9 1

Nested Loop (cost=8.88..7,291.66 rows=1 width=197) (actual time=16.055..43.352 rows=9 loops=1)

  • Join Filter: ((frm.assessmentlevelid = lvl.assessmentlevelid) AND (obj.subtestid = lvl.subtestid))
  • Rows Removed by Join Filter: 15
5. 0.026 43.327 ↓ 12.0 12 1

Nested Loop (cost=8.88..7,290.60 rows=1 width=189) (actual time=16.039..43.327 rows=12 loops=1)

  • Join Filter: ((x.objectivecode)::text = (obj.objectivecode)::text)
  • Rows Removed by Join Filter: 159
6. 0.009 43.265 ↓ 9.0 9 1

Nested Loop (cost=8.88..7,289.13 rows=1 width=187) (actual time=16.023..43.265 rows=9 loops=1)

  • Join Filter: (asmt.assessmentformid = frm.assessmentformid)
  • Rows Removed by Join Filter: 9
7. 0.014 43.247 ↓ 9.0 9 1

Nested Loop (cost=8.88..7,288.08 rows=1 width=175) (actual time=16.013..43.247 rows=9 loops=1)

8. 0.007 43.215 ↓ 9.0 9 1

Nested Loop (cost=8.60..7,287.60 rows=1 width=175) (actual time=16.001..43.215 rows=9 loops=1)

9. 18.722 43.181 ↓ 9.0 9 1

Hash Join (cost=8.32..7,279.29 rows=1 width=175) (actual time=15.983..43.181 rows=9 loops=1)

  • Hash Cond: ((x.documentidcode = asmt.documentidcode) AND (x.testeventidcode = asmt.testeventidcode))
10. 24.445 24.445 ↑ 1.0 180,348 1

Seq Scan on stg_subtestobjective_score x (cost=0.00..5,918.35 rows=180,348 width=159) (actual time=0.091..24.445 rows=180,348 loops=1)

  • Filter: (administrationid = 525994)
11. 0.004 0.014 ↑ 1.0 1 1

Hash (cost=8.31..8.31 rows=1 width=48) (actual time=0.014..0.014 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
12. 0.010 0.010 ↑ 1.0 1 1

Index Scan using pk_dim_assessmentparticipant on dim_assessmentparticipant asmt (cost=0.29..8.31 rows=1 width=48) (actual time=0.010..0.010 rows=1 loops=1)

  • Index Cond: (assessmentparticipantid = 23)
  • Filter: (administrationid = 525994)
13. 0.027 0.027 ↑ 1.0 1 9

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

  • Index Cond: (assessmentsessionid = asmt.assessmentsessionid)
  • Filter: (administrationid = 525994)
14. 0.018 0.018 ↑ 1.0 1 9

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

  • Index Cond: (organizationid = ses.organizationid)
  • Filter: ((administrationid = 525994) AND (orglevel = 2))
15. 0.009 0.009 ↑ 1.0 2 9

Seq Scan on dim_assessmentform frm (cost=0.00..1.02 rows=2 width=16) (actual time=0.001..0.001 rows=2 loops=9)

  • Filter: (administrationid = 525994)
16. 0.036 0.036 ↑ 1.0 19 9

Seq Scan on dim_objective obj (cost=0.00..1.24 rows=19 width=34) (actual time=0.001..0.004 rows=19 loops=9)

  • Filter: (administrationid = 525994)
17. 0.012 0.012 ↑ 1.0 2 12

Seq Scan on dim_assessmentlevel lvl (cost=0.00..1.02 rows=2 width=20) (actual time=0.001..0.001 rows=2 loops=12)

  • Filter: (administrationid = 525994)
18. 0.009 0.009 ↑ 1.0 2 9

Seq Scan on dim_subtest tst (cost=0.00..1.02 rows=2 width=12) (actual time=0.001..0.001 rows=2 loops=9)

  • Filter: (administrationid = 525994)
19. 0.018 0.018 ↑ 1.0 19 9

Seq Scan on dim_objectiveform ofrm (cost=0.00..1.24 rows=19 width=20) (actual time=0.001..0.002 rows=19 loops=9)

  • Filter: (administrationid = 525994)
20. 0.045 0.045 ↓ 9.0 9 9

Index Scan using idx_fact_subtestobjectiveresult_1 on fact_subtestobjectiveresult fact (cost=0.42..8.45 rows=1 width=68) (actual time=0.004..0.005 rows=9 loops=9)

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