explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 0cmh

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Sort (cost=1,194,689.35..1,201,886.74 rows=2,878,956 width=668) (actual rows= loops=)

  • Sort Key: rumsessiontable_11_2019_kohls.sessionstarttime DESC
2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=13,550.77..29,722.41 rows=2,878,956 width=668) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

HashAggregate (cost=13,550.77..13,552.77 rows=200 width=12) (actual rows= loops=)

  • Group Key: nveventsrecordtable_11_2019_kohls.sid
4. 0.000 0.000 ↓ 0.0

Append (cost=0.00..13,539.86 rows=4,363 width=12) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Seq Scan on nveventsrecordtable_11_2019_kohls (cost=0.00..0.00 rows=1 width=20) (actual rows= loops=)

  • Filter: (("timestamp" >= 184050000) AND ("timestamp" <= 184143540) AND (eventid = 131))
6. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on nveventsrecordtable_20191101000558_kohls (cost=11.09..1,003.34 rows=344 width=13) (actual rows= loops=)

  • Recheck Cond: (eventid = 131)
  • Filter: (("timestamp" >= 184050000) AND ("timestamp" <= 184143540))
7. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on nveventsrecordtable_20191101000558_kohls_eventid_idx (cost=0.00..11.00 rows=344 width=0) (actual rows= loops=)

  • Index Cond: (eventid = 131)
8. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on nveventsrecordtable_20191101000641_3_kohls (cost=4.17..11.30 rows=1 width=20) (actual rows= loops=)

  • Recheck Cond: (eventid = 131)
  • Filter: (("timestamp" >= 184050000) AND ("timestamp" <= 184143540))
9. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on nveventsrecordtable_20191101000641_3_kohls_eventid_idx (cost=0.00..4.17 rows=3 width=0) (actual rows= loops=)

  • Index Cond: (eventid = 131)
10. 0.000 0.000 ↓ 0.0

Seq Scan on nveventsrecordtable_20191101000312_1_kohls (cost=0.00..1.33 rows=1 width=13) (actual rows= loops=)

  • Filter: (("timestamp" >= 184050000) AND ("timestamp" <= 184143540) AND (eventid = 131))
11. 0.000 0.000 ↓ 0.0

Seq Scan on nveventsrecordtable_20191101000355_1_kohls (cost=0.00..1.21 rows=1 width=13) (actual rows= loops=)

  • Filter: (("timestamp" >= 184050000) AND ("timestamp" <= 184143540) AND (eventid = 131))
12. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on nveventsrecordtable_20191101000433_1_kohls (cost=16.79..1,600.38 rows=564 width=13) (actual rows= loops=)

  • Recheck Cond: (eventid = 131)
  • Filter: (("timestamp" >= 184050000) AND ("timestamp" <= 184143540))
13. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on nveventsrecordtable_20191101000433_1_kohls_eventid_idx (cost=0.00..16.65 rows=564 width=0) (actual rows= loops=)

  • Index Cond: (eventid = 131)
14. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on nveventsrecordtable_20191101003219_3_kohls (cost=4.17..11.30 rows=1 width=20) (actual rows= loops=)

  • Recheck Cond: (eventid = 131)
  • Filter: (("timestamp" >= 184050000) AND ("timestamp" <= 184143540))
15. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on nveventsrecordtable_20191101003219_3_kohls_eventid_idx (cost=0.00..4.17 rows=3 width=0) (actual rows= loops=)

  • Index Cond: (eventid = 131)
16. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on nveventsrecordtable_20191101000000_3_kohls (cost=4.17..11.30 rows=1 width=20) (actual rows= loops=)

  • Recheck Cond: (eventid = 131)
  • Filter: (("timestamp" >= 184050000) AND ("timestamp" <= 184143540))
17. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on nveventsrecordtable_20191101000000_3_kohls_eventid_idx (cost=0.00..4.17 rows=3 width=0) (actual rows= loops=)

  • Index Cond: (eventid = 131)
18. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on nveventsrecordtable_20191101000050_3_kohls (cost=4.17..11.30 rows=1 width=20) (actual rows= loops=)

  • Recheck Cond: (eventid = 131)
  • Filter: (("timestamp" >= 184050000) AND ("timestamp" <= 184143540))
19. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on nveventsrecordtable_20191101000050_3_kohls_eventid_idx (cost=0.00..4.17 rows=3 width=0) (actual rows= loops=)

  • Index Cond: (eventid = 131)
20. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on nveventsrecordtable_20191101000153_3_kohls (cost=4.17..11.30 rows=1 width=20) (actual rows= loops=)

  • Recheck Cond: (eventid = 131)
  • Filter: (("timestamp" >= 184050000) AND ("timestamp" <= 184143540))
21. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on nveventsrecordtable_20191101000153_3_kohls_eventid_idx (cost=0.00..4.17 rows=3 width=0) (actual rows= loops=)

  • Index Cond: (eventid = 131)
22. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on nveventsrecordtable_20191101000337_3_kohls (cost=4.17..11.30 rows=1 width=20) (actual rows= loops=)

  • Recheck Cond: (eventid = 131)
  • Filter: (("timestamp" >= 184050000) AND ("timestamp" <= 184143540))
23. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on nveventsrecordtable_20191101000337_3_kohls_eventid_idx (cost=0.00..4.17 rows=3 width=0) (actual rows= loops=)

  • Index Cond: (eventid = 131)
24. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on nveventsrecordtable_20191101000450_3_kohls (cost=4.17..11.30 rows=1 width=20) (actual rows= loops=)

  • Recheck Cond: (eventid = 131)
  • Filter: (("timestamp" >= 184050000) AND ("timestamp" <= 184143540))
25. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on nveventsrecordtable_20191101000450_3_kohls_eventid_idx (cost=0.00..4.17 rows=3 width=0) (actual rows= loops=)

  • Index Cond: (eventid = 131)
26. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on nveventsrecordtable_20191101000553_3_kohls (cost=4.17..11.30 rows=1 width=20) (actual rows= loops=)

  • Recheck Cond: (eventid = 131)
  • Filter: (("timestamp" >= 184050000) AND ("timestamp" <= 184143540))
27. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on nveventsrecordtable_20191101000553_3_kohls_eventid_idx (cost=0.00..4.17 rows=3 width=0) (actual rows= loops=)

  • Index Cond: (eventid = 131)
28. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on nveventsrecordtable_20191101000727_3_kohls (cost=4.17..11.30 rows=1 width=20) (actual rows= loops=)

  • Recheck Cond: (eventid = 131)
  • Filter: (("timestamp" >= 184050000) AND ("timestamp" <= 184143540))
29. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on nveventsrecordtable_20191101000727_3_kohls_eventid_idx (cost=0.00..4.17 rows=3 width=0) (actual rows= loops=)

  • Index Cond: (eventid = 131)
30. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on nveventsrecordtable_20191101000830_3_kohls (cost=4.17..11.30 rows=1 width=20) (actual rows= loops=)

  • Recheck Cond: (eventid = 131)
  • Filter: (("timestamp" >= 184050000) AND ("timestamp" <= 184143540))
31. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on nveventsrecordtable_20191101000830_3_kohls_eventid_idx (cost=0.00..4.17 rows=3 width=0) (actual rows= loops=)

  • Index Cond: (eventid = 131)
32. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on nveventsrecordtable_20191101000933_3_kohls (cost=4.17..11.30 rows=1 width=20) (actual rows= loops=)

  • Recheck Cond: (eventid = 131)
  • Filter: (("timestamp" >= 184050000) AND ("timestamp" <= 184143540))
33. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on nveventsrecordtable_20191101000933_3_kohls_eventid_idx (cost=0.00..4.17 rows=3 width=0) (actual rows= loops=)

  • Index Cond: (eventid = 131)
34. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on nveventsrecordtable_20191101001107_3_kohls (cost=4.17..11.30 rows=1 width=20) (actual rows= loops=)

  • Recheck Cond: (eventid = 131)
  • Filter: (("timestamp" >= 184050000) AND ("timestamp" <= 184143540))
35. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on nveventsrecordtable_20191101001107_3_kohls_eventid_idx (cost=0.00..4.17 rows=3 width=0) (actual rows= loops=)

  • Index Cond: (eventid = 131)
36. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on nveventsrecordtable_20191101001208_3_kohls (cost=4.17..11.30 rows=1 width=20) (actual rows= loops=)

  • Recheck Cond: (eventid = 131)
  • Filter: (("timestamp" >= 184050000) AND ("timestamp" <= 184143540))
37. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on nveventsrecordtable_20191101001208_3_kohls_eventid_idx (cost=0.00..4.17 rows=3 width=0) (actual rows= loops=)

  • Index Cond: (eventid = 131)
38. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on nveventsrecordtable_20191101002302_3_kohls (cost=4.17..11.30 rows=1 width=20) (actual rows= loops=)

  • Recheck Cond: (eventid = 131)
  • Filter: (("timestamp" >= 184050000) AND ("timestamp" <= 184143540))
39. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on nveventsrecordtable_20191101002302_3_kohls_eventid_idx (cost=0.00..4.17 rows=3 width=0) (actual rows= loops=)

  • Index Cond: (eventid = 131)
40. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on nveventsrecordtable_20191101002828_3_kohls (cost=4.17..11.30 rows=1 width=20) (actual rows= loops=)

  • Recheck Cond: (eventid = 131)
  • Filter: (("timestamp" >= 184050000) AND ("timestamp" <= 184143540))
41. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on nveventsrecordtable_20191101002828_3_kohls_eventid_idx (cost=0.00..4.17 rows=3 width=0) (actual rows= loops=)

  • Index Cond: (eventid = 131)
42. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on nveventsrecordtable_20191101003821_3_kohls (cost=4.17..11.30 rows=1 width=20) (actual rows= loops=)

  • Recheck Cond: (eventid = 131)
  • Filter: (("timestamp" >= 184050000) AND ("timestamp" <= 184143540))
43. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on nveventsrecordtable_20191101003821_3_kohls_eventid_idx (cost=0.00..4.17 rows=3 width=0) (actual rows= loops=)

  • Index Cond: (eventid = 131)
44. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on nveventsrecordtable_20191101005424_3_kohls (cost=4.17..11.30 rows=1 width=20) (actual rows= loops=)

  • Recheck Cond: (eventid = 131)
  • Filter: (("timestamp" >= 184050000) AND ("timestamp" <= 184143540))
45. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on nveventsrecordtable_20191101005424_3_kohls_eventid_idx (cost=0.00..4.17 rows=3 width=0) (actual rows= loops=)

  • Index Cond: (eventid = 131)
46. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on nveventsrecordtable_20191101010035_3_kohls (cost=4.17..11.30 rows=1 width=20) (actual rows= loops=)

  • Recheck Cond: (eventid = 131)
  • Filter: (("timestamp" >= 184050000) AND ("timestamp" <= 184143540))
47. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on nveventsrecordtable_20191101010035_3_kohls_eventid_idx (cost=0.00..4.17 rows=3 width=0) (actual rows= loops=)

  • Index Cond: (eventid = 131)
48. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on nveventsrecordtable_20191101010223_3_kohls (cost=4.17..11.30 rows=1 width=20) (actual rows= loops=)

  • Recheck Cond: (eventid = 131)
  • Filter: (("timestamp" >= 184050000) AND ("timestamp" <= 184143540))
49. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on nveventsrecordtable_20191101010223_3_kohls_eventid_idx (cost=0.00..4.17 rows=3 width=0) (actual rows= loops=)

  • Index Cond: (eventid = 131)
50. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on nveventsrecordtable_20191101051117_3_kohls (cost=4.17..11.30 rows=1 width=20) (actual rows= loops=)

  • Recheck Cond: (eventid = 131)
  • Filter: (("timestamp" >= 184050000) AND ("timestamp" <= 184143540))
51. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on nveventsrecordtable_20191101051117_3_kohls_eventid_idx (cost=0.00..4.17 rows=3 width=0) (actual rows= loops=)

  • Index Cond: (eventid = 131)
52. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on nveventsrecordtable_20191101080000_kohls (cost=5.68..535.18 rows=179 width=13) (actual rows= loops=)

  • Recheck Cond: (eventid = 131)
  • Filter: (("timestamp" >= 184050000) AND ("timestamp" <= 184143540))
53. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on nveventsrecordtable_20191101080000_kohls_eventid_idx (cost=0.00..5.64 rows=179 width=0) (actual rows= loops=)

  • Index Cond: (eventid = 131)
54. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on nveventsrecordtable_20191101080000_3_kohls (cost=4.17..11.30 rows=1 width=20) (actual rows= loops=)

  • Recheck Cond: (eventid = 131)
  • Filter: (("timestamp" >= 184050000) AND ("timestamp" <= 184143540))
55. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on nveventsrecordtable_20191101080000_3_kohls_eventid_idx (cost=0.00..4.17 rows=3 width=0) (actual rows= loops=)

  • Index Cond: (eventid = 131)
56. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on nveventsrecordtable_20191101080000_1_kohls (cost=5.83..561.51 rows=199 width=12) (actual rows= loops=)

  • Recheck Cond: (eventid = 131)
  • Filter: (("timestamp" >= 184050000) AND ("timestamp" <= 184143540))
57. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on nveventsrecordtable_20191101080000_1_kohls_eventid_idx (cost=0.00..5.79 rows=199 width=0) (actual rows= loops=)

  • Index Cond: (eventid = 131)
58. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on nveventsrecordtable_20191101092141_3_kohls (cost=4.17..11.30 rows=1 width=20) (actual rows= loops=)

  • Recheck Cond: (eventid = 131)
  • Filter: (("timestamp" >= 184050000) AND ("timestamp" <= 184143540))
59. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on nveventsrecordtable_20191101092141_3_kohls_eventid_idx (cost=0.00..4.17 rows=3 width=0) (actual rows= loops=)

  • Index Cond: (eventid = 131)
60. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on nveventsrecordtable_20191101091117_3_kohls (cost=4.17..11.30 rows=1 width=20) (actual rows= loops=)

  • Recheck Cond: (eventid = 131)
  • Filter: (("timestamp" >= 184050000) AND ("timestamp" <= 184143540))
61. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on nveventsrecordtable_20191101091117_3_kohls_eventid_idx (cost=0.00..4.17 rows=3 width=0) (actual rows= loops=)

  • Index Cond: (eventid = 131)
62. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on nveventsrecordtable_20191101091749_1_kohls (cost=15.05..1,119.49 rows=339 width=12) (actual rows= loops=)

  • Recheck Cond: (eventid = 131)
  • Filter: (("timestamp" >= 184050000) AND ("timestamp" <= 184143540))
63. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on nveventsrecordtable_20191101091749_1_kohls_eventid_idx (cost=0.00..14.96 rows=339 width=0) (actual rows= loops=)

  • Index Cond: (eventid = 131)
64. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on nveventsrecordtable_20191101092007_kohls (cost=17.44..1,991.52 rows=648 width=12) (actual rows= loops=)

  • Recheck Cond: (eventid = 131)
  • Filter: (("timestamp" >= 184050000) AND ("timestamp" <= 184143540))
65. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on nveventsrecordtable_20191101092007_kohls_eventid_idx (cost=0.00..17.28 rows=648 width=0) (actual rows= loops=)

  • Index Cond: (eventid = 131)
66. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on nveventsrecordtable_20191101110602_1_kohls (cost=9.74..561.19 rows=171 width=12) (actual rows= loops=)

  • Recheck Cond: (eventid = 131)
  • Filter: (("timestamp" >= 184050000) AND ("timestamp" <= 184143540))
67. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on nveventsrecordtable_20191101110602_1_kohls_eventid_idx (cost=0.00..9.70 rows=171 width=0) (actual rows= loops=)

  • Index Cond: (eventid = 131)
68. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on nveventsrecordtable_20191101114534_1_kohls (cost=4.67..151.46 rows=49 width=13) (actual rows= loops=)

  • Recheck Cond: (eventid = 131)
  • Filter: (("timestamp" >= 184050000) AND ("timestamp" <= 184143540))
69. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on nveventsrecordtable_20191101114534_1_kohls_eventid_idx (cost=0.00..4.65 rows=49 width=0) (actual rows= loops=)

  • Index Cond: (eventid = 131)
70. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on nveventsrecordtable_20191101115516_1_kohls (cost=4.57..123.45 rows=37 width=13) (actual rows= loops=)

  • Recheck Cond: (eventid = 131)
  • Filter: (("timestamp" >= 184050000) AND ("timestamp" <= 184143540))
71. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on nveventsrecordtable_20191101115516_1_kohls_eventid_idx (cost=0.00..4.56 rows=37 width=0) (actual rows= loops=)

  • Index Cond: (eventid = 131)
72. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on nveventsrecordtable_20191101122358_1_kohls (cost=16.93..1,796.92 rows=582 width=12) (actual rows= loops=)

  • Recheck Cond: (eventid = 131)
  • Filter: (("timestamp" >= 184050000) AND ("timestamp" <= 184143540))
73. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on nveventsrecordtable_20191101122358_1_kohls_eventid_idx (cost=0.00..16.79 rows=582 width=0) (actual rows= loops=)

  • Index Cond: (eventid = 131)
74. 0.000 0.000 ↓ 0.0

Index Scan using nveventsrecordtable_20191101160000_kohls_eventid_idx on nveventsrecordtable_20191101160000_kohls (cost=0.42..8.44 rows=1 width=12) (actual rows= loops=)

  • Index Cond: (eventid = 131)
  • Filter: (("timestamp" >= 184050000) AND ("timestamp" <= 184143540))
75. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on nveventsrecordtable_20191101160000_1_kohls (cost=17.06..1,844.89 rows=599 width=12) (actual rows= loops=)

  • Recheck Cond: (eventid = 131)
  • Filter: (("timestamp" >= 184050000) AND ("timestamp" <= 184143540))
76. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on nveventsrecordtable_20191101160000_1_kohls_eventid_idx (cost=0.00..16.91 rows=599 width=0) (actual rows= loops=)

  • Index Cond: (eventid = 131)
77. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on nveventsrecordtable_20191101203832_1_kohls (cost=12.13..1,485.20 rows=476 width=12) (actual rows= loops=)

  • Recheck Cond: (eventid = 131)
  • Filter: (("timestamp" >= 184050000) AND ("timestamp" <= 184143540))
78. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on nveventsrecordtable_20191101203832_1_kohls_eventid_idx (cost=0.00..12.01 rows=478 width=0) (actual rows= loops=)

  • Index Cond: (eventid = 131)
79. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on nveventsrecordtable_20191102000002_kohls (cost=5.00..267.94 rows=79 width=13) (actual rows= loops=)

  • Recheck Cond: (eventid = 131)
  • Filter: (("timestamp" >= 184050000) AND ("timestamp" <= 184143540))
80. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on nveventsrecordtable_20191102000002_kohls_eventid_idx (cost=0.00..4.98 rows=92 width=0) (actual rows= loops=)

  • Index Cond: (eventid = 131)
81. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on nveventsrecordtable_20191102000000_1_kohls (cost=4.87..226.62 rows=70 width=12) (actual rows= loops=)

  • Recheck Cond: (eventid = 131)
  • Filter: (("timestamp" >= 184050000) AND ("timestamp" <= 184143540))
82. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on nveventsrecordtable_20191102000000_1_kohls_eventid_idx (cost=0.00..4.85 rows=75 width=0) (actual rows= loops=)

  • Index Cond: (eventid = 131)
83. 0.000 0.000 ↓ 0.0

Append (cost=0.00..80.44 rows=41 width=1,261) (actual rows= loops=)

84. 0.000 0.000 ↓ 0.0

Seq Scan on rumsessiontable_11_2019_kohls (cost=0.00..0.00 rows=1 width=1,722) (actual rows= loops=)

  • Filter: ((sessionstarttime >= 184050000) AND (sessionstarttime <= 184136340) AND (nveventsrecordtable_11_2019_kohls.sid = sid))
85. 0.000 0.000 ↓ 0.0

Index Scan using rumsessiontable_20191101000558_kohls_sid_idx on rumsessiontable_20191101000558_kohls (cost=0.42..5.08 rows=1 width=665) (actual rows= loops=)

  • Index Cond: (sid = nveventsrecordtable_11_2019_kohls.sid)
  • Filter: ((sessionstarttime >= 184050000) AND (sessionstarttime <= 184136340))
86. 0.000 0.000 ↓ 0.0

Index Scan using rumsessiontable_20191101000641_3_kohls_sid_idx on rumsessiontable_20191101000641_3_kohls (cost=0.14..0.17 rows=1 width=1,722) (actual rows= loops=)

  • Index Cond: (sid = nveventsrecordtable_11_2019_kohls.sid)
  • Filter: ((sessionstarttime >= 184050000) AND (sessionstarttime <= 184136340))
87. 0.000 0.000 ↓ 0.0

Index Scan using rumsessiontable_20191101003219_3_kohls_sid_idx on rumsessiontable_20191101003219_3_kohls (cost=0.12..0.15 rows=1 width=699) (actual rows= loops=)

  • Index Cond: (sid = nveventsrecordtable_11_2019_kohls.sid)
  • Filter: ((sessionstarttime >= 184050000) AND (sessionstarttime <= 184136340))
88. 0.000 0.000 ↓ 0.0

Index Scan using rumsessiontable_20191101000312_1_kohls_sid_idx on rumsessiontable_20191101000312_1_kohls (cost=0.28..0.34 rows=1 width=670) (actual rows= loops=)

  • Index Cond: (sid = nveventsrecordtable_11_2019_kohls.sid)
  • Filter: ((sessionstarttime >= 184050000) AND (sessionstarttime <= 184136340))
89. 0.000 0.000 ↓ 0.0

Index Scan using rumsessiontable_20191101000355_1_kohls_sid_idx on rumsessiontable_20191101000355_1_kohls (cost=0.28..0.35 rows=1 width=676) (actual rows= loops=)

  • Index Cond: (sid = nveventsrecordtable_11_2019_kohls.sid)
  • Filter: ((sessionstarttime >= 184050000) AND (sessionstarttime <= 184136340))
90. 0.000 0.000 ↓ 0.0

Index Scan using rumsessiontable_20191101000433_1_kohls_sid_idx on rumsessiontable_20191101000433_1_kohls (cost=0.42..5.45 rows=1 width=665) (actual rows= loops=)

  • Index Cond: (sid = nveventsrecordtable_11_2019_kohls.sid)
  • Filter: ((sessionstarttime >= 184050000) AND (sessionstarttime <= 184136340))
91. 0.000 0.000 ↓ 0.0

Index Scan using rumsessiontable_20191101000000_3_kohls_sid_idx on rumsessiontable_20191101000000_3_kohls (cost=0.14..0.17 rows=1 width=1,722) (actual rows= loops=)

  • Index Cond: (sid = nveventsrecordtable_11_2019_kohls.sid)
  • Filter: ((sessionstarttime >= 184050000) AND (sessionstarttime <= 184136340))
92. 0.000 0.000 ↓ 0.0

Index Scan using rumsessiontable_20191101000050_3_kohls_sid_idx on rumsessiontable_20191101000050_3_kohls (cost=0.14..0.17 rows=1 width=1,722) (actual rows= loops=)

  • Index Cond: (sid = nveventsrecordtable_11_2019_kohls.sid)
  • Filter: ((sessionstarttime >= 184050000) AND (sessionstarttime <= 184136340))
