explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ndf2

Settings
# exclusive inclusive rows x rows loops node
1. 0.060 1.446 ↓ 35.0 35 1

Nested Loop Left Join (cost=15.64..61.23 rows=1 width=90) (actual time=0.110..1.446 rows=35 loops=1)

  • Join Filter: ((x.administrationid = fact.administrationid) AND (fact.subtestid = obj.subtestid) AND (fact.objectiveid = obj.objectiveid))
  • Rows Removed by Join Filter: 104
2. 0.024 1.176 ↓ 35.0 35 1

Nested Loop (cost=15.08..52.62 rows=1 width=74) (actual time=0.094..1.176 rows=35 loops=1)

3. 0.036 1.082 ↓ 35.0 35 1

Nested Loop (cost=14.80..52.31 rows=1 width=74) (actual time=0.084..1.082 rows=35 loops=1)

4. 0.138 0.976 ↓ 35.0 35 1

Nested Loop (cost=14.38..43.87 rows=1 width=66) (actual time=0.075..0.976 rows=35 loops=1)

  • Join Filter: ((obj.objectivecode)::text = (x.objectivecode)::text)
  • Rows Removed by Join Filter: 441
5. 0.108 0.320 ↓ 74.0 74 1

Nested Loop (cost=13.81..35.27 rows=1 width=79) (actual time=0.050..0.320 rows=74 loops=1)

  • Join Filter: (tst.subtestid = asmt.subtestid)
  • Rows Removed by Join Filter: 1006
6. 0.027 0.027 ↑ 1.0 5 1

Index Scan using udx_dim_assessmentparticipant on dim_assessmentparticipant asmt (cost=0.43..15.53 rows=5 width=52) (actual time=0.021..0.027 rows=5 loops=1)

  • Index Cond: ((administrationid = 593317) AND (studentidcode = 3709811))
7. 0.100 0.185 ↓ 216.0 216 5

Materialize (cost=13.39..19.67 rows=1 width=43) (actual time=0.005..0.037 rows=216 loops=5)

8. 0.044 0.085 ↓ 216.0 216 1

Hash Join (cost=13.39..19.67 rows=1 width=43) (actual time=0.023..0.085 rows=216 loops=1)

  • Hash Cond: (obj.subtestid = tst.subtestid)
9. 0.032 0.032 ↑ 1.0 216 1

Seq Scan on dim_objective obj (cost=0.00..5.70 rows=216 width=31) (actual time=0.008..0.032 rows=216 loops=1)

  • Filter: (administrationid = 593317)
10. 0.005 0.009 ↓ 12.0 12 1

Hash (cost=13.38..13.38 rows=1 width=12) (actual time=0.009..0.009 rows=12 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
11. 0.004 0.004 ↓ 12.0 12 1

Seq Scan on dim_subtest tst (cost=0.00..13.38 rows=1 width=12) (actual time=0.002..0.004 rows=12 loops=1)

  • Filter: (administrationid = 593317)
12. 0.518 0.518 ↓ 6.0 6 74

Index Scan using pk_stg_subtestobjective_score on stg_subtestobjective_score x (cost=0.56..8.59 rows=1 width=61) (actual time=0.005..0.007 rows=6 loops=74)

  • Index Cond: ((administrationid = 593317) AND (studentidcode = 3709811) AND (documentidcode = asmt.documentidcode) AND (testeventidcode = asmt.testeventidcode))
13. 0.070 0.070 ↑ 1.0 1 35

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

  • Index Cond: (participantid = asmt.participantid)
  • Filter: (administrationid = 593317)
14. 0.070 0.070 ↑ 1.0 1 35

Index Scan using pk_dim_organizations on dim_organizations org (cost=0.29..0.31 rows=1 width=12) (actual time=0.002..0.002 rows=1 loops=35)

  • Index Cond: (organizationid = pat.organizationid)
  • Filter: ((administrationid = 593317) AND (orglevel = 2))
15. 0.210 0.210 ↓ 4.0 4 35

Index Scan using udx_fact_subtestobjectiveresult on fact_subtestobjectiveresult fact (cost=0.56..8.58 rows=1 width=52) (actual time=0.005..0.006 rows=4 loops=35)

  • Index Cond: ((administrationid = 593317) AND (organizationid = org.organizationid) AND (participantid = asmt.participantid) AND (assessmentparticipantid = asmt.assessmentparticipantid))
Planning time : 6.192 ms
Execution time : 1.564 ms