explain.depesz.com

PostgreSQL's explain analyze made readable

Result: JPaP

Settings
# exclusive inclusive rows x rows loops node
1. 3,823.762 3,922.224 ↓ 1.2 381 1

Result (cost=1,272.03..2,024.13 rows=327 width=445) (actual time=99.111..3,922.224 rows=381 loops=1)

2. 1.835 98.462 ↓ 1.2 381 1

Sort (cost=1,272.03..1,272.85 rows=327 width=1,024) (actual time=97.919..98.462 rows=381 loops=1)

  • Sort Key: c.id
  • Sort Method: quicksort Memory: 524kB
3. 1.150 96.627 ↓ 1.2 381 1

Hash Join (cost=789.70..1,258.38 rows=327 width=1,024) (actual time=43.316..96.627 rows=381 loops=1)

  • Hash Cond: (pa.person_id = coach.id)
4. 0.810 95.057 ↓ 1.2 381 1

Hash Join (cost=776.60..1,239.50 rows=327 width=962) (actual time=42.852..95.057 rows=381 loops=1)

  • Hash Cond: (aa.person_id = analyst.id)
5. 3.160 93.851 ↓ 1.2 381 1

Hash Join (cost=763.51..1,225.52 rows=327 width=946) (actual time=42.426..93.851 rows=381 loops=1)

  • Hash Cond: (aa.id = c.analyst1_person_availability_id)
6. 48.557 48.557 ↓ 1.0 2,599 1

Seq Scan on analyst_availability aa (cost=0.00..449.93 rows=2,593 width=912) (actual time=0.191..48.557 rows=2,599 loops=1)

7. 0.582 42.134 ↓ 1.2 381 1

Hash (cost=759.42..759.42 rows=327 width=38) (actual time=42.134..42.134 rows=381 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 33kB
8. 5.991 41.552 ↓ 1.5 476 1

Hash Join (cost=316.57..759.42 rows=327 width=38) (actual time=5.583..41.552 rows=476 loops=1)

  • Hash Cond: (pa.id = c.coach_person_availability_id)
9. 32.320 32.320 ↓ 1.0 6,176 1

Seq Scan on person_availability pa (cost=0.00..393.75 rows=6,175 width=8) (actual time=0.011..32.320 rows=6,176 loops=1)

10. 0.654 3.241 ↓ 1.5 476 1

Hash (cost=312.48..312.48 rows=327 width=38) (actual time=3.240..3.241 rows=476 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 39kB
11. 2.587 2.587 ↓ 1.7 545 1

Seq Scan on client c (cost=0.00..312.48 rows=327 width=38) (actual time=0.009..2.587 rows=545 loops=1)

  • Filter: ((concessionendofficial >= '2019-01-01'::date) AND (concessionendofficial <= '2020-01-01'::date) AND ((id > 10700) OR (id = 9)))
  • Rows Removed by Filter: 1785
12. 0.211 0.396 ↑ 1.0 182 1

Hash (cost=10.82..10.82 rows=182 width=20) (actual time=0.396..0.396 rows=182 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 18kB
13. 0.185 0.185 ↑ 1.0 182 1

Seq Scan on person analyst (cost=0.00..10.82 rows=182 width=20) (actual time=0.005..0.185 rows=182 loops=1)

14. 0.206 0.420 ↑ 1.0 182 1

Hash (cost=10.82..10.82 rows=182 width=20) (actual time=0.419..0.420 rows=182 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 18kB
15. 0.214 0.214 ↑ 1.0 182 1

Seq Scan on person coach (cost=0.00..10.82 rows=182 width=20) (actual time=0.016..0.214 rows=182 loops=1)