explain.depesz.com

PostgreSQL's explain analyze made readable

Result: d2E7

Settings
# exclusive inclusive rows x rows loops node
1. 0.181 3,775.794 ↑ 1.0 15 1

Nested Loop Left Join (cost=2.06..70,258.15 rows=15 width=592) (actual time=845.629..3,775.794 rows=15 loops=1)

2. 0.024 3,610.178 ↑ 1.0 15 1

Limit (cost=2.06..38,646.97 rows=15 width=560) (actual time=758.625..3,610.178 rows=15 loops=1)

3. 667.796 3,610.154 ↑ 51,531.1 15 1

Nested Loop (cost=2.06..1,991,413,526.18 rows=772,966 width=560) (actual time=758.622..3,610.154 rows=15 loops=1)

  • Join Filter: (a.sid = b.sid)
  • Rows Removed by Join Filter: 2337948
4. 0.096 282.243 ↑ 51,531.1 15 1

Merge Append (cost=2.06..1,366,315.56 rows=772,966 width=518) (actual time=172.814..282.243 rows=15 loops=1)

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

  • Index Cond: ((navigationstarttime >= 185221800) AND (navigationstarttime < 185225340))
6. 0.006 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Index Cond: ((navigationstarttime >= 185221800) AND (navigationstarttime < 185225340))
7. 162.894 162.894 ↑ 22,874.1 15 1

Index Scan Backward using rumpagetable_20191114065127_1_kohls_navst_pageid_idx on rumpagetable_20191114065127_1_kohls a_2 (cost=0.43..596,420.56 rows=343,112 width=518) (actual time=53.555..162.894 rows=15 loops=1)

  • Index Cond: ((navigationstarttime >= 185221800) AND (navigationstarttime < 185225340))
8. 45.487 45.487 ↑ 281,135.0 1 1

Index Scan Backward using rumpagetable_20191114072647_kohls_navst_pageid_idx on rumpagetable_20191114072647_kohls a_3 (cost=0.43..489,434.26 rows=281,135 width=518) (actual time=45.487..45.487 rows=1 loops=1)

  • Index Cond: ((navigationstarttime >= 185221800) AND (navigationstarttime < 185225340))
9. 35.913 35.913 ↑ 87,490.0 1 1

Index Scan Backward using rumpagetable_20191114080002_3_kohls_navst_pageid_idx on rumpagetable_20191114080002_3_kohls a_4 (cost=0.42..152,091.37 rows=87,490 width=519) (actual time=35.913..35.913 rows=1 loops=1)

  • Index Cond: ((navigationstarttime >= 185221800) AND (navigationstarttime < 185225340))
10. 37.834 37.834 ↑ 61,227.0 1 1

Index Scan Backward using rumpagetable_20191114080001_4_kohls_navst_pageid_idx on rumpagetable_20191114080001_4_kohls a_5 (cost=0.42..106,439.69 rows=61,227 width=516) (actual time=37.834..37.834 rows=1 loops=1)

  • Index Cond: ((navigationstarttime >= 185221800) AND (navigationstarttime < 185225340))
11. 233.810 2,660.115 ↑ 1.1 155,864 15

Materialize (cost=0.00..141,361.01 rows=171,624 width=55) (actual time=4.193..177.341 rows=155,864 loops=15)

12. 16.238 2,426.305 ↑ 1.1 161,831 1

Append (cost=0.00..140,502.89 rows=171,624 width=55) (actual time=62.858..2,426.305 rows=161,831 loops=1)

13. 0.001 0.001 ↓ 0.0 0 1

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

  • Filter: ((sessionstarttime >= 185221800) AND (sessionstarttime <= 185225340))
14. 0.015 0.015 ↓ 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.015..0.015 rows=0 loops=1)

  • Index Cond: ((sessionstarttime >= 185221800) AND (sessionstarttime <= 185225340))
15. 861.401 900.828 ↑ 1.1 73,668 1

Bitmap Heap Scan on rumsessiontable_20191114065127_1_kohls b_2 (cost=2,048.95..60,437.72 rows=79,661 width=55) (actual time=62.841..900.828 rows=73,668 loops=1)

  • Recheck Cond: ((sessionstarttime >= 185221800) AND (sessionstarttime <= 185225340))
  • Heap Blocks: exact=8785
16. 39.427 39.427 ↑ 1.1 73,668 1

Bitmap Index Scan on rumsessiontable_20191114065127_1_kohls_sessionst_strid_trmnlid_ (cost=0.00..2,029.04 rows=79,661 width=0) (actual time=39.427..39.427 rows=73,668 loops=1)

  • Index Cond: ((sessionstarttime >= 185221800) AND (sessionstarttime <= 185225340))
17. 896.537 938.873 ↑ 1.0 61,727 1

Bitmap Heap Scan on rumsessiontable_20191114072647_kohls b_3 (cost=1,643.79..54,741.92 rows=63,938 width=54) (actual time=69.604..938.873 rows=61,727 loops=1)

  • Recheck Cond: ((sessionstarttime >= 185221800) AND (sessionstarttime <= 185225340))
  • Heap Blocks: exact=7270
18. 42.336 42.336 ↑ 1.0 61,727 1

