explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3NaO

Settings
# exclusive inclusive rows x rows loops node
1. 0.338 2.072 ↓ 74.0 74 1

Nested Loop (cost=3.35..134.27 rows=1 width=662) (actual time=0.169..2.072 rows=74 loops=1)

2. 0.042 1.660 ↓ 74.0 74 1

Nested Loop (cost=3.08..133.90 rows=1 width=513) (actual time=0.141..1.660 rows=74 loops=1)

  • Join Filter: ((((lvl.levelcode)::text = 'K'::text) AND ((stu.grade)::text <> 'K'::text) AND ((obj.objectivecode)::text ~~ '%GR1%'::text)) OR (((lvl.levelcode)::text = 'K'::text) AND ((stu.grade)::text = 'K'::text) AND ((obj.objectivecode)::text !~~ '%GR1%'::text)) OR ((lvl.levelcode)::text <> 'K'::text))
3. 0.075 1.470 ↓ 74.0 74 1

Nested Loop (cost=2.81..133.59 rows=1 width=517) (actual time=0.129..1.470 rows=74 loops=1)

4. 0.098 1.247 ↓ 74.0 74 1

Nested Loop (cost=2.54..133.29 rows=1 width=489) (actual time=0.116..1.247 rows=74 loops=1)

5. 0.033 1.075 ↓ 74.0 74 1

Nested Loop (cost=2.27..133.00 rows=1 width=492) (actual time=0.104..1.075 rows=74 loops=1)

  • Join Filter: (x.subtestid = tst.subtestid)
  • Rows Removed by Join Filter: 88
6. 0.027 0.968 ↓ 74.0 74 1

Nested Loop (cost=2.27..131.90 rows=1 width=492) (actual time=0.099..0.968 rows=74 loops=1)

7. 0.029 0.793 ↓ 74.0 74 1

Nested Loop (cost=1.98..123.59 rows=1 width=500) (actual time=0.084..0.793 rows=74 loops=1)

8. 0.033 0.616 ↓ 74.0 74 1

Nested Loop (cost=1.69..122.89 rows=1 width=500) (actual time=0.071..0.616 rows=74 loops=1)

9. 0.098 0.435 ↓ 74.0 74 1

Nested Loop (cost=1.40..122.58 rows=1 width=492) (actual time=0.057..0.435 rows=74 loops=1)

10. 0.028 0.189 ↓ 1.9 74 1

Nested Loop (cost=0.98..103.03 rows=40 width=484) (actual time=0.040..0.189 rows=74 loops=1)

11. 0.014 0.014 ↑ 1.0 1 1

Index Scan using udx_dim_participant on dim_participant stu (cost=0.42..8.44 rows=1 width=22) (actual time=0.014..0.014 rows=1 loops=1)

  • Index Cond: ((administrationid = 592030) AND (studentidcode = 104657))
12. 0.147 0.147 ↓ 1.5 74 1

Index Scan using idx_fact_subtestobjectiveresult_1 on fact_subtestobjectiveresult x (cost=0.56..94.10 rows=49 width=482) (actual time=0.025..0.147 rows=74 loops=1)

  • Index Cond: ((administrationid = 592030) AND (participantid = stu.participantid))
13. 0.148 0.148 ↑ 1.0 1 74

Index Scan using pk_dim_assessmentparticipant on dim_assessmentparticipant asmt (cost=0.42..0.49 rows=1 width=28) (actual time=0.002..0.002 rows=1 loops=74)

  • Index Cond: (assessmentparticipantid = x.assessmentparticipantid)
  • Filter: ((administrationid = 592030) AND ((is_reportable)::text = 'YES'::text) AND ((reportphase)::text = 'IR'::text) AND ((testingstatus)::text = 'ReportingReady'::text) AND (COALESCE(NULLIF((nottestedcode)::text, ''::text), '*'::text) = ANY ('{*,DN}'::text[])))
14. 0.148 0.148 ↑ 1.0 1 74

Index Scan using pk_dim_organizations on dim_organizations sch (cost=0.29..0.31 rows=1 width=28) (actual time=0.002..0.002 rows=1 loops=74)

  • Index Cond: (organizationid = x.organizationid)
  • Filter: ((administrationid = 592030) AND (orglevel = 2))
15. 0.148 0.148 ↑ 1.0 1 74

Index Scan using pk_dim_organizations on dim_organizations dst (cost=0.29..0.70 rows=1 width=20) (actual time=0.002..0.002 rows=1 loops=74)

  • Index Cond: (organizationid = sch.parent_organizationid)
  • Filter: ((administrationid = 592030) AND (orglevel = 1))
16. 0.148 0.148 ↑ 1.0 1 74

Index Scan using pk_dim_assessmentsession on dim_assessmentsession ses (cost=0.29..8.31 rows=1 width=12) (actual time=0.002..0.002 rows=1 loops=74)

  • Index Cond: (assessmentsessionid = asmt.assessmentsessionid)
  • Filter: (administrationid = 592030)
17. 0.074 0.074 ↑ 2.0 2 74

Seq Scan on dim_subtest tst (cost=0.00..1.05 rows=4 width=20) (actual time=0.001..0.001 rows=2 loops=74)

  • Filter: (administrationid = 592030)
18. 0.074 0.074 ↑ 1.0 1 74

Index Scan using pk_dim_assessmentlevel on dim_assessmentlevel lvl (cost=0.27..0.29 rows=1 width=17) (actual time=0.001..0.001 rows=1 loops=74)

  • Index Cond: (assessmentlevelid = x.assessmentlevelid)
  • Filter: (administrationid = 592030)
19. 0.148 0.148 ↑ 1.0 1 74

Index Scan using pk_dim_objectiveform on dim_objectiveform obj_frm (cost=0.28..0.30 rows=1 width=32) (actual time=0.002..0.002 rows=1 loops=74)

  • Index Cond: ((administrationid = 592030) AND (assessmentformid = x.assessmentformid) AND (objectiveid = x.objectiveid))
20. 0.148 0.148 ↑ 1.0 1 74

Index Scan using pk_dim_objective on dim_objective obj (cost=0.27..0.29 rows=1 width=26) (actual time=0.002..0.002 rows=1 loops=74)

  • Index Cond: (objectiveid = x.objectiveid)
  • Filter: (administrationid = 592030)
21. 0.074 0.074 ↑ 1.0 1 74

Index Scan using pk_dim_assessmentform on dim_assessmentform frm (cost=0.27..0.29 rows=1 width=21) (actual time=0.001..0.001 rows=1 loops=74)

  • Index Cond: (assessmentformid = x.assessmentformid)
  • Filter: (administrationid = 592030)
Planning time : 82.250 ms
Execution time : 2.320 ms