explain.depesz.com

PostgreSQL's explain analyze made readable

Result: o9IE

Settings
# exclusive inclusive rows x rows loops node
1. 0.292 5,760.747 ↑ 1.0 15 1

Nested Loop Left Join (cost=2.50..109,967.58 rows=15 width=598) (actual time=521.890..5,760.747 rows=15 loops=1)

2. 0.038 5,537.600 ↑ 1.0 15 1

Limit (cost=2.50..64,578.22 rows=15 width=566) (actual time=432.074..5,537.600 rows=15 loops=1)

3. 1,084.580 5,537.562 ↑ 63,352.6 15 1

Nested Loop (cost=2.50..4,091,039,675.32 rows=950,289 width=566) (actual time=432.071..5,537.562 rows=15 loops=1)

  • Join Filter: (a.sid = b.sid)
  • Rows Removed by Join Filter: 3956954
4. 0.082 258.337 ↑ 63,352.6 15 1

Merge Append (cost=2.50..1,686,680.07 rows=950,289 width=525) (actual time=175.866..258.337 rows=15 loops=1)

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

  • Index Cond: ((navigationstarttime >= 185049000) AND (navigationstarttime < 185052540))
6. 0.008 0.008 ↓ 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.008..0.008 rows=0 loops=1)

  • Index Cond: ((navigationstarttime >= 185049000) AND (navigationstarttime < 185052540))
7. 20.076 20.076 ↑ 479.0 1 1

Index Scan Backward using rumpagetable_20191112050739_1_kohls_navst_pageid_idx on rumpagetable_20191112050739_1_kohls a_2 (cost=0.42..978.33 rows=479 width=538) (actual time=20.076..20.076 rows=1 loops=1)

  • Index Cond: ((navigationstarttime >= 185049000) AND (navigationstarttime < 185052540))
8. 126.633 126.633 ↑ 7,903.8 15 1

Index Scan Backward using rumpagetable_20191112080000_3_kohls_navst_pageid_idx on rumpagetable_20191112080000_3_kohls a_3 (cost=0.42..205,988.33 rows=118,557 width=521) (actual time=44.237..126.633 rows=15 loops=1)

  • Index Cond: ((navigationstarttime >= 185049000) AND (navigationstarttime < 185052540))
9. 40.957 40.957 ↑ 410,830.0 1 1

Index Scan Backward using rumpagetable_20191112080000_1_kohls_navst_pageid_idx on rumpagetable_20191112080000_1_kohls a_4 (cost=0.43..717,123.32 rows=410,830 width=526) (actual time=40.957..40.957 rows=1 loops=1)

  • Index Cond: ((navigationstarttime >= 185049000) AND (navigationstarttime < 185052540))
10. 24.121 24.121 ↑ 343,571.0 1 1

Index Scan Backward using rumpagetable_20191112080000_kohls_navst_pageid_idx on rumpagetable_20191112080000_kohls a_5 (cost=0.43..599,791.91 rows=343,571 width=524) (actual time=24.121..24.121 rows=1 loops=1)

  • Index Cond: ((navigationstarttime >= 185049000) AND (navigationstarttime < 185052540))
11. 46.431 46.431 ↑ 76,850.0 1 1

Index Scan Backward using rumpagetable_20191112080000_4_kohls_navst_pageid_idx on rumpagetable_20191112080000_4_kohls a_6 (cost=0.42..133,728.06 rows=76,850 width=525) (actual time=46.431..46.431 rows=1 loops=1)

  • Index Cond: ((navigationstarttime >= 185049000) AND (navigationstarttime < 185052540))
12. 402.392 4,194.645 ↑ 1.1 263,798 15

Materialize (cost=0.00..153,237.92 rows=286,873 width=54) (actual time=3.626..279.643 rows=263,798 loops=15)

13. 26.239 3,792.253 ↑ 1.0 280,373 1

Append (cost=0.00..151,803.56 rows=286,873 width=54) (actual time=54.359..3,792.253 rows=280,373 loops=1)

14. 0.002 0.002 ↓ 0.0 0 1

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

  • Filter: ((sessionstarttime >= 185049000) AND (sessionstarttime <= 185052540))
15. 0.021 0.021 ↓ 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.021..0.021 rows=0 loops=1)

  • Index Cond: ((sessionstarttime >= 185049000) AND (sessionstarttime <= 185052540))
16. 410.184 439.788 ↑ 1.0 33,193 1

Bitmap Heap Scan on rumsessiontable_20191112080000_3_kohls b_2 (cost=884.37..20,800.87 rows=34,337 width=54) (actual time=54.336..439.788 rows=33,193 loops=1)

  • Recheck Cond: ((sessionstarttime >= 185049000) AND (sessionstarttime <= 185052540))
  • Heap Blocks: exact=3702
17. 29.604 29.604 ↑ 1.0 33,193 1

Bitmap Index Scan on rumsessiontable_20191112080000_3_kohls_sessionst_strid_trmnlid_ (cost=0.00..875.79 rows=34,337 width=0) (actual time=29.604..29.604 rows=33,193 loops=1)

  • Index Cond: ((sessionstarttime >= 185049000) AND (sessionstarttime <= 185052540))
18. 1,781.961 1,843.434 ↑ 1.1 117,473 1

Bitmap Heap Scan on rumsessiontable_20191112080000_1_kohls b_3 (cost=3,181.14..63,263.79 rows=123,777 width=54) (actual time=91.047..1,843.434 rows=117,473 loops=1)

  • Recheck Cond: ((sessionstarttime >= 185049000) AND (sessionstarttime <= 185052540))
  • Heap Blocks: exact=12701