93. 0.000 0.000 ↓ 0.0

Index Scan using rumsessiontable_20191101000153_3_kohls_sid_idx on rumsessiontable_20191101000153_3_kohls (cost=0.14..0.17 rows=1 width=1,722) (actual rows= loops=)

  • Index Cond: (sid = nveventsrecordtable_11_2019_kohls.sid)
  • Filter: ((sessionstarttime >= 184050000) AND (sessionstarttime <= 184136340))
94. 0.000 0.000 ↓ 0.0

Index Scan using rumsessiontable_20191101000337_3_kohls_sid_idx on rumsessiontable_20191101000337_3_kohls (cost=0.14..0.17 rows=1 width=1,722) (actual rows= loops=)

  • Index Cond: (sid = nveventsrecordtable_11_2019_kohls.sid)
  • Filter: ((sessionstarttime >= 184050000) AND (sessionstarttime <= 184136340))
95. 0.000 0.000 ↓ 0.0

Index Scan using rumsessiontable_20191101000450_3_kohls_sid_idx on rumsessiontable_20191101000450_3_kohls (cost=0.14..0.17 rows=1 width=1,722) (actual rows= loops=)

  • Index Cond: (sid = nveventsrecordtable_11_2019_kohls.sid)
  • Filter: ((sessionstarttime >= 184050000) AND (sessionstarttime <= 184136340))
96. 0.000 0.000 ↓ 0.0

Index Scan using rumsessiontable_20191101000553_3_kohls_sid_idx on rumsessiontable_20191101000553_3_kohls (cost=0.14..0.17 rows=1 width=1,722) (actual rows= loops=)

  • Index Cond: (sid = nveventsrecordtable_11_2019_kohls.sid)
  • Filter: ((sessionstarttime >= 184050000) AND (sessionstarttime <= 184136340))
97. 0.000 0.000 ↓ 0.0

Index Scan using rumsessiontable_20191101000727_3_kohls_sid_idx on rumsessiontable_20191101000727_3_kohls (cost=0.14..0.17 rows=1 width=1,722) (actual rows= loops=)

  • Index Cond: (sid = nveventsrecordtable_11_2019_kohls.sid)
  • Filter: ((sessionstarttime >= 184050000) AND (sessionstarttime <= 184136340))
98. 0.000 0.000 ↓ 0.0

Index Scan using rumsessiontable_20191101000830_3_kohls_sid_idx on rumsessiontable_20191101000830_3_kohls (cost=0.14..0.17 rows=1 width=1,722) (actual rows= loops=)

  • Index Cond: (sid = nveventsrecordtable_11_2019_kohls.sid)
  • Filter: ((sessionstarttime >= 184050000) AND (sessionstarttime <= 184136340))
99. 0.000 0.000 ↓ 0.0

Index Scan using rumsessiontable_20191101000933_3_kohls_sid_idx on rumsessiontable_20191101000933_3_kohls (cost=0.14..0.17 rows=1 width=1,722) (actual rows= loops=)

  • Index Cond: (sid = nveventsrecordtable_11_2019_kohls.sid)
  • Filter: ((sessionstarttime >= 184050000) AND (sessionstarttime <= 184136340))
100. 0.000 0.000 ↓ 0.0

Index Scan using rumsessiontable_20191101001107_3_kohls_sid_idx on rumsessiontable_20191101001107_3_kohls (cost=0.14..0.17 rows=1 width=1,722) (actual rows= loops=)

  • Index Cond: (sid = nveventsrecordtable_11_2019_kohls.sid)
  • Filter: ((sessionstarttime >= 184050000) AND (sessionstarttime <= 184136340))
101. 0.000 0.000 ↓ 0.0

Index Scan using rumsessiontable_20191101001208_3_kohls_sid_idx on rumsessiontable_20191101001208_3_kohls (cost=0.14..0.17 rows=1 width=1,722) (actual rows= loops=)

  • Index Cond: (sid = nveventsrecordtable_11_2019_kohls.sid)
  • Filter: ((sessionstarttime >= 184050000) AND (sessionstarttime <= 184136340))
102. 0.000 0.000 ↓ 0.0

Index Scan using rumsessiontable_20191101002302_3_kohls_sid_idx on rumsessiontable_20191101002302_3_kohls (cost=0.14..0.17 rows=1 width=1,722) (actual rows= loops=)

  • Index Cond: (sid = nveventsrecordtable_11_2019_kohls.sid)
  • Filter: ((sessionstarttime >= 184050000) AND (sessionstarttime <= 184136340))
103. 0.000 0.000 ↓ 0.0

