explain.depesz.com

PostgreSQL's explain analyze made readable

Result: k8sl : source_id

Settings
# exclusive inclusive rows x rows loops node
1. 107.293 391.574 ↓ 199.9 189,486 1

Gather (cost=3,880.14..9,232.74 rows=948 width=358) (actual time=44.420..391.574 rows=189,486 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
2. 136.521 284.281 ↓ 169.8 94,743 2

Hash Join (cost=2,880.14..8,137.94 rows=558 width=358) (actual time=44.345..284.281 rows=94,743 loops=2)

  • Hash Cond: (((sbr.source_id)::numeric = stu.student_id) AND ((ssrs.syear)::numeric = stu.syear))
3. 76.788 114.080 ↑ 1.2 94,765 2

Hash Join (cost=702.89..4,840.24 rows=111,488 width=263) (actual time=10.496..114.080 rows=94,765 loops=2)

  • Hash Cond: (sbr.ssrs_batch_id = ssrs.id)
4. 26.881 26.881 ↑ 1.2 94,765 2

Parallel Seq Scan on ssrs_batch_record sbr (cost=0.00..2,729.88 rows=111,488 width=35) (actual time=0.003..26.881 rows=94,765 loops=2)

5. 5.836 10.411 ↑ 1.0 13,862 2

Hash (cost=529.62..529.62 rows=13,862 width=228) (actual time=10.411..10.411 rows=13,862 loops=2)

  • Buckets: 16384 Batches: 1 Memory Usage: 2523kB
6. 4.575 4.575 ↑ 1.0 13,862 2

Seq Scan on ssrs_batch ssrs (cost=0.00..529.62 rows=13,862 width=228) (actual time=0.006..4.575 rows=13,862 loops=2)

7. 21.871 33.680 ↑ 1.0 37,490 2

Hash (cost=1,614.90..1,614.90 rows=37,490 width=95) (actual time=33.680..33.680 rows=37,490 loops=2)

  • Buckets: 65536 Batches: 1 Memory Usage: 5427kB
8. 11.809 11.809 ↑ 1.0 37,490 2

Seq Scan on rptcrd_es_stu stu (cost=0.00..1,614.90 rows=37,490 width=95) (actual time=0.006..11.809 rows=37,490 loops=2)