explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 52q7

Settings
# exclusive inclusive rows x rows loops node
1. 0.420 4,649.638 ↑ 1.0 15 1

Nested Loop Left Join (cost=3.84..117,804.93 rows=15 width=584) (actual time=894.065..4,649.638 rows=15 loops=1)

2. 0.048 4,320.328 ↑ 1.0 15 1

Limit (cost=3.84..36,262.19 rows=15 width=552) (actual time=757.904..4,320.328 rows=15 loops=1)

3. 789.584 4,320.280 ↑ 55,100.8 15 1

Nested Loop (cost=3.84..1,997,864,286.04 rows=826,512 width=552) (actual time=757.902..4,320.280 rows=15 loops=1)

  • Join Filter: (a.sid = b.sid)
  • Rows Removed by Join Filter: 2350622
4. 0.092 321.768 ↑ 51,657.0 16 1

Merge Append (cost=3.84..1,524,462.14 rows=826,512 width=510) (actual time=207.892..321.768 rows=16 loops=1)

  • Sort Key: a.navigationstarttime DESC
5. 0.031 0.031 ↓ 0.0 0 1

Index Scan Backward using rumpagetable_11_2019_kohls_navst_sid_pageinstance_idx on rumpagetable_11_2019_kohls a (cost=0.12..8.14 rows=1 width=258) (actual time=0.031..0.031 rows=0 loops=1)

  • Index Cond: ((navigationstarttime >= 186085800) AND (navigationstarttime < 186089340))
6. 0.011 0.011 ↓ 0.0 0 1

Index Scan Backward using rumpagetable_20191102024102_3_kohls_navst_sid_pageinstance_idx on rumpagetable_20191102024102_3_kohls a_1 (cost=0.14..8.16 rows=1 width=258) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: ((navigationstarttime >= 186085800) AND (navigationstarttime < 186089340))
7. 0.020 0.020 ↓ 0.0 0 1

Index Scan Backward using rumpagetable_20191124080003_3_kohls_navst_sid_pageinstance_idx on rumpagetable_20191124080003_3_kohls a_2 (cost=0.42..8.45 rows=1 width=515) (actual time=0.020..0.020 rows=0 loops=1)

  • Index Cond: ((navigationstarttime >= 186085800) AND (navigationstarttime < 186089340))
8. 0.015 0.015 ↓ 0.0 0 1

Index Scan Backward using rumpagetable_20191124080003_1_kohls_navst_sid_pageinstance_idx on rumpagetable_20191124080003_1_kohls a_3 (cost=0.42..8.45 rows=1 width=511) (actual time=0.015..0.015 rows=0 loops=1)

  • Index Cond: ((navigationstarttime >= 186085800) AND (navigationstarttime < 186089340))
9. 0.011 0.011 ↓ 0.0 0 1

Index Scan Backward using rumpagetable_20191124080007_kohls_navst_sid_pageinstance_idx on rumpagetable_20191124080007_kohls a_4 (cost=0.42..8.45 rows=1 width=514) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: ((navigationstarttime >= 186085800) AND (navigationstarttime < 186089340))
10. 0.015 0.015 ↓ 0.0 0 1

Index Scan Backward using rumpagetable_20191124080002_4_kohls_navst_sid_pageinstance_idx on rumpagetable_20191124080002_4_kohls a_5 (cost=0.42..8.45 rows=1 width=518) (actual time=0.015..0.015 rows=0 loops=1)

  • Index Cond: ((navigationstarttime >= 186085800) AND (navigationstarttime < 186089340))
11. 161.436 161.436 ↑ 14,840.0 16 1

Index Scan Backward using rumpagetable_20191124120003_3_kohls_navst_pageid_idx on rumpagetable_20191124120003_3_kohls a_6 (cost=0.42..428,368.41 rows=237,440 width=511) (actual time=47.639..161.436 rows=16 loops=1)

  • Index Cond: ((navigationstarttime >= 186085800) AND (navigationstarttime < 186089340))
12. 52.131 52.131 ↑ 215,198.0 1 1

Index Scan Backward using rumpagetable_20191124120003_1_kohls_navst_pageid_idx on rumpagetable_20191124120003_1_kohls a_7 (cost=0.42..390,187.56 rows=215,198 width=509) (actual time=52.131..52.131 rows=1 loops=1)

  • Index Cond: ((navigationstarttime >= 186085800) AND (navigationstarttime < 186089340))
