explain.depesz.com

PostgreSQL's explain analyze made readable

Result: rKmQ

Settings
# exclusive inclusive rows x rows loops node
1. 640.308 6,557.552 ↑ 1.0 423,444 1

Hash Join (cost=86,046.02..402,064.34 rows=423,444 width=742) (actual time=1,131.647..6,557.552 rows=423,444 loops=1)

  • Hash Cond: (claims_1.staffing_users_id = staffing_users.id)
2. 218.732 5,891.339 ↑ 1.0 423,444 1

Hash Join (cost=83,204.93..389,166.46 rows=423,444 width=582) (actual time=1,105.630..5,891.339 rows=423,444 loops=1)

  • Hash Cond: (claims_1.payroll_periods_id = payroll_periods.id)
3. 214.863 5,672.549 ↑ 1.0 423,444 1

Hash Join (cost=83,199.23..383,338.40 rows=423,444 width=574) (actual time=1,105.559..5,672.549 rows=423,444 loops=1)

  • Hash Cond: (events.programs_id = programs.id)
4. 598.573 5,457.320 ↑ 1.0 423,444 1

Hash Join (cost=83,158.09..377,474.91 rows=423,444 width=542) (actual time=1,105.185..5,457.320 rows=423,444 loops=1)

  • Hash Cond: (events_venues.venues_profiles_id = venues_profiles.id)
5. 911.548 4,342.833 ↑ 1.0 423,444 1

Hash Left Join (cost=49,958.22..280,403.68 rows=423,444 width=526) (actual time=588.386..4,342.833 rows=423,444 loops=1)

  • Hash Cond: (claims_1.events_staffing_days_positions_id = events_staffing_days_positions.id)
6. 515.372 2,843.986 ↑ 1.0 423,444 1

Merge Join (cost=185.33..163,447.79 rows=423,444 width=522) (actual time=0.211..2,843.986 rows=423,444 loops=1)

  • Merge Cond: (claims_1.events_id = events_venues.events_id)
7. 487.094 1,715.981 ↑ 1.0 423,444 1

Merge Join (cost=72.85..117,237.94 rows=423,444 width=522) (actual time=0.132..1,715.981 rows=423,444 loops=1)

  • Merge Cond: (claims_1.events_id = events.id)
8. 447.983 447.983 ↑ 1.0 423,444 1

Index Scan using claims_events_id_idx on claims claims_1 (cost=0.42..43,146.11 rows=423,444 width=466) (actual time=0.015..447.983 rows=423,444 loops=1)

9. 780.904 780.904 ↓ 1.2 1,230,104 1

Index Scan using events_pkey on events (cost=0.43..66,221.03 rows=1,058,835 width=56) (actual time=0.008..780.904 rows=1,230,104 loops=1)

10. 612.633 612.633 ↓ 1.2 1,230,479 1

Index Scan using events_venues_events_id on events_venues (cost=0.43..38,307.36 rows=1,059,210 width=8) (actual time=0.014..612.633 rows=1,230,479 loops=1)

11. 260.406 587.299 ↑ 1.0 1,100,884 1

Hash (cost=31,710.84..31,710.84 rows=1,100,884 width=8) (actual time=587.299..587.299 rows=1,100,884 loops=1)

  • Buckets: 131072 Batches: 16 Memory Usage: 3723kB
12. 326.893 326.893 ↑ 1.0 1,100,884 1

Seq Scan on events_staffing_days_positions (cost=0.00..31,710.84 rows=1,100,884 width=8) (actual time=0.010..326.893 rows=1,100,884 loops=1)

13. 46.156 515.914 ↑ 1.0 167,589 1

Hash (cost=30,120.27..30,120.27 rows=167,728 width=20) (actual time=515.914..515.914 rows=167,589 loops=1)

  • Buckets: 65536 Batches: 4 Memory Usage: 2735kB
14. 250.929 469.758 ↑ 1.0 167,589 1

Hash Join (cost=5,875.88..30,120.27 rows=167,728 width=20) (actual time=75.268..469.758 rows=167,589 loops=1)

  • Hash Cond: (venues.id = venues_profiles.venues_id)
15. 143.834 143.834 ↑ 1.0 415,935 1

Seq Scan on venues (cost=0.00..15,475.35 rows=415,935 width=20) (actual time=0.018..143.834 rows=415,935 loops=1)

16. 40.899 74.995 ↑ 1.0 167,728 1

Hash (cost=3,123.28..3,123.28 rows=167,728 width=8) (actual time=74.995..74.995 rows=167,728 loops=1)

  • Buckets: 131072 Batches: 4 Memory Usage: 2655kB
17. 34.096 34.096 ↑ 1.0 167,728 1

Seq Scan on venues_profiles (cost=0.00..3,123.28 rows=167,728 width=8) (actual time=0.006..34.096 rows=167,728 loops=1)

18. 0.149 0.366 ↑ 1.0 673 1

Hash (cost=32.73..32.73 rows=673 width=36) (actual time=0.366..0.366 rows=673 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 56kB
19. 0.217 0.217 ↑ 1.0 673 1

Seq Scan on programs (cost=0.00..32.73 rows=673 width=36) (actual time=0.007..0.217 rows=673 loops=1)

20. 0.028 0.058 ↑ 1.0 120 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 14kB
21. 0.030 0.030 ↑ 1.0 120 1

Seq Scan on payroll_periods (cost=0.00..4.20 rows=120 width=12) (actual time=0.007..0.030 rows=120 loops=1)

22. 11.711 25.905 ↑ 1.0 42,004 1

Hash (cost=2,316.04..2,316.04 rows=42,004 width=18) (actual time=25.905..25.905 rows=42,004 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 2667kB
23. 14.194 14.194 ↑ 1.0 42,004 1

Seq Scan on staffing_users (cost=0.00..2,316.04 rows=42,004 width=18) (actual time=0.007..14.194 rows=42,004 loops=1)