explain.depesz.com

PostgreSQL's explain analyze made readable

Result: kAet

Settings
# exclusive inclusive rows x rows loops node
1. 0.209 4.814 ↓ 297.0 297 1

Nested Loop Left Join (cost=2.67..480.34 rows=1 width=244) (actual time=0.110..4.814 rows=297 loops=1)

  • Join Filter: ((x.administrationid = fact_itm.administrationid) AND (fact_itm.participantid = asmt.participantid) AND (fact_itm.assessmentparticipantid = asmt.assessmentparticipantid) 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))
2. 0.226 4.011 ↓ 297.0 297 1

Nested Loop (cost=1.97..471.61 rows=1 width=228) (actual time=0.093..4.011 rows=297 loops=1)

3. 0.219 1.409 ↓ 297.0 297 1

Nested Loop (cost=1.55..471.13 rows=1 width=236) (actual time=0.073..1.409 rows=297 loops=1)

4. 0.233 0.893 ↓ 297.0 297 1

Nested Loop (cost=1.27..470.80 rows=1 width=236) (actual time=0.067..0.893 rows=297 loops=1)

5. 0.086 0.363 ↓ 297.0 297 1

Nested Loop (cost=0.98..463.31 rows=1 width=236) (actual time=0.053..0.363 rows=297 loops=1)

6. 0.039 0.039 ↑ 3.1 14 1

Index Scan using idx_dim_assessmentparticipant_1 on dim_assessmentparticipant asmt (cost=0.43..85.46 rows=44 width=52) (actual time=0.023..0.039 rows=14 loops=1)

  • Index Cond: ((administrationid = 593317) AND (participantid = 497318))
7. 0.238 0.238 ↓ 21.0 21 14

Index Scan using idx_stg_item_score_1 on stg_item_score x (cost=0.55..8.58 rows=1 width=236) (actual time=0.006..0.017 rows=21 loops=14)

  • Index Cond: ((administrationid = 593317) AND (documentidcode = asmt.documentidcode) AND (testeventidcode = asmt.testeventidcode))
  • Filter: (asmt.studentidcode = studentidcode)
8. 0.297 0.297 ↑ 1.0 1 297

Index Scan using pk_dim_assessmentsession on dim_assessmentsession ses (cost=0.29..7.49 rows=1 width=20) (actual time=0.001..0.001 rows=1 loops=297)

  • Index Cond: (assessmentsessionid = asmt.assessmentsessionid)
  • Filter: (administrationid = 593317)
9. 0.297 0.297 ↑ 1.0 1 297

Index Scan using pk_dim_organizations on dim_organizations org (cost=0.28..0.32 rows=1 width=12) (actual time=0.001..0.001 rows=1 loops=297)

  • Index Cond: (organizationid = ses.organizationid)
  • Filter: (administrationid = 593317)
10. 2.376 2.376 ↑ 1.0 1 297

Index Scan using idx_mv_metadata_1 on mv_metadata meta (cost=0.42..0.47 rows=1 width=85) (actual time=0.008..0.008 rows=1 loops=297)

  • Index Cond: ((administrationid = 593317) 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.594 0.594 ↓ 0.0 0 297

Index Scan using udx_fact_itemresult on fact_itemresult fact_itm (cost=0.69..8.70 rows=1 width=76) (actual time=0.002..0.002 rows=0 loops=297)

  • Index Cond: ((administrationid = 593317) AND (organizationid = org.organizationid) AND (participantid = 497318))
Planning time : 6.233 ms
Execution time : 4.941 ms