explain.depesz.com

PostgreSQL's explain analyze made readable

Result: sPaP

Settings
# exclusive inclusive rows x rows loops node
1. 685.565 8,935.248 ↑ 1.0 427,852 1

Hash Join (cost=264,322.05..436,987.61 rows=427,906 width=588) (actual time=5,411.233..8,935.248 rows=427,852 loops=1)

  • Hash Cond: (claims_1.staffing_users_id = staffing_users.id)
  • Buffers: shared hit=87855, temp read=53302 written=53072
2. 302.910 8,217.648 ↑ 1.0 427,852 1

Hash Join (cost=261,257.44..423,760.23 rows=427,906 width=574) (actual time=5,378.952..8,217.648 rows=427,852 loops=1)

  • Hash Cond: (claims_1.payroll_periods_id = payroll_periods.id)
  • Buffers: shared hit=85738, temp read=53302 written=53072
3. 318.957 7,914.652 ↑ 1.0 427,852 1

Hash Join (cost=261,251.74..417,870.82 rows=427,906 width=566) (actual time=5,378.850..7,914.652 rows=427,852 loops=1)

  • Hash Cond: (events.programs_id = programs.id)
  • Buffers: shared hit=85735, temp read=53302 written=53072
4. 1,015.942 7,595.080 ↑ 1.0 427,852 1

Hash Join (cost=261,183.35..411,918.72 rows=427,906 width=534) (actual time=5,378.222..7,595.080 rows=427,852 loops=1)

  • Hash Cond: (claims_1.events_id = events.id)
  • Buffers: shared hit=85682, temp read=53302 written=53072
5. 902.629 1,967.980 ↑ 1.0 427,852 1

Hash Left Join (cost=52,344.48..132,391.96 rows=427,906 width=463) (actual time=764.509..1,967.980 rows=427,852 loops=1)

  • Hash Cond: (claims_1.events_staffing_days_positions_id = events_staffing_days_positions.id)
  • Buffers: shared hit=36726, temp read=14418 written=14388
6. 301.676 301.676 ↑ 1.0 427,852 1

Seq Scan on claims claims_1 (cost=0.00..18,738.06 rows=427,906 width=459) (actual time=0.005..301.676 rows=427,852 loops=1)

  • Buffers: shared hit=14459
7. 388.393 763.675 ↑ 1.0 1,137,627 1

Hash (cost=33,656.99..33,656.99 rows=1,138,999 width=8) (actual time=763.675..763.675 rows=1,137,627 loops=1)

  • Buckets: 131072 Batches: 16 Memory Usage: 3811kB
  • Buffers: shared hit=22267, temp written=3636
8. 375.282 375.282 ↑ 1.0 1,137,627 1

Seq Scan on events_staffing_days_positions (cost=0.00..33,656.99 rows=1,138,999 width=8) (actual time=0.005..375.282 rows=1,137,627 loops=1)

  • Buffers: shared hit=22267
9. 586.635 4,611.158 ↓ 1.0 1,095,422 1

Hash (cost=181,344.86..181,344.86 rows=1,091,201 width=79) (actual time=4,611.158..4,611.158 rows=1,095,422 loops=1)

  • Buckets: 65536 Batches: 64 Memory Usage: 1959kB
  • Buffers: shared hit=48956, temp read=17523 written=27088
10. 1,204.882 4,024.523 ↓ 1.0 1,095,422 1

Hash Join (cost=99,711.82..181,344.86 rows=1,091,201 width=79) (actual time=1,621.853..4,024.523 rows=1,095,422 loops=1)

  • Hash Cond: (events_venues.events_id = events.id)
  • Buffers: shared hit=48956, temp read=17523 written=17449
11. 866.416 1,862.876 ↓ 1.0 1,095,797 1

Hash Join (cost=37,612.88..80,716.91 rows=1,091,201 width=24) (actual time=664.572..1,862.876 rows=1,095,797 loops=1)

  • Hash Cond: (events_venues.venues_profiles_id = venues_profiles.id)
  • Buffers: shared hit=22330, temp read=5324 written=5312
