explain.depesz.com

PostgreSQL's explain analyze made readable

Result: tEv4

Settings
# exclusive inclusive rows x rows loops node
1. 420.038 101,468.289 ↑ 4,151.2 292,482 1

Merge Join (cost=401,716.03..18,615,629.16 rows=1,214,160,939 width=210) (actual time=100,807.502..101,468.289 rows=292,482 loops=1)

  • Merge Cond: (b.sid = a.sid)
2. 589.101 23,083.464 ↑ 1.0 292,854 1

Sort (cost=170,060.49..170,810.01 rows=299,808 width=160) (actual time=22,989.048..23,083.464 rows=292,854 loops=1)

  • Sort Key: b.sid
  • Sort Method: quicksort Memory: 90079kB
3. 36.802 22,494.363 ↑ 1.0 292,860 1

Append (cost=0.00..142,787.44 rows=299,808 width=160) (actual time=229.577..22,494.363 rows=292,860 loops=1)

4. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on rumpagetable_11_2019_kohls b (cost=0.00..0.00 rows=1 width=168) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: ((navigationstarttime >= 186179400) AND (navigationstarttime < 186180000))
5. 0.015 0.015 ↓ 0.0 0 1

Index Scan using rumpagetable_20191102024102_3_kohls_navigationstarttime_idx on rumpagetable_20191102024102_3_kohls b_1 (cost=0.14..8.16 rows=1 width=168) (actual time=0.015..0.015 rows=0 loops=1)

  • Index Cond: ((navigationstarttime >= 186179400) AND (navigationstarttime < 186180000))
6. 0.007 0.007 ↓ 0.0 0 1

Index Scan using rumpagetable_20191125101922_kohls_navigationstarttime_idx on rumpagetable_20191125101922_kohls b_2 (cost=0.43..8.45 rows=1 width=160) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((navigationstarttime >= 186179400) AND (navigationstarttime < 186180000))
7. 7,236.632 7,236.632 ↑ 1.0 82,661 1

Index Scan using rumpagetable_20191125120010_3_kohls_navigationstarttime_idx on rumpagetable_20191125120010_3_kohls b_3 (cost=0.43..41,834.60 rows=86,528 width=160) (actual time=229.554..7,236.632 rows=82,661 loops=1)

  • Index Cond: ((navigationstarttime >= 186179400) AND (navigationstarttime < 186180000))
8. 6,197.697 6,197.697 ↓ 1.0 70,211 1

Index Scan using rumpagetable_20191125120005_1_kohls_navigationstarttime_idx on rumpagetable_20191125120005_1_kohls b_4 (cost=0.43..34,179.69 rows=68,053 width=160) (actual time=42.137..6,197.697 rows=70,211 loops=1)

  • Index Cond: ((navigationstarttime >= 186179400) AND (navigationstarttime < 186180000))
9. 4,552.835 4,552.835 ↑ 1.1 55,650 1

Index Scan using rumpagetable_20191125120004_4_kohls_navigationstarttime_idx on rumpagetable_20191125120004_4_kohls b_5 (cost=0.43..28,476.00 rows=61,336 width=160) (actual time=81.633..4,552.835 rows=55,650 loops=1)

  • Index Cond: ((navigationstarttime >= 186179400) AND (navigationstarttime < 186180000))
10. 4,470.374 4,470.374 ↓ 1.0 84,338 1

Index Scan using rumpagetable_20191125141925_kohls_navigationstarttime_idx on rumpagetable_20191125141925_kohls b_6 (cost=0.43..38,280.53 rows=83,888 width=160) (actual time=157.621..4,470.374 rows=84,338 loops=1)

  • Index Cond: ((navigationstarttime >= 186179400) AND (navigationstarttime < 186180000))
11. 1,460.689 77,964.787 ↓ 1.2 1,003,479 1

Sort (cost=231,655.54..233,680.44 rows=809,959 width=62) (actual time=77,817.493..77,964.787 rows=1,003,479 loops=1)

  • Sort Key: a.sid
  • Sort Method: quicksort Memory: 138270kB
12. 93.570 76,504.098 ↑ 1.0 808,489 1

Append (cost=0.00..152,168.23 rows=809,959 width=62) (actual time=84.703..76,504.098 rows=808,489 loops=1)

13. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on rumsessiontable_11_2019_kohls a (cost=0.00..0.00 rows=1 width=580) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: ((sessionstarttime >= 186172200) AND (sessionstarttime < 186180000))
14. 0.033 0.033 ↓ 0.0 0 1

Index Scan using rumsessiontable_20191102024102_3_kohls_sessionstarttime_idx on rumsessiontable_20191102024102_3_kohls a_1 (cost=0.14..8.16 rows=1 width=580) (actual time=0.033..0.033 rows=0 loops=1)

  • Index Cond: ((sessionstarttime >= 186172200) AND (sessionstarttime < 186180000))
15. 0.025 0.025 ↓ 0.0 0 1

Index Scan using rumsessiontable_20191125080005_1_kohls_sessionstarttime_idx on rumsessiontable_20191125080005_1_kohls a_2 (cost=0.42..8.44 rows=1 width=62) (actual time=0.025..0.025 rows=0 loops=1)

  • Index Cond: ((sessionstarttime >= 186172200) AND (sessionstarttime < 186180000))
16. 0.020 0.020 ↓ 0.0 0 1

Index Scan using rumsessiontable_20191125080008_3_kohls_sessionstarttime_idx on rumsessiontable_20191125080008_3_kohls a_3 (cost=0.42..8.44 rows=1 width=62) (actual time=0.020..0.020 rows=0 loops=1)

  • Index Cond: ((sessionstarttime >= 186172200) AND (sessionstarttime < 186180000))
17. 0.015 0.015 ↓ 0.0 0 1

Index Scan using rumsessiontable_20191125080003_4_kohls_sessionstarttime_idx on rumsessiontable_20191125080003_4_kohls a_4 (cost=0.42..8.44 rows=1 width=62) (actual time=0.015..0.015 rows=0 loops=1)

  • Index Cond: ((sessionstarttime >= 186172200) AND (sessionstarttime < 186180000))
18. 2,751.589 2,751.589 ↓ 1.0 130,282 1

Index Scan using rumsessiontable_20191125101922_kohls_sessionstarttime_idx on rumsessiontable_20191125101922_kohls a_5 (cost=0.42..26,616.39 rows=126,273 width=62) (actual time=84.597..2,751.589 rows=130,282 loops=1)

  • Index Cond: ((sessionstarttime >= 186172200) AND (sessionstarttime < 186180000))
19. 9,804.254 9,804.254 ↑ 1.0 251,539 1

Seq Scan on rumsessiontable_20191125120010_3_kohls a_6 (cost=0.00..48,494.90 rows=254,433 width=62) (actual time=469.461..9,804.254 rows=251,539 loops=1)

  • Filter: ((sessionstarttime >= 186172200) AND (sessionstarttime < 186180000))
  • Rows Removed by Filter: 263847
20. 1,541.297 1,541.297 ↑ 1.0 215,513 1

Seq Scan on rumsessiontable_20191125120005_1_kohls a_7 (cost=0.00..38,957.56 rows=216,635 width=63) (actual time=35.638..1,541.297 rows=215,513 loops=1)

  • Filter: ((sessionstarttime >= 186172200) AND (sessionstarttime < 186180000))
  • Rows Removed by Filter: 195623
21. 46,701.966 46,701.966 ↑ 1.0 165,954 1

Index Scan using rumsessiontable_20191125120004_4_kohls_sessionstarttime_idx on rumsessiontable_20191125120004_4_kohls a_8 (cost=0.42..29,965.64 rows=167,048 width=62) (actual time=73.871..46,701.966 rows=165,954 loops=1)

  • Index Cond: ((sessionstarttime >= 186172200) AND (sessionstarttime < 186180000))
22. 15,611.327 15,611.327 ↑ 1.0 45,201 1

Index Scan using rumsessiontable_20191125141925_kohls_sessionstarttime_idx on rumsessiontable_20191125141925_kohls a_9 (cost=0.42..8,100.26 rows=45,565 width=64) (actual time=0.088..15,611.327 rows=45,201 loops=1)

  • Index Cond: ((sessionstarttime >= 186172200) AND (sessionstarttime < 186180000))
Planning time : 22,770.847 ms
Execution time : 101,492.966 ms