explain.depesz.com

PostgreSQL's explain analyze made readable

Result: aIN

Settings
# exclusive inclusive rows x rows loops node
1. 1,050.518 7,031.218 ↑ 1.0 423,444 1

Hash Join (cost=81,834.57..468,642.25 rows=423,444 width=742) (actual time=921.439..7,031.218 rows=423,444 loops=1)

  • Hash Cond: (venues_profiles.venues_id = venues.id)
2. 255.112 5,753.630 ↑ 1.0 423,444 1

Hash Join (cost=58,722.03..370,178.92 rows=423,444 width=584) (actual time=691.234..5,753.630 rows=423,444 loops=1)

  • Hash Cond: (events.programs_id = programs.id)
3. 276.730 5,498.141 ↑ 1.0 423,444 1

Hash Join (cost=58,680.89..364,315.42 rows=423,444 width=552) (actual time=690.843..5,498.141 rows=423,444 loops=1)

  • Hash Cond: (claims_1.staffing_users_id = staffing_users.id)
4. 196.425 5,192.082 ↑ 1.0 423,444 1

Hash Join (cost=55,839.80..355,651.97 rows=423,444 width=538) (actual time=661.399..5,192.082 rows=423,444 loops=1)

  • Hash Cond: (claims_1.payroll_periods_id = payroll_periods.id)
5. 597.517 4,995.599 ↑ 1.0 423,444 1

Hash Join (cost=55,834.10..349,823.92 rows=423,444 width=530) (actual time=661.324..4,995.599 rows=423,444 loops=1)

  • Hash Cond: (events_venues.venues_profiles_id = venues_profiles.id)
6. 911.425 4,324.826 ↑ 1.0 423,444 1

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

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

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

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

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

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

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

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

12. 260.443 586.716 ↑ 1.0 1,100,884 1

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

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

14. 39.930 73.256 ↑ 1.0 167,728 1

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

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

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

16. 0.020 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.038 0.038 ↑ 1.0 120 1

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

18. 11.956 29.329 ↑ 1.0 42,004 1

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

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

20. 0.159 0.377 ↑ 1.0 673 1

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

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

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

22. 119.254 227.070 ↑ 1.0 415,935 1

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

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

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