Bitmap Index Scan on rumsessiontable_20191114072647_kohls_sessionst_strid_trmnlid_id (cost=0.00..1,627.81 rows=63,938 width=0) (actual time=42.336..42.336 rows=61,727 loops=1)

  • Index Cond: ((sessionstarttime >= 185221800) AND (sessionstarttime <= 185225340))
19. 321.702 355.618 ↑ 1.1 16,079 1

Bitmap Heap Scan on rumsessiontable_20191114080002_3_kohls b_4 (cost=437.93..15,120.83 rows=16,928 width=55) (actual time=52.635..355.618 rows=16,079 loops=1)

  • Recheck Cond: ((sessionstarttime >= 185221800) AND (sessionstarttime <= 185225340))
  • Heap Blocks: exact=2026
20. 33.916 33.916 ↑ 1.1 16,079 1

Bitmap Index Scan on rumsessiontable_20191114080002_3_kohls_sessionst_strid_trmnlid_ (cost=0.00..433.70 rows=16,928 width=0) (actual time=33.916..33.916 rows=16,079 loops=1)

  • Index Cond: ((sessionstarttime >= 185221800) AND (sessionstarttime <= 185225340))
21. 194.449 214.732 ↑ 1.1 10,357 1

Bitmap Heap Scan on rumsessiontable_20191114080001_4_kohls b_5 (cost=290.14..10,194.25 rows=11,095 width=55) (actual time=41.866..214.732 rows=10,357 loops=1)

  • Recheck Cond: ((sessionstarttime >= 185221800) AND (sessionstarttime <= 185225340))
  • Heap Blocks: exact=1345
22. 20.283 20.283 ↑ 1.1 10,357 1

Bitmap Index Scan on rumsessiontable_20191114080001_4_kohls_sessionst_strid_trmnlid_ (cost=0.00..287.37 rows=11,095 width=0) (actual time=20.283..20.283 rows=10,357 loops=1)

  • Index Cond: ((sessionstarttime >= 185221800) AND (sessionstarttime <= 185225340))
23. 0.060 165.435 ↓ 0.0 0 15

Subquery Scan on inq2 (cost=0.00..2,107.39 rows=1 width=36) (actual time=11.029..11.029 rows=0 loops=15)

  • Filter: (a.pageinstance = inq2.pageinstance)
24. 0.165 165.375 ↓ 0.0 0 15

GroupAggregate (cost=0.00..2,107.32 rows=6 width=23) (actual time=11.025..11.025 rows=0 loops=15)

  • Group Key: nveventsrecordtable_11_2019_kohls.sid, nveventsrecordtable_11_2019_kohls.pageinstance
25. 0.495 165.210 ↓ 0.0 0 15

Append (cost=0.00..2,107.17 rows=6 width=23) (actual time=11.014..11.014 rows=0 loops=15)

26. 0.015 0.015 ↓ 0.0 0 15

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

  • Filter: (("timestamp" >= 185221800) AND ("timestamp" <= 185225340) AND (sid = a.sid) AND (pageinstance = a.pageinstance))
27. 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" >= 185221800) AND ("timestamp" <= 185225340) AND (sid = a.sid) AND (pageinstance = a.pageinstance))
28. 22.710 22.710 ↓ 0.0 0 15

Index Scan using nveventsrecordtable_20191114065127_1_kohls_ts_sid_pi_idx on nveventsrecordtable_20191114065127_1_kohls (cost=0.41..10.09 rows=1 width=21) (actual time=1.514..1.514 rows=0 loops=15)

  • Index Cond: (("timestamp" >= 185221800) AND ("timestamp" <= 185225340) AND (sid = a.sid) AND (pageinstance = a.pageinstance))
29. 92.295 92.295 ↓ 0.0 0 15

Index Scan using nveventsrecordtable_20191114072647_kohls_ts_sid_pi_idx on nveventsrecordtable_20191114072647_kohls (cost=0.42..1,541.43 rows=1 width=20) (actual time=6.153..6.153 rows=0 loops=15)

  • Index Cond: (("timestamp" >= 185221800) AND ("timestamp" <= 185225340) AND (sid = a.sid) AND (pageinstance = a.pageinstance))
30. 36.510 36.510 ↓ 0.0 0 15

Index Scan using nveventsrecordtable_20191114080002_3_kohls_ts_sid_pi_idx on nveventsrecordtable_20191114080002_3_kohls (cost=0.42..538.15 rows=1 width=20) (actual time=2.434..2.434 rows=0 loops=15)

  • Index Cond: (("timestamp" >= 185221800) AND ("timestamp" <= 185225340) AND (sid = a.sid) AND (pageinstance = a.pageinstance))
31. 12.960 12.960 ↓ 0.0 0 15

Index Scan using nveventsrecordtable_20191114080001_4_kohls_ts_sid_pi_idx on nveventsrecordtable_20191114080001_4_kohls (cost=0.41..9.29 rows=1 width=21) (actual time=0.864..0.864 rows=0 loops=15)

  • Index Cond: (("timestamp" >= 185221800) AND ("timestamp" <= 185225340) AND (sid = a.sid) AND (pageinstance = a.pageinstance))
Planning time : 2,683.836 ms
Execution time : 3,814.598 ms