explain.depesz.com

PostgreSQL's explain analyze made readable

Result: JkTZ

Settings
# exclusive inclusive rows x rows loops node
1. 0.485 161.775 ↓ 298.0 298 1

Nested Loop Left Join (cost=1,002.09..52,820.69 rows=1 width=97) (actual time=155.975..161.775 rows=298 loops=1)

  • Join Filter: ((fact_itm.participantid = asmt.participantid) AND (fact_itm.assessmentparticipantid = asmt.assessmentparticipantid) AND (fact_itm.subtestid = tst.subtestid) AND (fact_itm.objectiveid = obj.objectiveid))
  • Rows Removed by Join Filter: 52
2. 0.380 158.906 ↓ 298.0 298 1

Nested Loop (cost=1,001.67..52,817.51 rows=1 width=81) (actual time=155.944..158.906 rows=298 loops=1)

  • Join Filter: (tst.subtestid = obj.subtestid)
  • Rows Removed by Join Filter: 92
3. 0.502 156.440 ↓ 298.0 298 1

Nested Loop (cost=1,001.40..52,815.06 rows=1 width=90) (actual time=155.906..156.440 rows=298 loops=1)

  • Join Filter: (asmt.subtestid = tst.subtestid)
  • Rows Removed by Join Filter: 3278
4. 0.034 0.034 ↑ 1.0 12 1

Index Scan using pk_dim_subtest on dim_subtest tst (cost=0.14..12.35 rows=12 width=12) (actual time=0.023..0.034 rows=12 loops=1)

  • Filter: (administrationid = 593317)
5. 0.339 155.904 ↓ 298.0 298 12

Materialize (cost=1,001.26..52,802.53 rows=1 width=82) (actual time=0.358..12.992 rows=298 loops=12)

6. 0.358 155.565 ↓ 298.0 298 1

Nested Loop (cost=1,001.26..52,802.53 rows=1 width=82) (actual time=4.292..155.565 rows=298 loops=1)

7. 0.142 154.611 ↓ 298.0 298 1

Nested Loop (cost=1,000.98..52,798.22 rows=1 width=82) (actual time=4.271..154.611 rows=298 loops=1)

8. 9.237 153.575 ↓ 298.0 298 1

Gather (cost=1,000.55..52,789.77 rows=1 width=74) (actual time=4.249..153.575 rows=298 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
9. 0.041 144.338 ↓ 99.0 99 3 / 3

Nested Loop (cost=0.56..51,789.67 rows=1 width=74) (actual time=95.529..144.338 rows=99 loops=3)

10. 144.170 144.170 ↑ 2.0 1 3 / 3

Parallel Seq Scan on dim_assessmentparticipant asmt (cost=0.00..51,772.49 rows=2 width=52) (actual time=95.517..144.170 rows=1 loops=3)

  • Filter: ((administrationid = 593317) AND (participantid = 13843))
  • Rows Removed by Filter: 534393
11. 0.127 0.127 ↓ 74.0 74 4 / 3

Index Scan using pk_stg_item_score on stg_item_score x (cost=0.56..8.58 rows=1 width=74) (actual time=0.024..0.095 rows=74 loops=4)

  • Index Cond: ((administrationid = 593317) AND (studentidcode = asmt.studentidcode) AND (documentidcode = asmt.documentidcode) AND (testeventidcode = asmt.testeventidcode))
12. 0.894 0.894 ↑ 1.0 1 298

Index Scan using pk_dim_participant on dim_participant pat (cost=0.42..8.44 rows=1 width=20) (actual time=0.003..0.003 rows=1 loops=298)

  • Index Cond: (participantid = 13843)
  • Filter: (administrationid = 593317)
13. 0.596 0.596 ↑ 1.0 1 298

Index Only Scan using idx_dim_organizations_1 on dim_organizations org (cost=0.29..4.31 rows=1 width=12) (actual time=0.002..0.002 rows=1 loops=298)

  • Index Cond: ((administrationid = 593317) AND (orglevel = 2) AND (organizationid = pat.organizationid))
  • Heap Fetches: 0
14. 2.086 2.086 ↑ 1.0 1 298

Index Scan using udx_dim_objective on dim_objective obj (cost=0.27..2.44 rows=1 width=31) (actual time=0.007..0.007 rows=1 loops=298)

  • Index Cond: ((administrationid = 593317) AND ((objectivecode)::text = (x.objectivecode)::text))
15. 2.384 2.384 ↑ 1.0 1 298

Index Scan using udx_fact_itemresult on fact_itemresult fact_itm (cost=0.42..3.15 rows=1 width=64) (actual time=0.008..0.008 rows=1 loops=298)

  • Index Cond: ((x.administrationid = administrationid) AND (administrationid = 593317) AND (organizationid = org.organizationid) AND (participantid = 13843) AND ((itemidcode)::text = (x.itemidcode)::text) AND ((detailidcode)::text = (x.detailidcode)::text))
Planning time : 6.221 ms
Execution time : 161.962 ms