explain.depesz.com

PostgreSQL's explain analyze made readable

Result: MBoK

Settings
# exclusive inclusive rows x rows loops node
1. 12.157 969.276 ↓ 298.0 298 1

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

  • Workers Planned: 2
  • Workers Launched: 2
2. 406.837 957.119 ↓ 99.0 99 3 / 3

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

  • Hash Cond: ((x.documentidcode = asmt.documentidcode) AND (x.testeventidcode = asmt.testeventidcode))
3. 404.585 404.585 ↑ 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.585 rows=1,374,108 loops=3)

  • Filter: (administrationid = 593,317)
4. 1.609 145.697 ↑ 2.0 1 3 / 3

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 40kB
5. 144.088 144.088 ↑ 2.0 1 3 / 3

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

  • Filter: ((administrationid = 593,317) AND (participantid = 13,843))
  • Rows Removed by Filter: 534,393
Planning time : 0.263 ms
Execution time : 969.335 ms