13. 51.656 51.656 ↑ 214,899.0 1 1

Index Scan Backward using rumpagetable_20191124120007_kohls_navst_pageid_idx on rumpagetable_20191124120007_kohls a_8 (cost=0.42..389,023.60 rows=214,899 width=509) (actual time=51.656..51.656 rows=1 loops=1)

  • Index Cond: ((navigationstarttime >= 186085800) AND (navigationstarttime < 186089340))
14. 56.350 56.350 ↑ 158,969.0 1 1

Index Scan Backward using rumpagetable_20191124120002_4_kohls_navst_pageid_idx on rumpagetable_20191124120002_4_kohls a_9 (cost=0.42..287,309.90 rows=158,969 width=510) (actual time=56.350..56.350 rows=1 loops=1)

  • Index Cond: ((navigationstarttime >= 186085800) AND (navigationstarttime < 186089340))
15. 296.439 3,208.928 ↑ 1.1 146,915 16

Materialize (cost=0.00..76,124.25 rows=161,018 width=55) (actual time=5.842..200.558 rows=146,915 loops=16)

16. 13.676 2,912.489 ↑ 1.0 153,690 1

Append (cost=0.00..75,319.16 rows=161,018 width=55) (actual time=93.426..2,912.489 rows=153,690 loops=1)

17. 0.004 0.004 ↓ 0.0 0 1

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

  • Filter: ((sessionstarttime >= 186085800) AND (sessionstarttime <= 186089340))
18. 0.032 0.032 ↓ 0.0 0 1

Index Scan using rumsessiontable_20191102024102_3_kohls_sessionst_strid_trmnlid_ on rumsessiontable_20191102024102_3_kohls b_1 (cost=0.14..8.16 rows=1 width=416) (actual time=0.032..0.032 rows=0 loops=1)

  • Index Cond: ((sessionstarttime >= 186085800) AND (sessionstarttime <= 186089340))
19. 0.032 0.032 ↓ 0.0 0 1

Index Scan using rumsessiontable_20191124080003_3_kohls_sessionst_strid_trmnlid_ on rumsessiontable_20191124080003_3_kohls b_2 (cost=0.42..8.44 rows=1 width=56) (actual time=0.032..0.032 rows=0 loops=1)

  • Index Cond: ((sessionstarttime >= 186085800) AND (sessionstarttime <= 186089340))
20. 0.028 0.028 ↓ 0.0 0 1

Index Scan using rumsessiontable_20191124080003_1_kohls_sessionst_strid_trmnlid_ on rumsessiontable_20191124080003_1_kohls b_3 (cost=0.42..8.44 rows=1 width=56) (actual time=0.028..0.028 rows=0 loops=1)

  • Index Cond: ((sessionstarttime >= 186085800) AND (sessionstarttime <= 186089340))
21. 0.017 0.017 ↓ 0.0 0 1

Index Scan using rumsessiontable_20191124080007_kohls_sessionst_strid_trmnlid_id on rumsessiontable_20191124080007_kohls b_4 (cost=0.42..8.44 rows=1 width=57) (actual time=0.017..0.017 rows=0 loops=1)

  • Index Cond: ((sessionstarttime >= 186085800) AND (sessionstarttime <= 186089340))
22. 0.030 0.030 ↓ 0.0 0 1

Index Scan using rumsessiontable_20191124080002_4_kohls_sessionst_strid_trmnlid_ on rumsessiontable_20191124080002_4_kohls b_5 (cost=0.42..8.44 rows=1 width=56) (actual time=0.030..0.030 rows=0 loops=1)

  • Index Cond: ((sessionstarttime >= 186085800) AND (sessionstarttime <= 186089340))
23. 891.640 968.616 ↑ 1.0 50,141 1

Bitmap Heap Scan on rumsessiontable_20191124120003_3_kohls b_6 (cost=1,335.84..23,071.53 rows=51,846 width=55) (actual time=93.268..968.616 rows=50,141 loops=1)

  • Recheck Cond: ((sessionstarttime >= 186085800) AND (sessionstarttime <= 186089340))
  • Heap Blocks: exact=5986
24. 76.976 76.976 ↑ 1.0 50,141 1