Index Scan using rumsessiontable_20191101002828_3_kohls_sid_idx on rumsessiontable_20191101002828_3_kohls (cost=0.14..0.17 rows=1 width=1,722) (actual rows= loops=)

  • Index Cond: (sid = nveventsrecordtable_11_2019_kohls.sid)
  • Filter: ((sessionstarttime >= 184050000) AND (sessionstarttime <= 184136340))
104. 0.000 0.000 ↓ 0.0

Index Scan using rumsessiontable_20191101003821_3_kohls_sid_idx on rumsessiontable_20191101003821_3_kohls (cost=0.14..0.17 rows=1 width=1,722) (actual rows= loops=)

  • Index Cond: (sid = nveventsrecordtable_11_2019_kohls.sid)
  • Filter: ((sessionstarttime >= 184050000) AND (sessionstarttime <= 184136340))
105. 0.000 0.000 ↓ 0.0

Index Scan using rumsessiontable_20191101005424_3_kohls_sid_idx on rumsessiontable_20191101005424_3_kohls (cost=0.14..0.17 rows=1 width=1,722) (actual rows= loops=)

  • Index Cond: (sid = nveventsrecordtable_11_2019_kohls.sid)
  • Filter: ((sessionstarttime >= 184050000) AND (sessionstarttime <= 184136340))
106. 0.000 0.000 ↓ 0.0

Index Scan using rumsessiontable_20191101010035_3_kohls_sid_idx on rumsessiontable_20191101010035_3_kohls (cost=0.14..0.17 rows=1 width=1,722) (actual rows= loops=)

  • Index Cond: (sid = nveventsrecordtable_11_2019_kohls.sid)
  • Filter: ((sessionstarttime >= 184050000) AND (sessionstarttime <= 184136340))
107. 0.000 0.000 ↓ 0.0

Index Scan using rumsessiontable_20191101010223_3_kohls_sid_idx on rumsessiontable_20191101010223_3_kohls (cost=0.14..0.17 rows=1 width=1,722) (actual rows= loops=)

  • Index Cond: (sid = nveventsrecordtable_11_2019_kohls.sid)
  • Filter: ((sessionstarttime >= 184050000) AND (sessionstarttime <= 184136340))
108. 0.000 0.000 ↓ 0.0

Index Scan using rumsessiontable_20191101051117_3_kohls_sid_idx on rumsessiontable_20191101051117_3_kohls (cost=0.14..0.17 rows=1 width=1,722) (actual rows= loops=)

  • Index Cond: (sid = nveventsrecordtable_11_2019_kohls.sid)
  • Filter: ((sessionstarttime >= 184050000) AND (sessionstarttime <= 184136340))
109. 0.000 0.000 ↓ 0.0

Index Scan using rumsessiontable_20191101080000_3_kohls_sid_idx on rumsessiontable_20191101080000_3_kohls (cost=0.14..0.17 rows=1 width=1,722) (actual rows= loops=)

  • Index Cond: (sid = nveventsrecordtable_11_2019_kohls.sid)
  • Filter: ((sessionstarttime >= 184050000) AND (sessionstarttime <= 184136340))
110. 0.000 0.000 ↓ 0.0

Index Scan using rumsessiontable_20191101080000_kohls_sid_idx on rumsessiontable_20191101080000_kohls (cost=0.42..4.35 rows=1 width=669) (actual rows= loops=)

  • Index Cond: (sid = nveventsrecordtable_11_2019_kohls.sid)
  • Filter: ((sessionstarttime >= 184050000) AND (sessionstarttime <= 184136340))
111. 0.000 0.000 ↓ 0.0

Index Scan using rumsessiontable_20191101080000_1_kohls_sid_idx on rumsessiontable_20191101080000_1_kohls (cost=0.42..3.93 rows=1 width=670) (actual rows= loops=)

  • Index Cond: (sid = nveventsrecordtable_11_2019_kohls.sid)
  • Filter: ((sessionstarttime >= 184050000) AND (sessionstarttime <= 184136340))
112. 0.000 0.000 ↓ 0.0

Index Scan using rumsessiontable_20191101091117_3_kohls_sid_idx on rumsessiontable_20191101091117_3_kohls (cost=0.14..0.17 rows=1 width=1,722) (actual rows= loops=)

  • Index Cond: (sid = nveventsrecordtable_11_2019_kohls.sid)
  • Filter: ((sessionstarttime >= 184050000) AND (sessionstarttime <= 184136340))
113. 0.000 0.000 ↓ 0.0

Index Scan using rumsessiontable_20191101092007_kohls_sid_idx on rumsessiontable_20191101092007_kohls (cost=0.42..7.05 rows=1 width=667) (actual rows= loops=)

  • Index Cond: (sid = nveventsrecordtable_11_2019_kohls.sid)
  • Filter: ((sessionstarttime >= 184050000) AND (sessionstarttime <= 184136340))
114. 0.000 0.000 ↓ 0.0

