explain.depesz.com

PostgreSQL's explain analyze made readable

Result: PYRG

Settings
# exclusive inclusive rows x rows loops node
1. 668.596 9,010.294 ↑ 1.0 427,852 1

Hash Join (cost=264,322.05..436,987.61 rows=427,906 width=588) (actual time=5,512.374..9,010.294 rows=427,852 loops=1)

  • Hash Cond: (claims_1.staffing_users_id = staffing_users.id)
2. 291.442 8,301.134 ↑ 1.0 427,852 1

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

  • Hash Cond: (claims_1.payroll_periods_id = payroll_periods.id)
3. 306.806 8,009.600 ↑ 1.0 427,852 1

Hash Join (cost=261,251.74..417,870.82 rows=427,906 width=566) (actual time=5,471.481..8,009.600 rows=427,852 loops=1)

  • Hash Cond: (events.programs_id = programs.id)
4. 998.638 7,701.989 ↑ 1.0 427,852 1

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

  • Hash Cond: (claims_1.events_id = events.id)
5. 889.613 2,099.483 ↑ 1.0 427,852 1

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

  • Hash Cond: (claims_1.events_staffing_days_positions_id = events_staffing_days_positions.id)
6. 346.406 346.406 ↑ 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.014..346.406 rows=427,852 loops=1)

7. 390.304 863.464 ↑ 1.0 1,137,626 1

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

  • Buckets: 131072 Batches: 16 Memory Usage: 3811kB
8. 473.160 473.160 ↑ 1.0 1,137,626 1

Seq Scan on events_staffing_days_positions (cost=0.00..33,656.99 rows=1,138,999 width=8) (actual time=0.014..473.160 rows=1,137,626 loops=1)

9. 569.300 4,603.868 ↓ 1.0 1,095,421 1

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

  • Buckets: 65536 Batches: 64 Memory Usage: 1959kB
10. 1,117.619 4,034.568 ↓ 1.0 1,095,421 1

Hash Join (cost=99,711.82..181,344.86 rows=1,091,201 width=79) (actual time=1,734.182..4,034.568 rows=1,095,421 loops=1)

  • Hash Cond: (events_venues.events_id = events.id)
11. 830.207 1,896.635 ↓ 1.0 1,095,796 1

Hash Join (cost=37,612.88..80,716.91 rows=1,091,201 width=24) (actual time=713.283..1,896.635 rows=1,095,796 loops=1)

  • Hash Cond: (events_venues.venues_profiles_id = venues_profiles.id)
12. 353.395 353.395 ↓ 1.0 1,095,797 1

Seq Scan on events_venues (cost=0.00..18,447.01 rows=1,091,201 width=8) (actual time=0.007..353.395 rows=1,095,797 loops=1)

13. 82.741 713.033 ↑ 1.0 191,961 1

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

  • Buckets: 65536 Batches: 4 Memory Usage: 3065kB
14. 295.844 630.292 ↑ 1.0 191,961 1

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

  • Hash Cond: (venues.id = venues_profiles.venues_id)
15. 205.602 205.602 ↑ 1.0 446,750 1

Seq Scan on venues (cost=0.00..17,646.68 rows=452,968 width=20) (actual time=0.012..205.602 rows=446,750 loops=1)

16. 64.540 128.846 ↑ 1.0 192,100 1

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

  • Buckets: 131072 Batches: 4 Memory Usage: 2895kB
17. 64.306 64.306 ↑ 1.0 192,100 1

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

18. 454.605 1,020.314 ↑ 1.0 1,095,422 1

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

  • Buckets: 65536 Batches: 32 Memory Usage: 2674kB
19. 565.709 565.709 ↑ 1.0 1,095,422 1

Seq Scan on events (cost=0.00..37,619.75 rows=1,099,375 width=55) (actual time=0.022..565.709 rows=1,095,422 loops=1)

20. 0.248 0.805 ↑ 1.0 683 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 56kB
21. 0.557 0.557 ↑ 1.0 683 1

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

22. 0.042 0.092 ↓ 1.0 121 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 14kB
23. 0.050 0.050 ↓ 1.0 121 1

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

24. 16.334 40.564 ↑ 1.0 42,116 1

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

  • Buckets: 65536 Batches: 1 Memory Usage: 2673kB
25. 24.230 24.230 ↑ 1.0 42,116 1

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