Bitmap Index Scan on rumsessiontable_20191124120003_3_kohls_sessionst_strid_trmnlid_ (cost=0.00..1,322.88 rows=51,846 width=0) (actual time=76.976..76.976 rows=50,141 loops=1)

  • Index Cond: ((sessionstarttime >= 186085800) AND (sessionstarttime <= 186089340))
25. 655.761 700.877 ↑ 1.1 35,583 1

Bitmap Heap Scan on rumsessiontable_20191124120003_1_kohls b_7 (cost=983.47..18,350.73 rows=38,151 width=56) (actual time=58.834..700.877 rows=35,583 loops=1)

  • Recheck Cond: ((sessionstarttime >= 186085800) AND (sessionstarttime <= 186089340))
  • Heap Blocks: exact=4632
26. 45.116 45.116 ↑ 1.1 35,583 1

Bitmap Index Scan on rumsessiontable_20191124120003_1_kohls_sessionst_strid_trmnlid_ (cost=0.00..973.93 rows=38,151 width=0) (actual time=45.116..45.116 rows=35,583 loops=1)

  • Index Cond: ((sessionstarttime >= 186085800) AND (sessionstarttime <= 186089340))
27. 620.508 651.208 ↑ 1.0 35,270 1

Bitmap Heap Scan on rumsessiontable_20191124120007_kohls b_8 (cost=949.54..18,257.42 rows=36,792 width=56) (actual time=52.140..651.208 rows=35,270 loops=1)

  • Recheck Cond: ((sessionstarttime >= 186085800) AND (sessionstarttime <= 186089340))
  • Heap Blocks: exact=4482
28. 30.700 30.700 ↑ 1.0 35,270 1

Bitmap Index Scan on rumsessiontable_20191124120007_kohls_sessionst_strid_trmnlid_id (cost=0.00..940.34 rows=36,792 width=0) (actual time=30.700..30.700 rows=35,270 loops=1)

  • Index Cond: ((sessionstarttime >= 186085800) AND (sessionstarttime <= 186089340))
29. 535.885 577.969 ↑ 1.0 32,696 1

Bitmap Heap Scan on rumsessiontable_20191124120002_4_kohls b_9 (cost=883.21..15,597.55 rows=34,223 width=55) (actual time=65.052..577.969 rows=32,696 loops=1)

  • Recheck Cond: ((sessionstarttime >= 186085800) AND (sessionstarttime <= 186089340))
  • Heap Blocks: exact=3934
30. 42.084 42.084 ↑ 1.0 32,696 1

Bitmap Index Scan on rumsessiontable_20191124120002_4_kohls_sessionst_strid_trmnlid_ (cost=0.00..874.65 rows=34,223 width=0) (actual time=42.084..42.084 rows=32,696 loops=1)

  • Index Cond: ((sessionstarttime >= 186085800) AND (sessionstarttime <= 186089340))
31. 0.195 328.890 ↓ 0.0 0 15

Subquery Scan on inq2 (cost=0.00..5,436.16 rows=1 width=36) (actual time=21.926..21.926 rows=0 loops=15)

  • Filter: (a.pageinstance = inq2.pageinstance)
32. 0.495 328.695 ↓ 0.0 0 15

GroupAggregate (cost=0.00..5,436.04 rows=10 width=22) (actual time=21.913..21.913 rows=0 loops=15)

  • Group Key: nveventsrecordtable_11_2019_kohls.sid, nveventsrecordtable_11_2019_kohls.pageinstance
33. 1.680 328.200 ↓ 0.0 0 15

Append (cost=0.00..5,435.79 rows=10 width=22) (actual time=21.880..21.880 rows=0 loops=15)

34. 0.030 0.030 ↓ 0.0 0 15

Seq Scan on nveventsrecordtable_11_2019_kohls (cost=0.00..0.00 rows=1 width=28) (actual time=0.002..0.002 rows=0 loops=15)

  • Filter: (("timestamp" >= 186085800) AND ("timestamp" <= 186089340) AND (sid = a.sid) AND (pageinstance = a.pageinstance))
35. 0.465 0.465 ↓ 0.0 0 15

