explain.depesz.com

PostgreSQL's explain analyze made readable

Result: uvkR

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 991.521 ↓ 298.0 298 1

Nested Loop (cost=52,772.94..149,866.74 rows=1 width=20) (actual time=272.563..991.521 rows=298 loops=1)

2. 11.291 990.696 ↓ 298.0 298 1

Gather (cost=52,772.52..149,858.29 rows=1 width=20) (actual time=272.534..990.696 rows=298 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 428.772 979.405 ↓ 99.0 99 3 / 3

Parallel Hash Join (cost=51,772.52..148,858.19 rows=1 width=20) (actual time=286.513..979.405 rows=99 loops=3)

  • Hash Cond: ((x.documentidcode = asmt.documentidcode) AND (x.testeventidcode = asmt.testeventidcode))
4. 404.536 404.536 ↑ 1.2 1,374,108 3 / 3

Parallel Seq Scan on stg_item_score x (cost=0.00..84,203.41 rows=1,717,633 width=20) (actual time=0.008..404.536 rows=1,374,108 loops=3)

  • Filter: (administrationid = 593317)
5. 1.815 146.097 ↑ 2.0 1 3 / 3

Parallel Hash (cost=51,772.49..51,772.49 rows=2 width=36) (actual time=146.097..146.097 rows=1 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 40kB
6. 144.282 144.282 ↑ 2.0 1 3 / 3

Parallel Seq Scan on dim_assessmentparticipant asmt (cost=0.00..51,772.49 rows=2 width=36) (actual time=95.377..144.282 rows=1 loops=3)

  • Filter: ((administrationid = 593317) AND (participantid = 13843))
  • Rows Removed by Filter: 534393
7. 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=12) (actual time=0.003..0.003 rows=1 loops=298)

  • Index Cond: (participantid = 13843)
  • Filter: (administrationid = 593317)
Planning time : 0.266 ms
Execution time : 991.805 ms