explain.depesz.com

PostgreSQL's explain analyze made readable

Result: z2q : stu

Settings
# exclusive inclusive rows x rows loops node
1. 106.500 412.344 ↓ 202.9 189,486 1

Gather (cost=3,880.14..9,179.75 rows=934 width=358) (actual time=76.290..412.344 rows=189,486 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
2. 133.148 305.844 ↓ 172.6 94,743 2

Hash Join (cost=2,880.14..8,086.35 rows=549 width=358) (actual time=74.366..305.844 rows=94,743 loops=2)

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

Hash Join (cost=702.89..4,804.51 rows=109,909 width=263) (actual time=9.295..107.797 rows=94,765 loops=2)

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

Parallel Seq Scan on ssrs_batch_record sbr (cost=0.00..2,714.09 rows=109,909 width=35) (actual time=0.003..25.425 rows=94,765 loops=2)

5. 5.186 9.209 ↑ 1.0 13,862 2

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

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

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

7. 21.432 64.899 ↑ 1.0 37,490 2

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

  • Buckets: 65536 Batches: 1 Memory Usage: 5427kB
8. 43.467 43.467 ↑ 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.005..43.467 rows=37,490 loops=2)