explain.depesz.com

PostgreSQL's explain analyze made readable

Result: S7Y0

Settings
# exclusive inclusive rows x rows loops node
1. 412.536 9,941.145 ↑ 4,147.5 292,482 1

Merge Join (cost=1,029,563.96..19,227,174.89 rows=1,213,074,175 width=210) (actual time=8,740.979..9,941.145 rows=292,482 loops=1)

  • Merge Cond: (b.sid = a.sid)
2. 756.015 5,383.450 ↑ 1.0 292,854 1

Sort (cost=766,087.69..766,836.85 rows=299,661 width=160) (actual time=5,087.862..5,383.450 rows=292,854 loops=1)

  • Sort Key: b.sid
  • Sort Method: quicksort Memory: 90079kB
3. 18.233 4,627.435 ↑ 1.0 292,860 1

Append (cost=0.00..738,829.07 rows=299,661 width=160) (actual time=86.371..4,627.435 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.049 0.049 ↓ 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.049..0.049 rows=0 loops=1)

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

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

  • Recheck Cond: ((navigationstarttime >= 186179400) AND (navigationstarttime < 186180000))
7. 1.938 1.938 ↓ 0.0 0 1

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

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

Bitmap Heap Scan on rumpagetable_20191125120010_3_kohls b_3 (cost=949.43..214,207.46 rows=86,383 width=160) (actual time=84.380..1,277.594 rows=82,661 loops=1)

  • Recheck Cond: ((navigationstarttime >= 186179400) AND (navigationstarttime < 186180000))
  • Rows Removed by Index Recheck: 747946
  • Heap Blocks: lossy=174976
9. 25.037 25.037 ↓ 20.3 1,749,760 1

Bitmap Index Scan on rumpagetable_20191125120010_3_kohls_navigationstarttime_idx (cost=0.00..927.83 rows=86,383 width=0) (actual time=25.037..25.037 rows=1,749,760 loops=1)

  • Index Cond: ((navigationstarttime >= 186179400) AND (navigationstarttime < 186180000))
10. 1,326.431 1,421.483 ↓ 1.0 70,211 1

Bitmap Heap Scan on rumpagetable_20191125120005_1_kohls b_4 (cost=758.44..179,393.21 rows=68,141 width=160) (actual time=127.175..1,421.483 rows=70,211 loops=1)

  • Recheck Cond: ((navigationstarttime >= 186179400) AND (navigationstarttime < 186180000))
  • Rows Removed by Index Recheck: 697923
  • Heap Blocks: lossy=162545
11. 95.052 95.052 ↓ 23.9 1,625,600 1

Bitmap Index Scan on rumpagetable_20191125120005_1_kohls_navigationstarttime_idx (cost=0.00..741.41 rows=68,141 width=0) (actual time=95.052..95.052 rows=1,625,600 loops=1)

  • Index Cond: ((navigationstarttime >= 186179400) AND (navigationstarttime < 186180000))
12. 800.971 835.093 ↑ 1.1 55,650 1

Bitmap Heap Scan on rumpagetable_20191125120004_4_kohls b_5 (cost=672.42..148,250.49 rows=61,309 width=160) (actual time=58.768..835.093 rows=55,650 loops=1)

  • Recheck Cond: ((navigationstarttime >= 186179400) AND (navigationstarttime < 186180000))
  • Rows Removed by Index Recheck: 485331
  • Heap Blocks: lossy=113945
13. 34.122 34.122 ↓ 18.6 1,140,480 1

Bitmap Index Scan on rumpagetable_20191125120004_4_kohls_navigationstarttime_idx (cost=0.00..657.09 rows=61,309 width=0) (actual time=34.122..34.122 rows=1,140,480 loops=1)

  • Index Cond: ((navigationstarttime >= 186179400) AND (navigationstarttime < 186180000))
14. 1,055.934 1,073.042 ↓ 1.0 84,338 1

Bitmap Heap Scan on rumpagetable_20191125141925_kohls b_6 (cost=911.21..196,909.74 rows=83,825 width=160) (actual time=17.297..1,073.042 rows=84,338 loops=1)

  • Recheck Cond: ((navigationstarttime >= 186179400) AND (navigationstarttime < 186180000))
  • Rows Removed by Index Recheck: 576354
  • Heap Blocks: lossy=138880
15. 17.108 17.108 ↓ 16.6 1,388,800 1

Bitmap Index Scan on rumpagetable_20191125141925_kohls_navigationstarttime_idx (cost=0.00..890.25 rows=83,825 width=0) (actual time=17.108..17.108 rows=1,388,800 loops=1)

  • Index Cond: ((navigationstarttime >= 186179400) AND (navigationstarttime < 186180000))
16. 1,877.991 4,145.159 ↓ 1.2 1,003,479 1

Sort (cost=263,476.27..265,500.34 rows=809,631 width=62) (actual time=3,652.370..4,145.159 rows=1,003,479 loops=1)

  • Sort Key: a.sid
  • Sort Method: quicksort Memory: 138270kB
17. 48.984 2,267.168 ↑ 1.0 808,489 1

Append (cost=0.00..184,023.51 rows=809,631 width=62) (actual time=2.093..2,267.168 rows=808,489 loops=1)

18. 0.003 0.003 ↓ 0.0 0 1

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

  • Filter: ((sessionstarttime >= 186172200) AND (sessionstarttime < 186180000))
