explain.depesz.com

PostgreSQL's explain analyze made readable

Result: NYp4

Settings
# exclusive inclusive rows x rows loops node
1. 773.751 2,065.984 ↓ 10,142.1 1,156,196 1

Hash Join (cost=61,846.16..66,882.14 rows=114 width=40) (actual time=553.689..2,065.984 rows=1,156,196 loops=1)

  • Hash Cond: ((sbr.ssrs_batch_id = ssrs.id) AND (stu.syear = (ssrs.syear)::numeric))
2. 691.726 1,281.833 ↓ 50.8 1,156,196 1

Hash Join (cost=61,108.61..65,794.36 rows=22,779 width=53) (actual time=543.263..1,281.833 rows=1,156,196 loops=1)

  • Hash Cond: ((sbr.source_id)::numeric = stu.student_id)
3. 46.865 46.865 ↑ 1.0 189,530 1

Seq Scan on ssrs_batch_record sbr (cost=0.00..3,510.30 rows=189,530 width=16) (actual time=0.003..46.865 rows=189,530 loops=1)

4. 135.225 543.242 ↓ 49.9 224,703 1

Hash (cost=61,052.28..61,052.28 rows=4,506 width=51) (actual time=543.242..543.242 rows=224,703 loops=1)

  • Buckets: 262144 (originally 8192) Batches: 1 (originally 1) Memory Usage: 21359kB
5. 7.380 408.017 ↓ 49.9 224,703 1

Gather (cost=3,177.25..61,052.28 rows=4,506 width=51) (actual time=158.471..408.017 rows=224,703 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
6. 260.300 400.637 ↓ 39.9 74,901 3

Hash Join (cost=2,177.25..59,601.68 rows=1,878 width=51) (actual time=155.479..400.637 rows=74,901 loops=3)

  • Hash Cond: (((sched.student_id)::numeric = stu.student_id) AND ((sched.syear)::numeric = stu.syear))
7. 105.265 105.265 ↑ 1.2 301,415 3

Parallel Seq Scan on schedule sched (cost=0.00..53,650.83 rows=375,483 width=40) (actual time=0.002..105.265 rows=301,415 loops=3)

8. 18.749 35.072 ↑ 1.0 37,490 3

Hash (cost=1,614.90..1,614.90 rows=37,490 width=11) (actual time=35.072..35.072 rows=37,490 loops=3)

  • Buckets: 65536 Batches: 1 Memory Usage: 2123kB
9. 16.323 16.323 ↑ 1.0 37,490 3

Seq Scan on rptcrd_es_stu stu (cost=0.00..1,614.90 rows=37,490 width=11) (actual time=0.006..16.323 rows=37,490 loops=3)

10. 5.535 10.400 ↑ 1.0 13,862 1

Hash (cost=529.62..529.62 rows=13,862 width=16) (actual time=10.400..10.400 rows=13,862 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 778kB
11. 4.865 4.865 ↑ 1.0 13,862 1

Seq Scan on ssrs_batch ssrs (cost=0.00..529.62 rows=13,862 width=16) (actual time=0.006..4.865 rows=13,862 loops=1)