explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vcR8

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Gather (cost=241,043.36..249,336.36 rows=1 width=244) (actual rows= loops=)

  • Workers Planned: 2
2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=240,043.36..248,336.26 rows=1 width=244) (actual rows= loops=)

  • Join Filter: (org.organizationid = ses.organizationid)
3. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=240,043.08..248,335.94 rows=1 width=244) (actual rows= loops=)

  • Join Filter: ((x.administrationid = fact_itm.administrationid) AND (fact_itm.organizationid = org.organizationid) 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))
4. 0.000 0.000 ↓ 0.0

Nested Loop (cost=240,042.38..248,332.71 rows=1 width=236) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Nested Loop (cost=240,042.38..248,110.20 rows=1 width=228) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Merge Join (cost=240,041.83..248,107.67 rows=2 width=228) (actual rows= loops=)

  • Merge Cond: (((x.objectivecode)::text = (meta.objectivecode)::text) AND ((x.subtestcode)::text = (meta.subtestcode)::text) AND ((x.levelcode)::text = (meta.levelcode)::text) AND ((x.formcode)::text = (meta.formcode)::text) AND ((x.itemidcode)::text = (meta.itemidcode)::text) AND ((x.detailidcode)::text = (meta.detailidcode)::text))
7. 0.000 0.000 ↓ 0.0

Sort (cost=228,820.43..229,916.92 rows=438,597 width=236) (actual rows= loops=)

  • Sort Key: x.objectivecode, x.subtestcode, x.levelcode, x.formcode, x.itemidcode, x.detailidcode
8. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on stg_item_score x (cost=0.00..88,773.33 rows=438,597 width=236) (actual rows= loops=)

  • Filter: (administrationid = 593317)
9. 0.000 0.000 ↓ 0.0

Materialize (cost=11,176.88..11,393.87 rows=43,399 width=85) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Sort (cost=11,176.88..11,285.37 rows=43,399 width=85) (actual rows= loops=)

  • Sort Key: meta.objectivecode, meta.subtestcode, meta.levelcode, meta.formcode, meta.itemidcode, meta.detailidcode
11. 0.000 0.000 ↓ 0.0

Seq Scan on mv_metadata meta (cost=0.00..5,754.99 rows=43,399 width=85) (actual rows= loops=)

  • Filter: (administrationid = 593317)
12. 0.000 0.000 ↓ 0.0

Index Scan using udx_dim_assessmentparticipant on dim_assessmentparticipant asmt (cost=0.56..1.26 rows=1 width=52) (actual rows= loops=)

  • Index Cond: ((administrationid = 593317) AND (studentidcode = x.studentidcode) AND (documentidcode = x.documentidcode) AND (testeventidcode = x.testeventidcode))
13. 0.000 0.000 ↓ 0.0

Seq Scan on dim_organizations org (cost=0.00..175.25 rows=4,726 width=12) (actual rows= loops=)

  • Filter: (administrationid = 593317)
14. 0.000 0.000 ↓ 0.0

Index Scan using idx_fact_itemresult_1 on fact_itemresult fact_itm (cost=0.69..3.20 rows=1 width=76) (actual rows= loops=)

  • Index Cond: ((administrationid = 593317) AND (participantid = asmt.participantid) AND (assessmentparticipantid = asmt.assessmentparticipantid))
15. 0.000 0.000 ↓ 0.0

Index Scan using pk_dim_assessmentsession on dim_assessmentsession ses (cost=0.29..0.31 rows=1 width=20) (actual rows= loops=)

  • Index Cond: (assessmentsessionid = asmt.assessmentsessionid)
  • Filter: (administrationid = 593317)