Index Scan using nveventsrecordtable_20191102024102_3_kohls_ts_sid_pi_idx on nveventsrecordtable_20191102024102_3_kohls (cost=0.15..8.21 rows=1 width=28) (actual time=0.031..0.031 rows=0 loops=15)

  • Index Cond: (("timestamp" >= 186085800) AND ("timestamp" <= 186089340) AND (sid = a.sid) AND (pageinstance = a.pageinstance))
36. 0.390 0.390 ↓ 0.0 0 15

Index Scan using nveventsrecordtable_20191124080003_3_kohls_ts_eventid_idx on nveventsrecordtable_20191124080003_3_kohls (cost=0.42..8.44 rows=1 width=20) (actual time=0.026..0.026 rows=0 loops=15)

  • Index Cond: (("timestamp" >= 186085800) AND ("timestamp" <= 186089340))
  • Filter: ((sid = a.sid) AND (pageinstance = a.pageinstance))
37. 0.285 0.285 ↓ 0.0 0 15

Index Scan using nveventsrecordtable_20191124080003_1_kohls_ts_eventid_idx on nveventsrecordtable_20191124080003_1_kohls (cost=0.42..8.44 rows=1 width=21) (actual time=0.019..0.019 rows=0 loops=15)

  • Index Cond: (("timestamp" >= 186085800) AND ("timestamp" <= 186089340))
  • Filter: ((sid = a.sid) AND (pageinstance = a.pageinstance))
38. 0.405 0.405 ↓ 0.0 0 15

Index Scan using nveventsrecordtable_20191124080007_kohls_ts_eventid_idx on nveventsrecordtable_20191124080007_kohls (cost=0.42..8.44 rows=1 width=21) (actual time=0.027..0.027 rows=0 loops=15)

  • Index Cond: (("timestamp" >= 186085800) AND ("timestamp" <= 186089340))
  • Filter: ((sid = a.sid) AND (pageinstance = a.pageinstance))
39. 0.270 0.270 ↓ 0.0 0 15

Index Scan using nveventsrecordtable_20191124080002_4_kohls_ts_eventid_idx on nveventsrecordtable_20191124080002_4_kohls (cost=0.42..8.44 rows=1 width=20) (actual time=0.018..0.018 rows=0 loops=15)

  • Index Cond: (("timestamp" >= 186085800) AND ("timestamp" <= 186089340))
  • Filter: ((sid = a.sid) AND (pageinstance = a.pageinstance))
40. 83.475 83.475 ↓ 0.0 0 15

Index Scan using nveventsrecordtable_20191124120003_3_kohls_ts_sid_pi_idx on nveventsrecordtable_20191124120003_3_kohls (cost=0.42..1,477.23 rows=1 width=20) (actual time=5.565..5.565 rows=0 loops=15)

  • Index Cond: (("timestamp" >= 186085800) AND ("timestamp" <= 186089340) AND (sid = a.sid) AND (pageinstance = a.pageinstance))
41. 113.295 113.295 ↓ 0.0 0 15

Index Scan using nveventsrecordtable_20191124120003_1_kohls_ts_sid_pi_idx on nveventsrecordtable_20191124120003_1_kohls (cost=0.42..1,462.83 rows=1 width=20) (actual time=7.553..7.553 rows=0 loops=15)

  • Index Cond: (("timestamp" >= 186085800) AND ("timestamp" <= 186089340) AND (sid = a.sid) AND (pageinstance = a.pageinstance))
42. 70.170 70.170 ↓ 0.0 0 15

Index Scan using nveventsrecordtable_20191124120007_kohls_ts_sid_pi_idx on nveventsrecordtable_20191124120007_kohls (cost=0.42..1,443.46 rows=1 width=20) (actual time=4.678..4.678 rows=0 loops=15)

  • Index Cond: (("timestamp" >= 186085800) AND ("timestamp" <= 186089340) AND (sid = a.sid) AND (pageinstance = a.pageinstance))
43. 57.735 57.735 ↓ 0.0 0 15

Index Scan using nveventsrecordtable_20191124120002_4_kohls_ts_sid_pi_idx on nveventsrecordtable_20191124120002_4_kohls (cost=0.42..1,010.28 rows=1 width=21) (actual time=3.849..3.849 rows=0 loops=15)

  • Index Cond: (("timestamp" >= 186085800) AND ("timestamp" <= 186089340) AND (sid = a.sid) AND (pageinstance = a.pageinstance))
Planning time : 5,207.025 ms
Execution time : 4,700.561 ms