explain.depesz.com

PostgreSQL's explain analyze made readable

Result: LXG

Settings
# exclusive inclusive rows x rows loops node
1. 117.967 151,757.345 ↑ 1,227.5 71,808 1

Merge Join (cost=233,333.32..1,555,784.09 rows=88,143,694 width=209) (actual time=151,464.878..151,757.345 rows=71,808 loops=1)

  • Merge Cond: (b.sid = a.sid)
2. 165.414 137,475.352 ↓ 1.2 73,299 1

Sort (cost=160,203.43..160,351.11 rows=59,072 width=160) (actual time=137,412.558..137,475.352 rows=73,299 loops=1)

  • Sort Key: b.sid
  • Sort Method: quicksort Memory: 22558kB
3. 7.784 137,309.938 ↓ 1.2 73,356 1

Append (cost=0.00..155,521.91 rows=59,072 width=160) (actual time=0.071..137,309.938 rows=73,356 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 >= 186133800) AND (navigationstarttime < 186134400))
5. 0.034 0.034 ↓ 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.034..0.034 rows=0 loops=1)

  • Index Cond: ((navigationstarttime >= 186133800) AND (navigationstarttime < 186134400))
6. 136,420.278 136,420.278 ↓ 6.3 20,008 1

Index Scan using rumpagetable_20191124221916_kohls_navigationstarttime_idx on rumpagetable_20191124221916_kohls b_2 (cost=0.42..2,843.58 rows=3,156 width=160) (actual time=0.035..136,420.278 rows=20,008 loops=1)

  • Index Cond: ((navigationstarttime >= 186133800) AND (navigationstarttime < 186134400))
7. 337.226 347.430 ↓ 1.0 21,000 1

Bitmap Heap Scan on rumpagetable_20191125000008_3_kohls b_3 (cost=231.73..56,016.50 rows=20,266 width=160) (actual time=14.643..347.430 rows=21,000 loops=1)

  • Recheck Cond: ((navigationstarttime >= 186133800) AND (navigationstarttime < 186134400))
  • Rows Removed by Index Recheck: 240126
  • Heap Blocks: lossy=54727
8. 10.204 10.204 ↓ 27.0 547,840 1

Bitmap Index Scan on rumpagetable_20191125000008_3_kohls_navigationstarttime_idx (cost=0.00..226.66 rows=20,266 width=0) (actual time=10.204..10.204 rows=547,840 loops=1)

  • Index Cond: ((navigationstarttime >= 186133800) AND (navigationstarttime < 186134400))
9. 374.010 379.245 ↑ 1.1 20,082 1

Bitmap Heap Scan on rumpagetable_20191125000004_1_kohls b_4 (cost=258.00..61,378.19 rows=22,829 width=160) (actual time=39.477..379.245 rows=20,082 loops=1)

  • Recheck Cond: ((navigationstarttime >= 186133800) AND (navigationstarttime < 186134400))
  • Rows Removed by Index Recheck: 250478
  • Heap Blocks: lossy=56925
10. 5.235 5.235 ↓ 25.0 569,600 1

Bitmap Index Scan on rumpagetable_20191125000004_1_kohls_navigationstarttime_idx (cost=0.00..252.29 rows=22,829 width=0) (actual time=5.235..5.235 rows=569,600 loops=1)

  • Index Cond: ((navigationstarttime >= 186133800) AND (navigationstarttime < 186134400))
11. 152.251 154.755 ↑ 1.0 12,266 1

Bitmap Heap Scan on rumpagetable_20191125000002_4_kohls b_5 (cost=151.39..35,251.46 rows=12,818 width=160) (actual time=14.313..154.755 rows=12,266 loops=1)

  • Recheck Cond: ((navigationstarttime >= 186133800) AND (navigationstarttime < 186134400))
  • Rows Removed by Index Recheck: 150047
  • Heap Blocks: lossy=34048
12. 2.504 2.504 ↓ 26.6 340,480 1

Bitmap Index Scan on rumpagetable_20191125000002_4_kohls_navigationstarttime_idx (cost=0.00..148.18 rows=12,818 width=0) (actual time=2.504..2.504 rows=340,480 loops=1)

  • Index Cond: ((navigationstarttime >= 186133800) AND (navigationstarttime < 186134400))
13. 0.007 0.411 ↓ 0.0 0 1

Bitmap Heap Scan on rumpagetable_20191125021921_kohls b_6 (cost=20.00..24.02 rows=1 width=160) (actual time=0.411..0.411 rows=0 loops=1)

  • Recheck Cond: ((navigationstarttime >= 186133800) AND (navigationstarttime < 186134400))
14. 0.404 0.404 ↓ 0.0 0 1

