explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Fdp4

Settings
# exclusive inclusive rows x rows loops node
1. 3.300 269.527 ↓ 171.0 171 1

Gather (cost=1,186.48..58,592.25 rows=1 width=40) (actual time=117.782..269.527 rows=171 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 164.208 266.227 ↓ 57.0 57 3

Hash Join (cost=186.48..57,592.15 rows=1 width=40) (actual time=128.655..266.227 rows=57 loops=3)

  • Hash Cond: (((sched.student_id)::numeric = stu.student_id) AND ((sched.syear)::numeric = stu.syear))
3. 101.368 101.368 ↑ 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.003..101.368 rows=301,415 loops=3)

4. 0.056 0.651 ↓ 79.0 79 3

Hash (cost=186.46..186.46 rows=1 width=27) (actual time=0.651..0.651 rows=79 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 13kB
5. 0.458 0.595 ↓ 79.0 79 3

Nested Loop (cost=1.00..186.46 rows=1 width=27) (actual time=0.053..0.595 rows=79 loops=3)

  • Join Filter: ((ssrs.syear)::numeric = stu.syear)
6. 0.057 0.133 ↓ 4.2 79 3

Nested Loop (cost=0.71..32.29 rows=19 width=16) (actual time=0.036..0.133 rows=79 loops=3)

7. 0.025 0.025 ↑ 1.0 1 3

Index Scan using indx_ssrs_batch_id on ssrs_batch ssrs (cost=0.29..8.30 rows=1 width=16) (actual time=0.025..0.025 rows=1 loops=3)

  • Index Cond: (id = 17885)
8. 0.051 0.051 ↓ 4.2 79 3

Index Scan using ssrs_batch_record_ssrs_batch_id on ssrs_batch_record sbr (cost=0.42..23.79 rows=19 width=16) (actual time=0.008..0.051 rows=79 loops=3)

  • Index Cond: (ssrs_batch_id = 17885)
9. 0.004 0.004 ↑ 1.0 1 237

Index Scan using rptcrd_stu_student_id on rptcrd_es_stu stu (cost=0.29..8.10 rows=1 width=11) (actual time=0.003..0.004 rows=1 loops=237)

  • Index Cond: (student_id = (sbr.source_id)::numeric)