explain.depesz.com

PostgreSQL's explain analyze made readable

Result: XTAD

Settings
# exclusive inclusive rows x rows loops node
1. 9,975.968 146,619.568 ↓ 1.0 1,983,000 1

Sort (cost=1,992,810.61..1,997,761.85 rows=1,980,496 width=210) (actual time=145,501.265..146,619.568 rows=1,983,000 loops=1)

  • Sort Key: rumpagetable_kohls.sid
  • Sort Method: external merge Disk: 486264kB
2. 2,910.876 136,643.600 ↓ 1.0 1,983,000 1

Hash Join (cost=204,001.43..1,785,676.18 rows=1,980,496 width=210) (actual time=11,326.070..136,643.600 rows=1,983,000 loops=1)

  • Hash Cond: (rumpagetable_kohls.sid = a.sid)
3. 228.793 122,688.723 ↓ 1.0 1,983,502 1

Append (cost=0.00..1,554,442.93 rows=1,980,496 width=160) (actual time=273.658..122,688.723 rows=1,983,502 loops=1)

4. 0.001 0.001 ↓ 0.0 0 1

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

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

Seq Scan on rumpagetable_2019_kohls (cost=0.00..0.00 rows=1 width=168) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: ((navigationstarttime >= 186179400) AND (navigationstarttime < 186183600))
6. 0.000 0.000 ↓ 0.0 0 1

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

  • Filter: ((navigationstarttime >= 186179400) AND (navigationstarttime < 186183600))
7. 0.036 0.036 ↓ 0.0 0 1

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

  • Index Cond: ((navigationstarttime >= 186179400) AND (navigationstarttime < 186183600))
8. 0.001 2.162 ↓ 0.0 0 1

Bitmap Heap Scan on rumpagetable_20191125101922_kohls (cost=56.00..60.02 rows=1 width=160) (actual time=2.162..2.162 rows=0 loops=1)

  • Recheck Cond: ((navigationstarttime >= 186179400) AND (navigationstarttime < 186183600))
9. 2.161 2.161 ↓ 0.0 0 1

Bitmap Index Scan on rumpagetable_20191125101922_kohls_navigationstarttime_idx (cost=0.00..56.00 rows=1 width=0) (actual time=2.161..2.161 rows=0 loops=1)

  • Index Cond: ((navigationstarttime >= 186179400) AND (navigationstarttime < 186183600))
10. 34,242.558 34,242.558 ↓ 1.0 572,748 1

Seq Scan on rumpagetable_20191125120010_3_kohls (cost=0.00..450,653.20 rows=565,017 width=160) (actual time=271.454..34,242.558 rows=572,748 loops=1)

  • Filter: ((navigationstarttime >= 186179400) AND (navigationstarttime < 186183600))
  • Rows Removed by Filter: 1416932
11. 43,356.551 43,356.551 ↓ 1.0 489,840 1

Seq Scan on rumpagetable_20191125120005_1_kohls (cost=0.00..437,901.34 rows=479,526 width=160) (actual time=771.660..43,356.551 rows=489,840 loops=1)

  • Filter: ((navigationstarttime >= 186179400) AND (navigationstarttime < 186183600))
  • Rows Removed by Filter: 1432049
12. 21,917.524 21,917.524 ↑ 1.0 378,213 1

Seq Scan on rumpagetable_20191125120004_4_kohls (cost=0.00..295,359.25 rows=379,930 width=160) (actual time=361.601..21,917.524 rows=378,213 loops=1)

  • Filter: ((navigationstarttime >= 186179400) AND (navigationstarttime < 186183600))
  • Rows Removed by Filter: 929937
13. 22,894.371 22,894.371 ↑ 1.0 542,701 1

Seq Scan on rumpagetable_20191125141925_kohls (cost=0.00..370,284.91 rows=556,015 width=160) (actual time=30.943..22,894.371 rows=542,701 loops=1)

  • Filter: ((navigationstarttime >= 186179400) AND (navigationstarttime < 186183600))
  • Rows Removed by Filter: 1097560
14. 0.007 16.365 ↓ 0.0 0 1

Bitmap Heap Scan on rumpagetable_20191125160004_4_kohls (cost=40.00..44.02 rows=1 width=160) (actual time=16.365..16.365 rows=0 loops=1)

  • Recheck Cond: ((navigationstarttime >= 186179400) AND (navigationstarttime < 186183600))
15. 16.358 16.358 ↓ 0.0 0 1

Bitmap Index Scan on rumpagetable_20191125160004_4_kohls_navigationstarttime_idx (cost=0.00..40.00 rows=1 width=0) (actual time=16.358..16.358 rows=0 loops=1)

  • Index Cond: ((navigationstarttime >= 186179400) AND (navigationstarttime < 186183600))
