explain.depesz.com

PostgreSQL's explain analyze made readable

Result: gbeE

Settings
# exclusive inclusive rows x rows loops node
1. 0.221 4.827 ↓ 297.0 297 1

Nested Loop Left Join (cost=2.67..480.35 rows=1 width=244) (actual time=0.110..4.827 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.248 4.012 ↓ 297.0 297 1

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

3. 0.216 1.388 ↓ 297.0 297 1

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

4. 0.217 0.875 ↓ 297.0 297 1

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

5. 0.097 0.361 ↓ 297.0 297 1

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

6. 0.040 0.040 ↑ 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.040 rows=14 loops=1)

  • Index Cond: ((administrationid = 593317) AND (participantid = 497318))
7. 0.224 0.224 ↓ 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.016 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) AND (orglevel = 2))
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.71 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 : 5.647 ms
Execution time : 4.953 ms