Bitmap Index Scan on rumpagetable_20191125021921_kohls_navigationstarttime_idx (cost=0.00..20.00 rows=1 width=0) (actual time=0.404..0.404 rows=0 loops=1)

  • Index Cond: ((navigationstarttime >= 186133800) AND (navigationstarttime < 186134400))
15. 480.708 14,164.026 ↓ 1.1 336,548 1

Sort (cost=73,129.90..73,875.97 rows=298,428 width=62) (actual time=14,050.786..14,164.026 rows=336,548 loops=1)

  • Sort Key: a.sid
  • Sort Method: quicksort Memory: 52234kB
16. 24.683 13,683.318 ↑ 1.1 284,057 1

Append (cost=0.00..45,992.31 rows=298,428 width=62) (actual time=1,597.867..13,683.318 rows=284,057 loops=1)

17. 0.004 0.004 ↓ 0.0 0 1

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

  • Filter: ((sessionstarttime >= 186127200) AND (sessionstarttime < 186134400))
18. 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 >= 186127200) AND (sessionstarttime < 186134400))
19. 7,221.951 7,221.951 ↓ 6.1 85 1

Index Scan using rumsessiontable_20191124200008_3_kohls_sessionstarttime_idx on rumsessiontable_20191124200008_3_kohls a_2 (cost=0.42..11.61 rows=14 width=62) (actual time=1,597.825..7,221.951 rows=85 loops=1)

  • Index Cond: ((sessionstarttime >= 186127200) AND (sessionstarttime < 186134400))
20. 227.477 227.477 ↓ 6.7 40 1

Index Scan using rumsessiontable_20191124200004_1_kohls_sessionstarttime_idx on rumsessiontable_20191124200004_1_kohls a_3 (cost=0.42..9.19 rows=6 width=62) (actual time=23.935..227.477 rows=40 loops=1)

  • Index Cond: ((sessionstarttime >= 186127200) AND (sessionstarttime < 186134400))
21. 616.537 616.537 ↓ 10.0 20 1

Index Scan using rumsessiontable_20191124200002_4_kohls_sessionstarttime_idx on rumsessiontable_20191124200002_4_kohls a_4 (cost=0.42..8.58 rows=2 width=62) (actual time=68.211..616.537 rows=20 loops=1)

  • Index Cond: ((sessionstarttime >= 186127200) AND (sessionstarttime < 186134400))
22. 5,180.915 5,180.915 ↑ 1.0 64,562 1

Seq Scan on rumsessiontable_20191124221916_kohls a_5 (cost=0.00..16,010.68 rows=65,180 width=62) (actual time=2,180.464..5,180.915 rows=64,562 loops=1)

  • Filter: ((sessionstarttime >= 186127200) AND (sessionstarttime < 186134400))
  • Rows Removed by Filter: 106364
23. 144.393 144.393 ↑ 1.1 68,769 1

Seq Scan on rumsessiontable_20191125000004_1_kohls a_6 (cost=0.00..9,535.48 rows=73,731 width=62) (actual time=0.095..144.393 rows=68,769 loops=1)

  • Filter: ((sessionstarttime >= 186127200) AND (sessionstarttime < 186134400))
  • Rows Removed by Filter: 33196
24. 180.139 180.139 ↑ 1.1 92,971 1

Seq Scan on rumsessiontable_20191125000008_3_kohls a_7 (cost=0.00..12,562.73 rows=98,159 width=61) (actual time=0.046..180.139 rows=92,971 loops=1)

  • Filter: ((sessionstarttime >= 186127200) AND (sessionstarttime < 186134400))
  • Rows Removed by Filter: 42211
25. 86.981 86.981 ↑ 1.1 57,610 1

Seq Scan on rumsessiontable_20191125000002_4_kohls a_8 (cost=0.00..7,829.86 rows=61,333 width=62) (actual time=0.038..86.981 rows=57,610 loops=1)

  • Filter: ((sessionstarttime >= 186127200) AND (sessionstarttime < 186134400))
  • Rows Removed by Filter: 26781
26. 0.005 0.205 ↓ 0.0 0 1

Bitmap Heap Scan on rumsessiontable_20191125021921_kohls a_9 (cost=12.00..16.02 rows=1 width=64) (actual time=0.205..0.205 rows=0 loops=1)

  • Recheck Cond: ((sessionstarttime >= 186127200) AND (sessionstarttime < 186134400))
27. 0.200 0.200 ↓ 0.0 0 1

Bitmap Index Scan on rumsessiontable_20191125021921_kohls_sessionstarttime_idx (cost=0.00..12.00 rows=1 width=0) (actual time=0.200..0.200 rows=0 loops=1)

  • Index Cond: ((sessionstarttime >= 186127200) AND (sessionstarttime < 186134400))
Planning time : 5,402.411 ms
Execution time : 151,768.143 ms