explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5PmL

Settings
# exclusive inclusive rows x rows loops node
1. 0.429 93.558 ↓ 21.0 21 1

Hash Join (cost=1,046.47..1,108.37 rows=1 width=245) (actual time=91.326..93.558 rows=21 loops=1)

  • Hash Cond: ((asmt.assessmentformid = frm.assessmentformid) AND (lvl.assessmentlevelid = frm.assessmentlevelid))
2. 0.717 92.657 ↓ 21.0 3,192 1

Merge Join (cost=1,017.32..1,078.43 rows=152 width=241) (actual time=4.460..92.657 rows=3,192 loops=1)

  • Merge Cond: (lvl.subtestid = tst.subtestid)
3. 1.068 91.899 ↓ 21.0 3,192 1

Nested Loop (cost=1,016.30..10,302.84 rows=152 width=249) (actual time=4.419..91.899 rows=3,192 loops=1)

4. 0.087 0.087 ↑ 1.0 152 1

Index Scan using udx_dim_assessmentlevel on dim_assessmentlevel lvl (cost=0.14..29.12 rows=152 width=20) (actual time=0.020..0.087 rows=152 loops=1)

  • Index Cond: (administrationid = 593218)
5. 0.257 90.744 ↓ 21.0 21 152

Materialize (cost=1,016.16..10,271.82 rows=1 width=233) (actual time=0.029..0.597 rows=21 loops=152)

6. 0.015 90.487 ↓ 21.0 21 1

Nested Loop (cost=1,016.16..10,271.82 rows=1 width=233) (actual time=4.393..90.487 rows=21 loops=1)

7. 0.000 90.409 ↓ 21.0 21 1

Nested Loop (cost=1,015.88..10,271.32 rows=1 width=233) (actual time=4.384..90.409 rows=21 loops=1)

8. 11.870 90.380 ↓ 21.0 21 1

Gather (cost=1,015.59..10,263.02 rows=1 width=233) (actual time=4.369..90.380 rows=21 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
9. 36.186 78.510 ↓ 7.0 7 3

Hash Join (cost=15.59..9,262.92 rows=1 width=233) (actual time=50.712..78.510 rows=7 loops=3)

  • Hash Cond: ((x.documentidcode = asmt.documentidcode) AND (x.testeventidcode = asmt.testeventidcode))
10. 42.290 42.290 ↑ 1.2 111,695 3

Parallel Seq Scan on stg_subtestobjective_score x (cost=0.00..8,517.85 rows=138,948 width=217) (actual time=0.186..42.290 rows=111,695 loops=3)

  • Filter: (administrationid = 593218)
11. 0.006 0.034 ↑ 1.0 5 3

Hash (cost=15.52..15.52 rows=5 width=48) (actual time=0.034..0.034 rows=5 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
12. 0.028 0.028 ↑ 1.0 5 3

Index Scan using idx_dim_assessmentparticipant_2 on dim_assessmentparticipant asmt (cost=0.42..15.52 rows=5 width=48) (actual time=0.020..0.028 rows=5 loops=3)

  • Index Cond: ((administrationid = 593218) AND (participantid = 13))
13. 0.063 0.063 ↑ 1.0 1 21

Index Scan using pk_dim_assessmentsession on dim_assessmentsession ses (cost=0.28..8.30 rows=1 width=20) (actual time=0.003..0.003 rows=1 loops=21)

  • Index Cond: (assessmentsessionid = asmt.assessmentsessionid)
  • Filter: (administrationid = 593218)
14. 0.063 0.063 ↑ 1.0 1 21

Index Scan using pk_dim_organizations on dim_organizations org (cost=0.29..0.50 rows=1 width=12) (actual time=0.003..0.003 rows=1 loops=21)

  • Index Cond: (organizationid = ses.organizationid)
  • Filter: ((administrationid = 593218) AND (orglevel = 2))
15. 0.027 0.041 ↓ 17.0 17 1

Sort (cost=1.01..1.01 rows=1 width=12) (actual time=0.037..0.041 rows=17 loops=1)

  • Sort Key: tst.subtestid
  • Sort Method: quicksort Memory: 25kB
16. 0.014 0.014 ↓ 17.0 17 1

Seq Scan on dim_subtest tst (cost=0.00..1.00 rows=1 width=12) (actual time=0.009..0.014 rows=17 loops=1)

  • Filter: (administrationid = 593218)
17. 0.184 0.472 ↑ 1.0 587 1

Hash (cost=20.34..20.34 rows=587 width=16) (actual time=0.472..0.472 rows=587 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 38kB
18. 0.288 0.288 ↑ 1.0 587 1

Seq Scan on dim_assessmentform frm (cost=0.00..20.34 rows=587 width=16) (actual time=0.014..0.288 rows=587 loops=1)

  • Filter: (administrationid = 593218)