explain.depesz.com

PostgreSQL's explain analyze made readable

Result: r3Hi

Settings
# exclusive inclusive rows x rows loops node
1. 17.175 165.757 ↓ 29.0 29 1

Gather (cost=1,000.42..52,781.51 rows=1 width=28) (actual time=6.379..165.757 rows=29 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 0.012 148.582 ↓ 10.0 10 3 / 3

Nested Loop (cost=0.42..51,781.41 rows=1 width=28) (actual time=95.482..148.582 rows=10 loops=3)

3. 148.550 148.550 ↑ 2.0 1 3 / 3

Parallel Seq Scan on dim_assessmentparticipant asmt (cost=0.00..51,772.49 rows=2 width=44) (actual time=95.472..148.550 rows=1 loops=3)

  • Filter: ((administrationid = 593317) AND (participantid = 13843))
  • Rows Removed by Filter: 534393
4. 0.020 0.020 ↓ 7.0 7 4 / 3

Index Only Scan using pk_stg_subtestobjective_score on stg_subtestobjective_score x (cost=0.42..4.45 rows=1 width=28) (actual time=0.012..0.015 rows=7 loops=4)

  • Index Cond: ((administrationid = 593317) AND (studentidcode = asmt.studentidcode) AND (documentidcode = asmt.documentidcode) AND (testeventidcode = asmt.testeventidcode))
  • Heap Fetches: 0
Planning time : 0.212 ms
Execution time : 165.792 ms