explain.depesz.com

PostgreSQL's explain analyze made readable

Result: g0Y

Settings
# exclusive inclusive rows x rows loops node
1. 1,065.071 9,716.896 ↑ 1.0 423,444 1

Hash Join (cost=81,834.57..468,642.25 rows=423,444 width=742) (actual time=937.894..9,716.896 rows=423,444 loops=1)

  • Hash Cond: (venues_profiles.venues_id = venues.id)
2. 238.117 8,415.883 ↑ 1.0 423,444 1

Hash Join (cost=58,722.03..370,178.92 rows=423,444 width=584) (actual time=699.292..8,415.883 rows=423,444 loops=1)

  • Hash Cond: (events.programs_id = programs.id)
3. 279.337 8,177.378 ↑ 1.0 423,444 1

Hash Join (cost=58,680.89..364,315.42 rows=423,444 width=552) (actual time=698.892..8,177.378 rows=423,444 loops=1)

  • Hash Cond: (claims_1.staffing_users_id = staffing_users.id)
4. 235.609 7,855.928 ↑ 1.0 423,444 1

Hash Join (cost=55,839.80..355,651.97 rows=423,444 width=538) (actual time=656.735..7,855.928 rows=423,444 loops=1)

  • Hash Cond: (claims_1.payroll_periods_id = payroll_periods.id)
5. 2,200.935 7,620.261 ↑ 1.0 423,444 1

Hash Join (cost=55,834.10..349,823.92 rows=423,444 width=530) (actual time=656.661..7,620.261 rows=423,444 loops=1)

  • Hash Cond: (events_venues.venues_profiles_id = venues_profiles.id)
6. 1,985.736 5,345.148 ↑ 1.0 423,444 1

Hash Left Join (cost=49,958.22..280,403.68 rows=423,444 width=526) (actual time=582.093..5,345.148 rows=423,444 loops=1)

  • Hash Cond: (claims_1.events_staffing_days_positions_id = events_staffing_days_positions.id)
7. 374.687 2,778.383 ↑ 1.0 423,444 1

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

  • Merge Cond: (claims_1.events_id = events_venues.events_id)
8. 557.803 1,798.965 ↑ 1.0 423,444 1

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

  • Merge Cond: (claims_1.events_id = events.id)
9. 449.667 449.667 ↑ 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.010..449.667 rows=423,444 loops=1)

10. 791.495 791.495 ↓ 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.007..791.495 rows=1,230,104 loops=1)

11. 604.731 604.731 ↓ 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.013..604.731 rows=1,230,479 loops=1)

12. 315.503 581.029 ↑ 1.0 1,100,884 1

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

  • Buckets: 131072 Batches: 16 Memory Usage: 3723kB
13. 265.526 265.526 ↑ 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.013..265.526 rows=1,100,884 loops=1)

14. 39.378 74.178 ↑ 1.0 167,728 1

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

  • Buckets: 131072 Batches: 4 Memory Usage: 2678kB
15. 34.800 34.800 ↑ 1.0 167,728 1

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

16. 0.024 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
17. 0.034 0.034 ↑ 1.0 120 1

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

18. 11.835 42.113 ↑ 1.0 42,004 1

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

  • Buckets: 65536 Batches: 1 Memory Usage: 2667kB
19. 30.278 30.278 ↑ 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..30.278 rows=42,004 loops=1)

20. 0.165 0.388 ↑ 1.0 673 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 56kB
21. 0.223 0.223 ↑ 1.0 673 1

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

22. 112.737 235.942 ↑ 1.0 415,935 1

Hash (cost=15,475.35..15,475.35 rows=415,935 width=20) (actual time=235.942..235.942 rows=415,935 loops=1)

  • Buckets: 65536 Batches: 8 Memory Usage: 3251kB
23. 123.205 123.205 ↑ 1.0 415,935 1

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