explain.depesz.com

PostgreSQL's explain analyze made readable

Result: iaAZ

Settings
# exclusive inclusive rows x rows loops node
1. 709.144 8,947.402 ↓ 1.0 427,853 1

Hash Join (cost=264,322.05..435,298.27 rows=427,852 width=581) (actual time=5,372.668..8,947.402 rows=427,853 loops=1)

  • Hash Cond: (claims_1.staffing_users_id = staffing_users.id)
  • Buffers: shared hit=87856, temp read=53305 written=53075
2. 309.580 8,206.320 ↓ 1.0 427,853 1

Hash Join (cost=261,257.44..422,072.17 rows=427,852 width=567) (actual time=5,340.549..8,206.320 rows=427,853 loops=1)

  • Hash Cond: (events.programs_id = programs.id)
  • Buffers: shared hit=85739, temp read=53305 written=53075
3. 309.922 7,896.130 ↓ 1.0 427,853 1

Hash Join (cost=261,189.05..416,120.82 rows=427,852 width=535) (actual time=5,339.923..7,896.130 rows=427,853 loops=1)

  • Hash Cond: (claims_1.payroll_periods_id = payroll_periods.id)
  • Buffers: shared hit=85686, temp read=53305 written=53075
4. 1,038.017 7,586.126 ↓ 1.0 427,853 1

Hash Join (cost=261,183.35..410,232.15 rows=427,852 width=527) (actual time=5,339.829..7,586.126 rows=427,853 loops=1)

  • Hash Cond: (claims_1.events_id = events.id)
  • Buffers: shared hit=85683, temp read=53305 written=53075
5. 916.330 1,976.118 ↓ 1.0 427,853 1

Hash Left Join (cost=52,344.48..131,548.12 rows=427,852 width=456) (actual time=763.579..1,976.118 rows=427,853 loops=1)

  • Hash Cond: (claims_1.events_staffing_days_positions_id = events_staffing_days_positions.id)
  • Buffers: shared hit=36727, temp read=14420 written=14390
6. 296.898 296.898 ↓ 1.0 427,853 1

Seq Scan on claims claims_1 (cost=0.00..18,738.52 rows=427,852 width=452) (actual time=0.007..296.898 rows=427,853 loops=1)

  • Buffers: shared hit=14460
7. 388.700 762.890 ↑ 1.0 1,137,629 1

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

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

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

  • Buffers: shared hit=22267
9. 591.145 4,571.991 ↓ 1.0 1,095,424 1

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

  • Buckets: 65536 Batches: 64 Memory Usage: 1959kB
  • Buffers: shared hit=48956, temp read=17523 written=27089
10. 1,209.941 3,980.846 ↓ 1.0 1,095,424 1

Hash Join (cost=99,711.82..181,344.86 rows=1,091,201 width=79) (actual time=1,597.712..3,980.846 rows=1,095,424 loops=1)

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

Hash Join (cost=37,612.88..80,716.91 rows=1,091,201 width=24) (actual time=653.745..1,827.438 rows=1,095,799 loops=1)

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

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

  • Buffers: shared hit=7535
13. 84.202 653.440 ↑ 1.0 191,961 1

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

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

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

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

Seq Scan on venues (cost=0.00..17,646.68 rows=452,968 width=20) (actual time=0.005..155.282 rows=446,769 loops=1)

  • Buffers: shared hit=13117
16. 65.788 121.781 ↑ 1.0 192,100 1

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

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

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

  • Buffers: shared hit=1678
18. 456.310 943.467 ↑ 1.0 1,095,425 1

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

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

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

  • Buffers: shared hit=26626
20. 0.039 0.082 ↓ 1.0 121 1

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

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

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

  • Buffers: shared hit=3
22. 0.261 0.610 ↑ 1.0 683 1

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

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

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

  • Buffers: shared hit=53
24. 15.638 31.938 ↑ 1.0 42,116 1

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

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

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

  • Buffers: shared hit=2117