12. 332.206 332.206 ↓ 1.0 1,095,798 1

Seq Scan on events_venues (cost=0.00..18,447.01 rows=1,091,201 width=8) (actual time=0.005..332.206 rows=1,095,798 loops=1)

  • Buffers: shared hit=7535
13. 84.737 664.254 ↑ 1.0 191,961 1

Hash (cost=34,082.95..34,082.95 rows=192,235 width=20) (actual time=664.254..664.254 rows=191,961 loops=1)

  • Buckets: 65536 Batches: 4 Memory Usage: 3065kB
  • Buffers: shared hit=14795, temp read=2217 written=2951
14. 301.499 579.517 ↑ 1.0 191,961 1

Hash Join (cost=6,754.29..34,082.95 rows=192,235 width=20) (actual time=121.772..579.517 rows=191,961 loops=1)

  • Hash Cond: (venues.id = venues_profiles.venues_id)
  • Buffers: shared hit=14795, temp read=2217 written=2211
15. 156.797 156.797 ↑ 1.0 446,762 1

Seq Scan on venues (cost=0.00..17,646.68 rows=452,968 width=20) (actual time=0.004..156.797 rows=446,762 loops=1)

  • Buffers: shared hit=13117
16. 65.406 121.221 ↑ 1.0 192,100 1

Hash (cost=3,600.35..3,600.35 rows=192,235 width=8) (actual time=121.221..121.221 rows=192,100 loops=1)

  • Buckets: 131072 Batches: 4 Memory Usage: 2895kB
  • Buffers: shared hit=1678, temp written=491
17. 55.815 55.815 ↑ 1.0 192,100 1

Seq Scan on venues_profiles (cost=0.00..3,600.35 rows=192,235 width=8) (actual time=0.002..55.815 rows=192,100 loops=1)

  • Buffers: shared hit=1678
18. 465.341 956.765 ↑ 1.0 1,095,423 1

Hash (cost=37,619.75..37,619.75 rows=1,099,375 width=55) (actual time=956.765..956.765 rows=1,095,423 loops=1)

  • Buckets: 65536 Batches: 32 Memory Usage: 2674kB
  • Buffers: shared hit=26626, temp written=6743
19. 491.424 491.424 ↑ 1.0 1,095,423 1

Seq Scan on events (cost=0.00..37,619.75 rows=1,099,375 width=55) (actual time=0.008..491.424 rows=1,095,423 loops=1)

  • Buffers: shared hit=26626
20. 0.259 0.615 ↑ 1.0 683 1

Hash (cost=59.84..59.84 rows=684 width=36) (actual time=0.615..0.615 rows=683 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 56kB
  • Buffers: shared hit=53
21. 0.356 0.356 ↑ 1.0 683 1

Seq Scan on programs (cost=0.00..59.84 rows=684 width=36) (actual time=0.003..0.356 rows=683 loops=1)

  • Buffers: shared hit=53
22. 0.048 0.086 ↓ 1.0 121 1

Hash (cost=4.20..4.20 rows=120 width=12) (actual time=0.086..0.086 rows=121 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 14kB
  • Buffers: shared hit=3
23. 0.038 0.038 ↓ 1.0 121 1

Seq Scan on payroll_periods (cost=0.00..4.20 rows=120 width=12) (actual time=0.004..0.038 rows=121 loops=1)

  • Buffers: shared hit=3
24. 15.905 32.035 ↑ 1.0 42,116 1

Hash (cost=2,538.16..2,538.16 rows=42,116 width=18) (actual time=32.035..32.035 rows=42,116 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 2673kB
  • Buffers: shared hit=2117
25. 16.130 16.130 ↑ 1.0 42,116 1

Seq Scan on staffing_users (cost=0.00..2,538.16 rows=42,116 width=18) (actual time=0.004..16.130 rows=42,116 loops=1)

  • Buffers: shared hit=2117