19. 0.043 0.043 ↓ 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.043..0.043 rows=0 loops=1)

  • Index Cond: ((sessionstarttime >= 186172200) AND (sessionstarttime < 186180000))
20. 0.006 0.174 ↓ 0.0 0 1

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

  • Recheck Cond: ((sessionstarttime >= 186172200) AND (sessionstarttime < 186180000))
21. 0.168 0.168 ↓ 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.168..0.168 rows=0 loops=1)

  • Index Cond: ((sessionstarttime >= 186172200) AND (sessionstarttime < 186180000))
22. 0.005 0.140 ↓ 0.0 0 1

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

  • Recheck Cond: ((sessionstarttime >= 186172200) AND (sessionstarttime < 186180000))
23. 0.135 0.135 ↓ 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=0.135..0.135 rows=0 loops=1)

  • Index Cond: ((sessionstarttime >= 186172200) AND (sessionstarttime < 186180000))
24. 0.006 0.107 ↓ 0.0 0 1

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

  • Recheck Cond: ((sessionstarttime >= 186172200) AND (sessionstarttime < 186180000))
25. 0.101 0.101 ↓ 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=0.101..0.101 rows=0 loops=1)

  • Index Cond: ((sessionstarttime >= 186172200) AND (sessionstarttime < 186180000))
26. 251.885 252.711 ↓ 1.0 130,282 1

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

  • Recheck Cond: ((sessionstarttime >= 186172200) AND (sessionstarttime < 186180000))
  • Rows Removed by Index Recheck: 20764
  • Heap Blocks: lossy=12100
27. 0.826 0.826 ↑ 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=0.826..0.826 rows=121,600 loops=1)

  • Index Cond: ((sessionstarttime >= 186172200) AND (sessionstarttime < 186180000))
28. 717.881 876.949 ↑ 1.0 251,539 1

Bitmap Heap Scan on rumsessiontable_20191125120010_3_kohls a_6 (cost=2,623.22..47,200.67 rows=254,363 width=62) (actual time=159.661..876.949 rows=251,539 loops=1)

  • Recheck Cond: ((sessionstarttime >= 186172200) AND (sessionstarttime < 186180000))
  • Rows Removed by Index Recheck: 220728
  • Heap Blocks: lossy=37376
29. 159.068 159.068 ↓ 1.5 373,760 1

Bitmap Index Scan on rumsessiontable_20191125120010_3_kohls_sessionstarttime_idx (cost=0.00..2,559.63 rows=254,363 width=0) (actual time=159.068..159.068 rows=373,760 loops=1)

  • Index Cond: ((sessionstarttime >= 186172200) AND (sessionstarttime < 186180000))
30. 468.006 477.903 ↑ 1.0 215,513 1

Bitmap Heap Scan on rumsessiontable_20191125120005_1_kohls a_7 (cost=2,231.96..38,269.67 rows=216,581 width=63) (actual time=10.278..477.903 rows=215,513 loops=1)

  • Recheck Cond: ((sessionstarttime >= 186172200) AND (sessionstarttime < 186180000))
  • Rows Removed by Index Recheck: 166329
  • Heap Blocks: lossy=30464
31. 9.897 9.897 ↓ 1.4 304,640 1

Bitmap Index Scan on rumsessiontable_20191125120005_1_kohls_sessionstarttime_idx (cost=0.00..2,177.81 rows=216,581 width=0) (actual time=9.897..9.897 rows=304,640 loops=1)

  • Index Cond: ((sessionstarttime >= 186172200) AND (sessionstarttime < 186180000))
32. 377.157 379.447 ↑ 1.0 165,954 1

Bitmap Heap Scan on rumsessiontable_20191125120004_4_kohls a_8 (cost=1,723.79..30,968.85 rows=167,004 width=62) (actual time=3.578..379.447 rows=165,954 loops=1)

  • Recheck Cond: ((sessionstarttime >= 186172200) AND (sessionstarttime < 186180000))
  • Rows Removed by Index Recheck: 150866
  • Heap Blocks: lossy=25076
33. 2.290 2.290 ↓ 1.5 250,880 1

Bitmap Index Scan on rumsessiontable_20191125120004_4_kohls_sessionstarttime_idx (cost=0.00..1,682.04 rows=167,004 width=0) (actual time=2.290..2.290 rows=250,880 loops=1)

  • Index Cond: ((sessionstarttime >= 186172200) AND (sessionstarttime < 186180000))
34. 229.488 230.707 ↑ 1.0 45,201 1

Bitmap Heap Scan on rumsessiontable_20191125141925_kohls a_9 (cost=478.61..39,302.70 rows=45,523 width=64) (actual time=1.283..230.707 rows=45,201 loops=1)

  • Recheck Cond: ((sessionstarttime >= 186172200) AND (sessionstarttime < 186180000))
  • Rows Removed by Index Recheck: 188925
  • Heap Blocks: lossy=18560
35. 1.219 1.219 ↓ 4.1 185,600 1

Bitmap Index Scan on rumsessiontable_20191125141925_kohls_sessionstarttime_idx (cost=0.00..467.23 rows=45,523 width=0) (actual time=1.219..1.219 rows=185,600 loops=1)

  • Index Cond: ((sessionstarttime >= 186172200) AND (sessionstarttime < 186180000))
Planning time : 2,848.835 ms
Execution time : 10,056.897 ms