explain.depesz.com

PostgreSQL's explain analyze made readable

Result: t2W4

Settings
# exclusive inclusive rows x rows loops node
1. 663.933 8,685.258 ↑ 1.0 427,852 1

Hash Join (cost=264,322.05..436,987.61 rows=427,906 width=588) (actual time=5,236.848..8,685.258 rows=427,852 loops=1)

  • Hash Cond: (claims_1.staffing_users_id = staffing_users.id)
2. 292.377 7,990.192 ↑ 1.0 427,852 1

Hash Join (cost=261,257.44..423,760.23 rows=427,906 width=574) (actual time=5,205.465..7,990.192 rows=427,852 loops=1)

  • Hash Cond: (claims_1.payroll_periods_id = payroll_periods.id)
3. 304.431 7,697.735 ↑ 1.0 427,852 1

Hash Join (cost=261,251.74..417,870.82 rows=427,906 width=566) (actual time=5,205.371..7,697.735 rows=427,852 loops=1)

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

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

  • Hash Cond: (claims_1.events_id = events.id)
5. 891.047 1,938.539 ↑ 1.0 427,852 1

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

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

7. 377.098 747.020 ↑ 1.0 1,137,627 1

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

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

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

9. 569.229 4,454.305 ↓ 1.0 1,095,422 1

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

  • Buckets: 65536 Batches: 64 Memory Usage: 1959kB
10. 1,166.160 3,885.076 ↓ 1.0 1,095,422 1

Hash Join (cost=99,711.82..181,344.86 rows=1,091,201 width=79) (actual time=1,579.552..3,885.076 rows=1,095,422 loops=1)

  • Hash Cond: (events_venues.events_id = events.id)
11. 812.892 1,775.043 ↓ 1.0 1,095,797 1

Hash Join (cost=37,612.88..80,716.91 rows=1,091,201 width=24) (actual time=635.141..1,775.043 rows=1,095,797 loops=1)

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

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

13. 80.905 634.811 ↑ 1.0 191,961 1

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

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

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

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

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

16. 63.060 117.933 ↑ 1.0 192,100 1

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

  • Buckets: 131072 Batches: 4 Memory Usage: 2895kB
17. 54.873 54.873 ↑ 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..54.873 rows=192,100 loops=1)

18. 458.067 943.873 ↑ 1.0 1,095,423 1

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

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

Seq Scan on events (cost=0.00..37,619.75 rows=1,099,375 width=55) (actual time=0.007..485.806 rows=1,095,423 loops=1)

20. 0.240 0.607 ↑ 1.0 683 1

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

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

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

22. 0.036 0.080 ↓ 1.0 121 1

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

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

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

24. 15.408 31.133 ↑ 1.0 42,116 1

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

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

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