explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wDu2

Settings
# exclusive inclusive rows x rows loops node
1. 0.047 0.484 ↓ 20.0 20 1

Nested Loop Left Join (cost=2.51..35.13 rows=1 width=244) (actual time=0.096..0.484 rows=20 loops=1)

  • Join Filter: ((x.administrationid = fact_itm.administrationid) AND (fact_itm.subtestid = meta.subtestid) AND (fact_itm.assessmentlevelid = meta.assessmentlevelid) AND (fact_itm.assessmentformid = meta.assessmentformid) AND (fact_itm.objectiveid = meta.objectiveid) AND (fact_itm.assessmentitemid = meta.assessmentitemid))
  • Rows Removed by Join Filter: 190
2. 0.027 0.317 ↓ 20.0 20 1

Nested Loop (cost=1.96..26.52 rows=1 width=228) (actual time=0.070..0.317 rows=20 loops=1)

3. 0.002 0.130 ↓ 20.0 20 1

Nested Loop (cost=1.55..26.06 rows=1 width=230) (actual time=0.049..0.130 rows=20 loops=1)

4. 0.003 0.088 ↓ 20.0 20 1

Nested Loop (cost=1.26..25.34 rows=1 width=230) (actual time=0.042..0.088 rows=20 loops=1)

5. 0.008 0.045 ↓ 20.0 20 1

Nested Loop (cost=0.98..17.03 rows=1 width=230) (actual time=0.033..0.045 rows=20 loops=1)

6. 0.016 0.016 ↑ 1.0 1 1

Index Scan using pk_dim_assessmentparticipant on dim_assessmentparticipant asmt (cost=0.43..8.45 rows=1 width=40) (actual time=0.015..0.016 rows=1 loops=1)

  • Index Cond: (assessmentparticipantid = 103730)
  • Filter: (administrationid = 593218)
7. 0.021 0.021 ↓ 20.0 20 1

Index Scan using idx_stg_item_score_1 on stg_item_score x (cost=0.55..8.57 rows=1 width=222) (actual time=0.016..0.021 rows=20 loops=1)

  • Index Cond: ((administrationid = 593218) AND (documentidcode = asmt.documentidcode) AND (testeventidcode = asmt.testeventidcode))
8. 0.040 0.040 ↑ 1.0 1 20

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

  • Index Cond: (assessmentsessionid = asmt.assessmentsessionid)
  • Filter: (administrationid = 593218)
9. 0.040 0.040 ↑ 1.0 1 20

Index Scan using pk_dim_organizations on dim_organizations org (cost=0.29..0.73 rows=1 width=12) (actual time=0.002..0.002 rows=1 loops=20)

  • Index Cond: (organizationid = ses.organizationid)
  • Filter: ((administrationid = 593218) AND (orglevel = 2))
10. 0.160 0.160 ↑ 1.0 1 20

Index Scan using idx_mv_metadata_1 on mv_metadata meta (cost=0.41..0.45 rows=1 width=88) (actual time=0.008..0.008 rows=1 loops=20)

  • Index Cond: ((administrationid = 593218) AND ((subtestcode)::text = (x.subtestcode)::text) AND ((levelcode)::text = (x.levelcode)::text) AND ((formcode)::text = (x.formcode)::text) AND ((objectivecode)::text = (x.objectivecode)::text) AND ((itemidcode)::text = (x.itemidcode)::text) AND ((detailidcode)::text = (x.detailidcode)::text))
11. 0.120 0.120 ↓ 10.0 10 20

Index Scan using udx_fact_itemresult on fact_itemresult fact_itm (cost=0.55..8.58 rows=1 width=76) (actual time=0.004..0.006 rows=10 loops=20)

  • Index Cond: ((administrationid = 593218) AND (organizationid = org.organizationid) AND (participantid = asmt.participantid) AND (assessmentparticipantid = asmt.assessmentparticipantid) AND (assessmentparticipantid = 103730))