16. 0.015 2.653 ↓ 0.0 0 1

Bitmap Heap Scan on rumpagetable_20191125160006_1_kohls (cost=64.00..68.02 rows=1 width=160) (actual time=2.653..2.653 rows=0 loops=1)

  • Recheck Cond: ((navigationstarttime >= 186179400) AND (navigationstarttime < 186183600))
17. 2.638 2.638 ↓ 0.0 0 1

Bitmap Index Scan on rumpagetable_20191125160006_1_kohls_navigationstarttime_idx (cost=0.00..64.00 rows=1 width=0) (actual time=2.638..2.638 rows=0 loops=1)

  • Index Cond: ((navigationstarttime >= 186179400) AND (navigationstarttime < 186183600))
18. 0.014 27.709 ↓ 0.0 0 1

Bitmap Heap Scan on rumpagetable_20191125160013_3_kohls (cost=60.00..64.02 rows=1 width=161) (actual time=27.709..27.709 rows=0 loops=1)

  • Recheck Cond: ((navigationstarttime >= 186179400) AND (navigationstarttime < 186183600))
19. 27.695 27.695 ↓ 0.0 0 1

Bitmap Index Scan on rumpagetable_20191125160013_3_kohls_navigationstarttime_idx (cost=0.00..60.00 rows=1 width=0) (actual time=27.695..27.695 rows=0 loops=1)

  • Index Cond: ((navigationstarttime >= 186179400) AND (navigationstarttime < 186183600))
20. 966.972 11,044.001 ↑ 1.0 1,278,216 1

Hash (cost=188,001.43..188,001.43 rows=1,280,000 width=63) (actual time=11,044.001..11,044.001 rows=1,278,216 loops=1)

  • Buckets: 2097152 Batches: 1 Memory Usage: 147926kB
21. 118.360 10,077.029 ↑ 1.0 1,278,216 1

Append (cost=0.00..188,001.43 rows=1,280,000 width=63) (actual time=44.095..10,077.029 rows=1,278,216 loops=1)

22. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on rumsessiontable_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 < 186183600))
23. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on rumsessiontable_2019_kohls a_1 (cost=0.00..0.00 rows=1 width=580) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: ((sessionstarttime >= 186172200) AND (sessionstarttime < 186183600))
24. 0.000 0.000 ↓ 0.0 0 1

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

  • Filter: ((sessionstarttime >= 186172200) AND (sessionstarttime < 186183600))
25. 0.026 0.026 ↓ 0.0 0 1

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

  • Index Cond: ((sessionstarttime >= 186172200) AND (sessionstarttime < 186183600))
26. 0.002 0.421 ↓ 0.0 0 1

Bitmap Heap Scan on rumsessiontable_20191125080005_1_kohls a_4 (cost=12.00..16.02 rows=1 width=62) (actual time=0.421..0.421 rows=0 loops=1)

  • Recheck Cond: ((sessionstarttime >= 186172200) AND (sessionstarttime < 186183600))
27. 0.419 0.419 ↓ 0.0 0 1

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

  • Index Cond: ((sessionstarttime >= 186172200) AND (sessionstarttime < 186183600))
28. 0.003 10.686 ↓ 0.0 0 1

Bitmap Heap Scan on rumsessiontable_20191125080008_3_kohls a_5 (cost=12.00..16.02 rows=1 width=62) (actual time=10.686..10.686 rows=0 loops=1)

  • Recheck Cond: ((sessionstarttime >= 186172200) AND (sessionstarttime < 186183600))
29. 10.683 10.683 ↓ 0.0 0 1

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

  • Index Cond: ((sessionstarttime >= 186172200) AND (sessionstarttime < 186183600))
30. 0.002 1.545 ↓ 0.0 0 1

Bitmap Heap Scan on rumsessiontable_20191125080003_4_kohls a_6 (cost=12.00..16.02 rows=1 width=62) (actual time=1.545..1.545 rows=0 loops=1)

  • Recheck Cond: ((sessionstarttime >= 186172200) AND (sessionstarttime < 186183600))
31. 1.543 1.543 ↓ 0.0 0 1

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

  • Index Cond: ((sessionstarttime >= 186172200) AND (sessionstarttime < 186183600))
32. 921.592 922.693 ↓ 1.0 130,282 1

Bitmap Heap Scan on rumsessiontable_20191125101922_kohls a_7 (cost=1,305.09..28,225.41 rows=126,155 width=62) (actual time=31.410..922.693 rows=130,282 loops=1)

  • Recheck Cond: ((sessionstarttime >= 186172200) AND (sessionstarttime < 186183600))
  • Rows Removed by Index Recheck: 20764
  • Heap Blocks: lossy=12100