19. 61.473 61.473 ↑ 1.1 117,473 1

Bitmap Index Scan on rumsessiontable_20191112080000_1_kohls_sessionst_strid_trmnlid_ (cost=0.00..3,150.20 rows=123,777 width=0) (actual time=61.473..61.473 rows=117,473 loops=1)

  • Index Cond: ((sessionstarttime >= 185049000) AND (sessionstarttime <= 185052540))
20. 1,120.583 1,183.776 ↓ 1.0 108,181 1

Bitmap Heap Scan on rumsessiontable_20191112080000_kohls b_4 (cost=2,735.59..54,034.41 rows=106,455 width=54) (actual time=101.755..1,183.776 rows=108,181 loops=1)

  • Recheck Cond: ((sessionstarttime >= 185049000) AND (sessionstarttime <= 185052540))
  • Heap Blocks: exact=11429
21. 63.193 63.193 ↓ 1.0 108,181 1

Bitmap Index Scan on rumsessiontable_20191112080000_kohls_sessionst_strid_trmnlid_id (cost=0.00..2,708.98 rows=106,455 width=0) (actual time=63.193..63.193 rows=108,181 loops=1)

  • Index Cond: ((sessionstarttime >= 185049000) AND (sessionstarttime <= 185052540))
22. 268.465 298.993 ↑ 1.0 21,526 1

Bitmap Heap Scan on rumsessiontable_20191112080000_4_kohls b_5 (cost=577.02..13,696.32 rows=22,302 width=54) (actual time=50.009..298.993 rows=21,526 loops=1)

  • Recheck Cond: ((sessionstarttime >= 185049000) AND (sessionstarttime <= 185052540))
  • Heap Blocks: exact=2421
23. 30.528 30.528 ↑ 1.0 21,526 1

Bitmap Index Scan on rumsessiontable_20191112080000_4_kohls_sessionst_strid_trmnlid_ (cost=0.00..571.44 rows=22,302 width=0) (actual time=30.528..30.528 rows=21,526 loops=1)

  • Index Cond: ((sessionstarttime >= 185049000) AND (sessionstarttime <= 185052540))
24. 0.105 222.855 ↓ 0.0 0 15

Subquery Scan on inq2 (cost=0.00..3,025.94 rows=1 width=36) (actual time=14.857..14.857 rows=0 loops=15)

  • Filter: (a.pageinstance = inq2.pageinstance)
25. 0.180 222.750 ↓ 0.0 0 15

GroupAggregate (cost=0.00..3,025.86 rows=6 width=23) (actual time=14.850..14.850 rows=0 loops=15)

  • Group Key: nveventsrecordtable_11_2019_kohls.sid, nveventsrecordtable_11_2019_kohls.pageinstance
26. 0.915 222.570 ↓ 0.0 0 15

Append (cost=0.00..3,025.71 rows=6 width=23) (actual time=14.838..14.838 rows=0 loops=15)

27. 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" >= 185049000) AND ("timestamp" <= 185052540) AND (sid = a.sid) AND (pageinstance = a.pageinstance))
28. 0.315 0.315 ↓ 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.021..0.021 rows=0 loops=15)

  • Index Cond: (("timestamp" >= 185049000) AND ("timestamp" <= 185052540) AND (sid = a.sid) AND (pageinstance = a.pageinstance))
29. 22.590 22.590 ↓ 0.0 0 15

Index Scan using nveventsrecordtable_20191112080000_1_kohls_ts_sid_pi_idx on nveventsrecordtable_20191112080000_1_kohls (cost=0.42..28.10 rows=1 width=20) (actual time=1.506..1.506 rows=0 loops=15)

  • Index Cond: (("timestamp" >= 185049000) AND ("timestamp" <= 185052540) AND (sid = a.sid) AND (pageinstance = a.pageinstance))
30. 121.860 121.860 ↓ 0.0 0 15

Index Scan using nveventsrecordtable_20191112080000_kohls_ts_sid_pi_idx on nveventsrecordtable_20191112080000_kohls (cost=0.42..1,918.08 rows=1 width=20) (actual time=8.124..8.124 rows=0 loops=15)

  • Index Cond: (("timestamp" >= 185049000) AND ("timestamp" <= 185052540) AND (sid = a.sid) AND (pageinstance = a.pageinstance))
31. 41.205 41.205 ↓ 0.0 0 15

Index Scan using nveventsrecordtable_20191112080000_4_kohls_ts_sid_pi_idx on nveventsrecordtable_20191112080000_4_kohls (cost=0.42..493.99 rows=1 width=21) (actual time=2.747..2.747 rows=0 loops=15)

  • Index Cond: (("timestamp" >= 185049000) AND ("timestamp" <= 185052540) AND (sid = a.sid) AND (pageinstance = a.pageinstance))
32. 35.670 35.670 ↓ 0.0 0 15

Index Scan using nveventsrecordtable_20191112080000_3_kohls_ts_sid_pi_idx on nveventsrecordtable_20191112080000_3_kohls (cost=0.42..577.34 rows=1 width=20) (actual time=2.378..2.378 rows=0 loops=15)

  • Index Cond: (("timestamp" >= 185049000) AND ("timestamp" <= 185052540) AND (sid = a.sid) AND (pageinstance = a.pageinstance))
Planning time : 4,335.029 ms
Execution time : 5,827.502 ms