explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7mK6

Settings
# exclusive inclusive rows x rows loops node
1. 0.288 70,342.690 ↑ 1.0 15 1

Nested Loop Left Join (cost=2.32..138,172.97 rows=15 width=586) (actual time=15,517.757..70,342.690 rows=15 loops=1)

2. 0.039 69,958.132 ↑ 1.0 15 1

Limit (cost=2.19..56,250.47 rows=15 width=554) (actual time=15,350.113..69,958.132 rows=15 loops=1)

3. 1,066.893 69,958.093 ↑ 94,560.1 15 1

Nested Loop (cost=2.19..5,318,840,842.38 rows=1,418,401 width=554) (actual time=15,350.107..69,958.093 rows=15 loops=1)

  • Join Filter: (a.sid = b.sid)
  • Rows Removed by Join Filter: 3451877
4. 0.073 327.115 ↑ 94,560.1 15 1

Merge Append (cost=2.07..2,528,364.43 rows=1,418,401 width=510) (actual time=173.983..327.115 rows=15 loops=1)

  • Sort Key: a.navigationstarttime DESC
5. 0.021 0.021 ↓ 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.021..0.021 rows=0 loops=1)

  • Index Cond: ((navigationstarttime >= 184876200) AND (navigationstarttime < 184879740))
6. 0.004 0.004 ↓ 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.004..0.004 rows=0 loops=1)

  • Index Cond: ((navigationstarttime >= 184876200) AND (navigationstarttime < 184879740))
7. 198.790 198.790 ↑ 22,745.4 15 1

Index Scan Backward using rumpagetable_20191110063030_kohls_navst_pageid_idx on rumpagetable_20191110063030_kohls a_2 (cost=0.43..598,704.48 rows=341,181 width=509) (actual time=45.718..198.790 rows=15 loops=1)

  • Index Cond: ((navigationstarttime >= 184876200) AND (navigationstarttime < 184879740))
8. 45.719 45.719 ↑ 388,471.0 1 1

Index Scan Backward using rumpagetable_20191110080010_3_kohls_navst_pageid_idx on rumpagetable_20191110080010_3_kohls a_3 (cost=0.43..681,496.45 rows=388,471 width=510) (actual time=45.719..45.719 rows=1 loops=1)

  • Index Cond: ((navigationstarttime >= 184876200) AND (navigationstarttime < 184879740))
9. 52.028 52.028 ↑ 435,213.0 1 1

Index Scan Backward using rumpagetable_20191110080003_1_kohls_navst_pageid_idx on rumpagetable_20191110080003_1_kohls a_4 (cost=0.43..762,967.25 rows=435,213 width=510) (actual time=52.028..52.028 rows=1 loops=1)

  • Index Cond: ((navigationstarttime >= 184876200) AND (navigationstarttime < 184879740))
10. 30.480 30.480 ↑ 253,534.0 1 1

Index Scan Backward using rumpagetable_20191110080002_4_kohls_navst_pageid_idx on rumpagetable_20191110080002_4_kohls a_5 (cost=0.43..444,968.72 rows=253,534 width=511) (actual time=30.480..30.480 rows=1 loops=1)

  • Index Cond: ((navigationstarttime >= 184876200) AND (navigationstarttime < 184879740))
11. 484.714 68,564.085 ↑ 1.1 230,126 15

Materialize (cost=0.12..412,104.78 rows=249,853 width=56) (actual time=2.267..4,570.939 rows=230,126 loops=15)

12. 42.636 68,079.371 ↑ 1.0 242,978 1

Append (cost=0.12..410,855.51 rows=249,853 width=56) (actual time=33.933..68,079.371 rows=242,978 loops=1)

13. 0.037 0.037 ↓ 0.0 0 1

Index Scan using rumsessiontable_11_2019_kohls_sessionst_strid_trmnlid_idx on rumsessiontable_11_2019_kohls b (cost=0.12..8.14 rows=1 width=416) (actual time=0.037..0.037 rows=0 loops=1)

  • Index Cond: ((sessionstarttime >= 184876200) AND (sessionstarttime <= 184879740))
14. 0.018 0.018 ↓ 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.018..0.018 rows=0 loops=1)

  • Index Cond: ((sessionstarttime >= 184876200) AND (sessionstarttime <= 184879740))
15. 15,429.761 15,429.761 ↑ 1.1 63,002 1

Index Scan using rumsessiontable_20191110063030_kohls_sessionst_strid_trmnlid_id on rumsessiontable_20191110063030_kohls b_2 (cost=0.42..109,668.31 rows=66,711 width=56) (actual time=33.867..15,429.761 rows=63,002 loops=1)

  • Index Cond: ((sessionstarttime >= 184876200) AND (sessionstarttime <= 184879740))
16. 16,930.543 16,930.543 ↑ 1.0 65,878 1