33. 1.101 1.101 ↑ 1.0 121,600 1

Bitmap Index Scan on rumsessiontable_20191125101922_kohls_sessionstarttime_idx (cost=0.00..1,273.55 rows=126,155 width=0) (actual time=1.101..1.101 rows=121,600 loops=1)

  • Index Cond: ((sessionstarttime >= 186172200) AND (sessionstarttime < 186183600))
34. 2,301.650 2,301.650 ↑ 1.0 398,287 1

Seq Scan on rumsessiontable_20191125120010_3_kohls a_8 (cost=0.00..48,492.79 rows=399,911 width=62) (actual time=58.010..2,301.650 rows=398,287 loops=1)

  • Filter: ((sessionstarttime >= 186172200) AND (sessionstarttime < 186183600))
  • Rows Removed by Filter: 117099
35. 1,533.175 1,533.175 ↑ 1.0 321,359 1

Seq Scan on rumsessiontable_20191125120005_1_kohls a_9 (cost=0.00..38,956.04 rows=323,299 width=63) (actual time=15.399..1,533.175 rows=321,359 loops=1)

  • Filter: ((sessionstarttime >= 186172200) AND (sessionstarttime < 186183600))
  • Rows Removed by Filter: 89777
36. 1,591.973 1,591.973 ↑ 1.0 264,801 1

Seq Scan on rumsessiontable_20191125120004_4_kohls a_10 (cost=0.00..31,810.24 rows=265,330 width=62) (actual time=45.917..1,591.973 rows=264,801 loops=1)

  • Filter: ((sessionstarttime >= 186172200) AND (sessionstarttime < 186183600))
  • Rows Removed by Filter: 73215
37. 3,513.638 3,529.615 ↑ 1.0 163,487 1

Bitmap Heap Scan on rumsessiontable_20191125141925_kohls a_11 (cost=1,706.27..40,404.70 rows=165,295 width=64) (actual time=32.403..3,529.615 rows=163,487 loops=1)

  • Recheck Cond: ((sessionstarttime >= 186172200) AND (sessionstarttime < 186183600))
  • Rows Removed by Index Recheck: 180982
  • Heap Blocks: lossy=27264
38. 15.977 15.977 ↓ 1.6 272,640 1

Bitmap Index Scan on rumsessiontable_20191125141925_kohls_sessionstarttime_idx (cost=0.00..1,664.95 rows=165,295 width=0) (actual time=15.977..15.977 rows=272,640 loops=1)

  • Index Cond: ((sessionstarttime >= 186172200) AND (sessionstarttime < 186183600))
39. 0.008 57.066 ↓ 0.0 0 1

Bitmap Heap Scan on rumsessiontable_20191125160006_1_kohls a_12 (cost=16.00..20.02 rows=1 width=63) (actual time=57.066..57.066 rows=0 loops=1)

  • Recheck Cond: ((sessionstarttime >= 186172200) AND (sessionstarttime < 186183600))
40. 57.058 57.058 ↓ 0.0 0 1

Bitmap Index Scan on rumsessiontable_20191125160006_1_kohls_sessionstarttime_idx (cost=0.00..16.00 rows=1 width=0) (actual time=57.058..57.058 rows=0 loops=1)

  • Index Cond: ((sessionstarttime >= 186172200) AND (sessionstarttime < 186183600))
41. 0.015 8.557 ↓ 0.0 0 1

Bitmap Heap Scan on rumsessiontable_20191125160004_4_kohls a_13 (cost=12.00..16.02 rows=1 width=63) (actual time=8.557..8.557 rows=0 loops=1)

  • Recheck Cond: ((sessionstarttime >= 186172200) AND (sessionstarttime < 186183600))
42. 8.542 8.542 ↓ 0.0 0 1

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

  • Index Cond: ((sessionstarttime >= 186172200) AND (sessionstarttime < 186183600))
43. 0.013 1.259 ↓ 0.0 0 1

Bitmap Heap Scan on rumsessiontable_20191125160013_3_kohls a_14 (cost=16.00..20.02 rows=1 width=64) (actual time=1.259..1.259 rows=0 loops=1)

  • Recheck Cond: ((sessionstarttime >= 186172200) AND (sessionstarttime < 186183600))
44. 1.246 1.246 ↓ 0.0 0 1

Bitmap Index Scan on rumsessiontable_20191125160013_3_kohls_sessionstarttime_idx (cost=0.00..16.00 rows=1 width=0) (actual time=1.246..1.246 rows=0 loops=1)

  • Index Cond: ((sessionstarttime >= 186172200) AND (sessionstarttime < 186183600))
Planning time : 3,333.180 ms
Execution time : 146,917.189 ms