Index Scan using rumsessiontable_20191101091749_1_kohls_sid_idx on rumsessiontable_20191101091749_1_kohls (cost=0.42..5.16 rows=1 width=668) (actual rows= loops=)

  • Index Cond: (sid = nveventsrecordtable_11_2019_kohls.sid)
  • Filter: ((sessionstarttime >= 184050000) AND (sessionstarttime <= 184136340))
115. 0.000 0.000 ↓ 0.0

Index Scan using rumsessiontable_20191101110602_1_kohls_sid_idx on rumsessiontable_20191101110602_1_kohls (cost=0.42..4.09 rows=1 width=672) (actual rows= loops=)

  • Index Cond: (sid = nveventsrecordtable_11_2019_kohls.sid)
  • Filter: ((sessionstarttime >= 184050000) AND (sessionstarttime <= 184136340))
116. 0.000 0.000 ↓ 0.0

Index Scan using rumsessiontable_20191101114534_1_kohls_sid_idx on rumsessiontable_20191101114534_1_kohls (cost=0.29..2.94 rows=1 width=675) (actual rows= loops=)

  • Index Cond: (sid = nveventsrecordtable_11_2019_kohls.sid)
  • Filter: ((sessionstarttime >= 184050000) AND (sessionstarttime <= 184136340))
117. 0.000 0.000 ↓ 0.0

Index Scan using rumsessiontable_20191101115516_1_kohls_sid_idx on rumsessiontable_20191101115516_1_kohls (cost=0.42..3.92 rows=1 width=672) (actual rows= loops=)

  • Index Cond: (sid = nveventsrecordtable_11_2019_kohls.sid)
  • Filter: ((sessionstarttime >= 184050000) AND (sessionstarttime <= 184136340))
118. 0.000 0.000 ↓ 0.0

Index Scan using rumsessiontable_20191101122358_1_kohls_sid_idx on rumsessiontable_20191101122358_1_kohls (cost=0.42..6.41 rows=1 width=669) (actual rows= loops=)

  • Index Cond: (sid = nveventsrecordtable_11_2019_kohls.sid)
  • Filter: ((sessionstarttime >= 184050000) AND (sessionstarttime <= 184136340))
119. 0.000 0.000 ↓ 0.0

Index Scan using rumsessiontable_20191101160000_kohls_sid_idx on rumsessiontable_20191101160000_kohls (cost=0.43..7.74 rows=1 width=666) (actual rows= loops=)

  • Index Cond: (sid = nveventsrecordtable_11_2019_kohls.sid)
  • Filter: ((sessionstarttime >= 184050000) AND (sessionstarttime <= 184136340))
120. 0.000 0.000 ↓ 0.0

Index Scan using rumsessiontable_20191101160000_1_kohls_sid_idx on rumsessiontable_20191101160000_1_kohls (cost=0.42..6.58 rows=1 width=673) (actual rows= loops=)

  • Index Cond: (sid = nveventsrecordtable_11_2019_kohls.sid)
  • Filter: ((sessionstarttime >= 184050000) AND (sessionstarttime <= 184136340))
121. 0.000 0.000 ↓ 0.0

Index Scan using rumsessiontable_20191101203832_1_kohls_sid_idx on rumsessiontable_20191101203832_1_kohls (cost=0.42..5.74 rows=1 width=672) (actual rows= loops=)

  • Index Cond: (sid = nveventsrecordtable_11_2019_kohls.sid)
  • Filter: ((sessionstarttime >= 184050000) AND (sessionstarttime <= 184136340))
122. 0.000 0.000 ↓ 0.0

Index Scan using rumsessiontable_20191102000002_kohls_sid_idx on rumsessiontable_20191102000002_kohls (cost=0.42..3.78 rows=1 width=664) (actual rows= loops=)

  • Index Cond: (sid = nveventsrecordtable_11_2019_kohls.sid)
  • Filter: ((sessionstarttime >= 184050000) AND (sessionstarttime <= 184136340))
123. 0.000 0.000 ↓ 0.0

Index Scan using rumsessiontable_20191102000000_1_kohls_sid_idx on rumsessiontable_20191102000000_1_kohls (cost=0.42..3.59 rows=1 width=663) (actual rows= loops=)

  • Index Cond: (sid = nveventsrecordtable_11_2019_kohls.sid)
  • Filter: ((sessionstarttime >= 184050000) AND (sessionstarttime <= 184136340))
124. 0.000 0.000 ↓ 0.0

Index Scan using rumsessiontable_20191101092141_3_kohls_sid_idx on rumsessiontable_20191101092141_3_kohls (cost=0.14..0.17 rows=1 width=1,722) (actual rows= loops=)

  • Index Cond: (sid = nveventsrecordtable_11_2019_kohls.sid)
  • Filter: ((sessionstarttime >= 184050000) AND (sessionstarttime <= 184136340))