Index Scan using rumsessiontable_20191110080010_3_kohls_sessionst_strid_trmnlid_ on rumsessiontable_20191110080010_3_kohls b_3 (cost=0.42..108,325.89 rows=65,880 width=56) (actual time=46.809..16,930.543 rows=65,878 loops=1)

  • Index Cond: ((sessionstarttime >= 184876200) AND (sessionstarttime <= 184879740))
17. 30,930.732 30,930.732 ↑ 1.0 69,947 1

Index Scan using rumsessiontable_20191110080003_1_kohls_sessionst_strid_trmnlid_ on rumsessiontable_20191110080003_1_kohls b_4 (cost=0.42..118,779.67 rows=72,223 width=56) (actual time=41.396..30,930.732 rows=69,947 loops=1)

  • Index Cond: ((sessionstarttime >= 184876200) AND (sessionstarttime <= 184879740))
18. 4,745.644 4,745.644 ↑ 1.0 44,151 1

Index Scan using rumsessiontable_20191110080002_4_kohls_sessionst_strid_trmnlid_ on rumsessiontable_20191110080002_4_kohls b_5 (cost=0.42..74,065.34 rows=45,037 width=56) (actual time=77.424..4,745.644 rows=44,151 loops=1)

  • Index Cond: ((sessionstarttime >= 184876200) AND (sessionstarttime <= 184879740))
19. 0.105 384.270 ↓ 0.0 0 15

Subquery Scan on inq2 (cost=0.12..5,461.48 rows=1 width=36) (actual time=25.618..25.618 rows=0 loops=15)

  • Filter: (a.pageinstance = inq2.pageinstance)
20. 0.255 384.165 ↓ 0.0 0 15

GroupAggregate (cost=0.12..5,461.41 rows=6 width=23) (actual time=25.611..25.611 rows=0 loops=15)

  • Group Key: nveventsrecordtable_11_2019_kohls.sid, nveventsrecordtable_11_2019_kohls.pageinstance
21. 0.870 383.910 ↓ 0.0 0 15

Append (cost=0.12..5,461.26 rows=6 width=23) (actual time=25.594..25.594 rows=0 loops=15)

22. 0.315 0.315 ↓ 0.0 0 15

Index Scan using nveventsrecordtable_11_2019_kohls_ts_eventid_idx on nveventsrecordtable_11_2019_kohls (cost=0.12..8.15 rows=1 width=28) (actual time=0.021..0.021 rows=0 loops=15)

  • Index Cond: (("timestamp" >= 184876200) AND ("timestamp" <= 184879740))
  • Filter: ((sid = a.sid) AND (pageinstance = a.pageinstance))
23. 0.225 0.225 ↓ 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.015..0.015 rows=0 loops=15)

  • Index Cond: (("timestamp" >= 184876200) AND ("timestamp" <= 184879740) AND (sid = a.sid) AND (pageinstance = a.pageinstance))
24. 114.885 114.885 ↓ 0.0 0 15

Index Scan using nveventsrecordtable_20191110063030_kohls_ts_sid_pi_idx on nveventsrecordtable_20191110063030_kohls (cost=0.42..1,885.21 rows=1 width=20) (actual time=7.659..7.659 rows=0 loops=15)

  • Index Cond: (("timestamp" >= 184876200) AND ("timestamp" <= 184879740) AND (sid = a.sid) AND (pageinstance = a.pageinstance))
25. 127.065 127.065 ↓ 0.0 0 15

Index Scan using nveventsrecordtable_20191110080003_1_kohls_ts_sid_pi_idx on nveventsrecordtable_20191110080003_1_kohls (cost=0.42..2,357.39 rows=1 width=21) (actual time=8.471..8.471 rows=0 loops=15)

  • Index Cond: (("timestamp" >= 184876200) AND ("timestamp" <= 184879740) AND (sid = a.sid) AND (pageinstance = a.pageinstance))
26. 22.155 22.155 ↓ 0.0 0 15

Index Scan using nveventsrecordtable_20191110080002_4_kohls_ts_sid_pi_idx on nveventsrecordtable_20191110080002_4_kohls (cost=0.41..55.58 rows=1 width=21) (actual time=1.477..1.477 rows=0 loops=15)

  • Index Cond: (("timestamp" >= 184876200) AND ("timestamp" <= 184879740) AND (sid = a.sid) AND (pageinstance = a.pageinstance))
27. 118.395 118.395 ↓ 0.0 0 15

Index Scan using nveventsrecordtable_20191110080010_3_kohls_ts_sid_pi_idx on nveventsrecordtable_20191110080010_3_kohls (cost=0.42..1,146.73 rows=1 width=21) (actual time=7.893..7.893 rows=0 loops=15)

  • Index Cond: (("timestamp" >= 184876200) AND ("timestamp" <= 184879740) AND (sid = a.sid) AND (pageinstance = a.pageinstance))
Planning time : 7,682.134 ms
Execution time : 70,405.080 ms