explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9va7

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

Limit (cost=10.54..237.89 rows=15 width=668) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Nested Loop Semi Join (cost=10.54..43,636,201.77 rows=2,878,956 width=668) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Merge Append (cost=10.54..1,345,800.79 rows=5,757,912 width=668) (actual rows= loops=)

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

Index Scan Backward using rumsessiontable_11_2019_kohls_sessionstarttime_idx on rumsessiontable_11_2019_kohls (cost=0.12..8.14 rows=1 width=1,722) (actual rows= loops=)

  • Index Cond: ((sessionstarttime >= 184050000) AND (sessionstarttime <= 184136340))
5. 0.000 0.000 ↓ 0.0

Index Scan Backward using rumsessiontable_20191101000558_kohls_sessionstarttime_idx on rumsessiontable_20191101000558_kohls (cost=0.42..26,740.21 rows=231,015 width=665) (actual rows= loops=)

  • Index Cond: ((sessionstarttime >= 184050000) AND (sessionstarttime <= 184136340))
6. 0.000 0.000 ↓ 0.0

Index Scan Backward using rumsessiontable_20191101000641_3_kohls_sessionstarttime_idx on rumsessiontable_20191101000641_3_kohls (cost=0.14..8.16 rows=1 width=1,722) (actual rows= loops=)

  • Index Cond: ((sessionstarttime >= 184050000) AND (sessionstarttime <= 184136340))
7. 0.000 0.000 ↓ 0.0

Index Scan Backward using rumsessiontable_20191101003219_3_kohls_sessionstarttime_idx on rumsessiontable_20191101003219_3_kohls (cost=0.12..8.14 rows=1 width=699) (actual rows= loops=)

  • Index Cond: ((sessionstarttime >= 184050000) AND (sessionstarttime <= 184136340))
8. 0.000 0.000 ↓ 0.0

Index Scan Backward using rumsessiontable_20191101000312_1_kohls_sessionstarttime_idx on rumsessiontable_20191101000312_1_kohls (cost=0.28..206.14 rows=528 width=670) (actual rows= loops=)

  • Index Cond: ((sessionstarttime >= 184050000) AND (sessionstarttime <= 184136340))
9. 0.000 0.000 ↓ 0.0

Index Scan Backward using rumsessiontable_20191101000355_1_kohls_sessionstarttime_idx on rumsessiontable_20191101000355_1_kohls (cost=0.28..244.96 rows=638 width=676) (actual rows= loops=)

  • Index Cond: ((sessionstarttime >= 184050000) AND (sessionstarttime <= 184136340))
10. 0.000 0.000 ↓ 0.0

Index Scan Backward using rumsessiontable_20191101000433_1_kohls_sessionstarttime_idx on rumsessiontable_20191101000433_1_kohls (cost=0.42..34,561.06 rows=291,616 width=665) (actual rows= loops=)

  • Index Cond: ((sessionstarttime >= 184050000) AND (sessionstarttime <= 184136340))
11. 0.000 0.000 ↓ 0.0

Index Scan Backward using rumsessiontable_20191101000000_3_kohls_sessionstarttime_idx on rumsessiontable_20191101000000_3_kohls (cost=0.14..8.16 rows=1 width=1,722) (actual rows= loops=)

  • Index Cond: ((sessionstarttime >= 184050000) AND (sessionstarttime <= 184136340))
12. 0.000 0.000 ↓ 0.0

Index Scan Backward using rumsessiontable_20191101000050_3_kohls_sessionstarttime_idx on rumsessiontable_20191101000050_3_kohls (cost=0.14..8.16 rows=1 width=1,722) (actual rows= loops=)

  • Index Cond: ((sessionstarttime >= 184050000) AND (sessionstarttime <= 184136340))
13. 0.000 0.000 ↓ 0.0

Index Scan Backward using rumsessiontable_20191101000153_3_kohls_sessionstarttime_idx on rumsessiontable_20191101000153_3_kohls (cost=0.14..8.16 rows=1 width=1,722) (actual rows= loops=)

  • Index Cond: ((sessionstarttime >= 184050000) AND (sessionstarttime <= 184136340))
14. 0.000 0.000 ↓ 0.0

Index Scan Backward using rumsessiontable_20191101000337_3_kohls_sessionstarttime_idx on rumsessiontable_20191101000337_3_kohls (cost=0.14..8.16 rows=1 width=1,722) (actual rows= loops=)

  • Index Cond: ((sessionstarttime >= 184050000) AND (sessionstarttime <= 184136340))
15. 0.000 0.000 ↓ 0.0

Index Scan Backward using rumsessiontable_20191101000450_3_kohls_sessionstarttime_idx on rumsessiontable_20191101000450_3_kohls (cost=0.14..8.16 rows=1 width=1,722) (actual rows= loops=)

  • Index Cond: ((sessionstarttime >= 184050000) AND (sessionstarttime <= 184136340))
16. 0.000 0.000 ↓ 0.0

Index Scan Backward using rumsessiontable_20191101000553_3_kohls_sessionstarttime_idx on rumsessiontable_20191101000553_3_kohls (cost=0.14..8.16 rows=1 width=1,722) (actual rows= loops=)

  • Index Cond: ((sessionstarttime >= 184050000) AND (sessionstarttime <= 184136340))
17. 0.000 0.000 ↓ 0.0

Index Scan Backward using rumsessiontable_20191101000727_3_kohls_sessionstarttime_idx on rumsessiontable_20191101000727_3_kohls (cost=0.14..8.16 rows=1 width=1,722) (actual rows= loops=)

  • Index Cond: ((sessionstarttime >= 184050000) AND (sessionstarttime <= 184136340))
18. 0.000 0.000 ↓ 0.0

Index Scan Backward using rumsessiontable_20191101000830_3_kohls_sessionstarttime_idx on rumsessiontable_20191101000830_3_kohls (cost=0.14..8.16 rows=1 width=1,722) (actual rows= loops=)

  • Index Cond: ((sessionstarttime >= 184050000) AND (sessionstarttime <= 184136340))
19. 0.000 0.000 ↓ 0.0

Index Scan Backward using rumsessiontable_20191101000933_3_kohls_sessionstarttime_idx on rumsessiontable_20191101000933_3_kohls (cost=0.14..8.16 rows=1 width=1,722) (actual rows= loops=)

  • Index Cond: ((sessionstarttime >= 184050000) AND (sessionstarttime <= 184136340))
20. 0.000 0.000 ↓ 0.0

Index Scan Backward using rumsessiontable_20191101001107_3_kohls_sessionstarttime_idx on rumsessiontable_20191101001107_3_kohls (cost=0.14..8.16 rows=1 width=1,722) (actual rows= loops=)

  • Index Cond: ((sessionstarttime >= 184050000) AND (sessionstarttime <= 184136340))
21. 0.000 0.000 ↓ 0.0

Index Scan Backward using rumsessiontable_20191101001208_3_kohls_sessionstarttime_idx on rumsessiontable_20191101001208_3_kohls (cost=0.14..8.16 rows=1 width=1,722) (actual rows= loops=)

  • Index Cond: ((sessionstarttime >= 184050000) AND (sessionstarttime <= 184136340))
22. 0.000 0.000 ↓ 0.0

Index Scan Backward using rumsessiontable_20191101002302_3_kohls_sessionstarttime_idx on rumsessiontable_20191101002302_3_kohls (cost=0.14..8.16 rows=1 width=1,722) (actual rows= loops=)

  • Index Cond: ((sessionstarttime >= 184050000) AND (sessionstarttime <= 184136340))
23. 0.000 0.000 ↓ 0.0

Index Scan Backward using rumsessiontable_20191101002828_3_kohls_sessionstarttime_idx on rumsessiontable_20191101002828_3_kohls (cost=0.14..8.16 rows=1 width=1,722) (actual rows= loops=)

  • Index Cond: ((sessionstarttime >= 184050000) AND (sessionstarttime <= 184136340))
24. 0.000 0.000 ↓ 0.0

Index Scan Backward using rumsessiontable_20191101003821_3_kohls_sessionstarttime_idx on rumsessiontable_20191101003821_3_kohls (cost=0.14..8.16 rows=1 width=1,722) (actual rows= loops=)

  • Index Cond: ((sessionstarttime >= 184050000) AND (sessionstarttime <= 184136340))
25. 0.000 0.000 ↓ 0.0

Index Scan Backward using rumsessiontable_20191101005424_3_kohls_sessionstarttime_idx on rumsessiontable_20191101005424_3_kohls (cost=0.14..8.16 rows=1 width=1,722) (actual rows= loops=)

  • Index Cond: ((sessionstarttime >= 184050000) AND (sessionstarttime <= 184136340))
26. 0.000 0.000 ↓ 0.0

Index Scan Backward using rumsessiontable_20191101010035_3_kohls_sessionstarttime_idx on rumsessiontable_20191101010035_3_kohls (cost=0.14..8.16 rows=1 width=1,722) (actual rows= loops=)

  • Index Cond: ((sessionstarttime >= 184050000) AND (sessionstarttime <= 184136340))
27. 0.000 0.000 ↓ 0.0

Index Scan Backward using rumsessiontable_20191101010223_3_kohls_sessionstarttime_idx on rumsessiontable_20191101010223_3_kohls (cost=0.14..8.16 rows=1 width=1,722) (actual rows= loops=)

  • Index Cond: ((sessionstarttime >= 184050000) AND (sessionstarttime <= 184136340))
28. 0.000 0.000 ↓ 0.0

Index Scan Backward using rumsessiontable_20191101051117_3_kohls_sessionstarttime_idx on rumsessiontable_20191101051117_3_kohls (cost=0.14..8.16 rows=1 width=1,722) (actual rows= loops=)

  • Index Cond: ((sessionstarttime >= 184050000) AND (sessionstarttime <= 184136340))
29. 0.000 0.000 ↓ 0.0

Index Scan Backward using rumsessiontable_20191101080000_3_kohls_sessionstarttime_idx on rumsessiontable_20191101080000_3_kohls (cost=0.14..8.16 rows=1 width=1,722) (actual rows= loops=)

  • Index Cond: ((sessionstarttime >= 184050000) AND (sessionstarttime <= 184136340))
30. 0.000 0.000 ↓ 0.0

Index Scan Backward using rumsessiontable_20191101080000_kohls_sessionstarttime_idx on rumsessiontable_20191101080000_kohls (cost=0.42..25,693.43 rows=127,631 width=669) (actual rows= loops=)

  • Index Cond: ((sessionstarttime >= 184050000) AND (sessionstarttime <= 184136340))
31. 0.000 0.000 ↓ 0.0

Index Scan Backward using rumsessiontable_20191101080000_1_kohls_sessionstarttime_idx on rumsessiontable_20191101080000_1_kohls (cost=0.29..16,481.85 rows=90,345 width=670) (actual rows= loops=)

  • Index Cond: ((sessionstarttime >= 184050000) AND (sessionstarttime <= 184136340))
32. 0.000 0.000 ↓ 0.0

Index Scan Backward using rumsessiontable_20191101091117_3_kohls_sessionstarttime_idx on rumsessiontable_20191101091117_3_kohls (cost=0.14..8.16 rows=1 width=1,722) (actual rows= loops=)

  • Index Cond: ((sessionstarttime >= 184050000) AND (sessionstarttime <= 184136340))
33. 0.000 0.000 ↓ 0.0

Index Scan Backward using rumsessiontable_20191101092007_kohls_sessionstarttime_idx on rumsessiontable_20191101092007_kohls (cost=0.42..111,851.30 rows=929,843 width=667) (actual rows= loops=)

  • Index Cond: ((sessionstarttime >= 184050000) AND (sessionstarttime <= 184136340))
34. 0.000 0.000 ↓ 0.0

Index Scan Backward using rumsessiontable_20191101091749_1_kohls_sessionstarttime_idx on rumsessiontable_20191101091749_1_kohls (cost=0.42..38,021.69 rows=242,041 width=668) (actual rows= loops=)

  • Index Cond: ((sessionstarttime >= 184050000) AND (sessionstarttime <= 184136340))
35. 0.000 0.000 ↓ 0.0

Index Scan Backward using rumsessiontable_20191101110602_1_kohls_sessionstarttime_idx on rumsessiontable_20191101110602_1_kohls (cost=0.29..28,045.18 rows=104,164 width=672) (actual rows= loops=)

  • Index Cond: ((sessionstarttime >= 184050000) AND (sessionstarttime <= 184136340))
36. 0.000 0.000 ↓ 0.0

Index Scan Backward using rumsessiontable_20191101114534_1_kohls_sessionstarttime_idx on rumsessiontable_20191101114534_1_kohls (cost=0.29..14,653.48 rows=39,664 width=675) (actual rows= loops=)

  • Index Cond: ((sessionstarttime >= 184050000) AND (sessionstarttime <= 184136340))
37. 0.000 0.000 ↓ 0.0

Index Scan Backward using rumsessiontable_20191101115516_1_kohls_sessionstarttime_idx on rumsessiontable_20191101115516_1_kohls (cost=0.29..29,292.19 rows=84,616 width=672) (actual rows= loops=)

  • Index Cond: ((sessionstarttime >= 184050000) AND (sessionstarttime <= 184136340))
38. 0.000 0.000 ↓ 0.0

Index Scan Backward using rumsessiontable_20191101122358_1_kohls_sessionstarttime_idx on rumsessiontable_20191101122358_1_kohls (cost=0.42..64,807.67 rows=513,727 width=669) (actual rows= loops=)

  • Index Cond: ((sessionstarttime >= 184050000) AND (sessionstarttime <= 184136340))
39. 0.000 0.000 ↓ 0.0

Index Scan Backward using rumsessiontable_20191101160000_kohls_sessionstarttime_idx on rumsessiontable_20191101160000_kohls (cost=0.43..509,966.50 rows=2,166,319 width=666) (actual rows= loops=)

  • Index Cond: ((sessionstarttime >= 184050000) AND (sessionstarttime <= 184136340))
40. 0.000 0.000 ↓ 0.0

Index Scan Backward using rumsessiontable_20191101160000_1_kohls_sessionstarttime_idx on rumsessiontable_20191101160000_1_kohls (cost=0.42..73,235.68 rows=587,929 width=673) (actual rows= loops=)

  • Index Cond: ((sessionstarttime >= 184050000) AND (sessionstarttime <= 184136340))
41. 0.000 0.000 ↓ 0.0

Index Scan Backward using rumsessiontable_20191101203832_1_kohls_sessionstarttime_idx on rumsessiontable_20191101203832_1_kohls (cost=0.42..48,908.00 rows=347,810 width=672) (actual rows= loops=)

  • Index Cond: ((sessionstarttime >= 184050000) AND (sessionstarttime <= 184136340))
42. 0.000 0.000 ↓ 0.0

Index Scan Backward using rumsessiontable_20191102000002_kohls_sessionstarttime_idx on rumsessiontable_20191102000002_kohls (cost=0.29..8.31 rows=1 width=664) (actual rows= loops=)

  • Index Cond: ((sessionstarttime >= 184050000) AND (sessionstarttime <= 184136340))
43. 0.000 0.000 ↓ 0.0

Index Scan Backward using rumsessiontable_20191102000000_1_kohls_sessionstarttime_idx on rumsessiontable_20191102000000_1_kohls (cost=0.29..8.31 rows=1 width=663) (actual rows= loops=)

  • Index Cond: ((sessionstarttime >= 184050000) AND (sessionstarttime <= 184136340))
44. 0.000 0.000 ↓ 0.0

Index Scan Backward using rumsessiontable_20191101092141_3_kohls_sessionstarttime_idx on rumsessiontable_20191101092141_3_kohls (cost=0.14..8.16 rows=1 width=1,722) (actual rows= loops=)

  • Index Cond: ((sessionstarttime >= 184050000) AND (sessionstarttime <= 184136340))
45. 0.000 0.000 ↓ 0.0

Append (cost=0.00..13.65 rows=41 width=17) (actual rows= loops=)

46. 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) AND (rumsessiontable_11_2019_kohls.sid = sid))
47. 0.000 0.000 ↓ 0.0

Index Scan using nveventsrecordtable_20191101000558_kohls_sid_idx on nveventsrecordtable_20191101000558_kohls (cost=0.42..0.60 rows=1 width=13) (actual rows= loops=)

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

Index Scan using nveventsrecordtable_20191101000641_3_kohls_sid_idx on nveventsrecordtable_20191101000641_3_kohls (cost=0.15..0.23 rows=1 width=20) (actual rows= loops=)

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

Index Scan using nveventsrecordtable_20191101000312_1_kohls_sid_idx on nveventsrecordtable_20191101000312_1_kohls (cost=0.14..0.16 rows=1 width=13) (actual rows= loops=)

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

Index Scan using nveventsrecordtable_20191101000355_1_kohls_sid_idx on nveventsrecordtable_20191101000355_1_kohls (cost=0.14..0.16 rows=1 width=13) (actual rows= loops=)

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

Index Scan using nveventsrecordtable_20191101000433_1_kohls_sid_idx on nveventsrecordtable_20191101000433_1_kohls (cost=0.42..0.62 rows=1 width=13) (actual rows= loops=)

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

Index Scan using nveventsrecordtable_20191101003219_3_kohls_sid_idx on nveventsrecordtable_20191101003219_3_kohls (cost=0.15..0.23 rows=1 width=20) (actual rows= loops=)

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

Index Scan using nveventsrecordtable_20191101000000_3_kohls_sid_idx on nveventsrecordtable_20191101000000_3_kohls (cost=0.15..0.23 rows=1 width=20) (actual rows= loops=)

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

Index Scan using nveventsrecordtable_20191101000050_3_kohls_sid_idx on nveventsrecordtable_20191101000050_3_kohls (cost=0.15..0.23 rows=1 width=20) (actual rows= loops=)

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

Index Scan using nveventsrecordtable_20191101000153_3_kohls_sid_idx on nveventsrecordtable_20191101000153_3_kohls (cost=0.15..0.23 rows=1 width=20) (actual rows= loops=)

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

Index Scan using nveventsrecordtable_20191101000337_3_kohls_sid_idx on nveventsrecordtable_20191101000337_3_kohls (cost=0.15..0.23 rows=1 width=20) (actual rows= loops=)

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

Index Scan using nveventsrecordtable_20191101000450_3_kohls_sid_idx on nveventsrecordtable_20191101000450_3_kohls (cost=0.15..0.23 rows=1 width=20) (actual rows= loops=)

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

Index Scan using nveventsrecordtable_20191101000553_3_kohls_sid_idx on nveventsrecordtable_20191101000553_3_kohls (cost=0.15..0.23 rows=1 width=20) (actual rows= loops=)

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

Index Scan using nveventsrecordtable_20191101000727_3_kohls_sid_idx on nveventsrecordtable_20191101000727_3_kohls (cost=0.15..0.23 rows=1 width=20) (actual rows= loops=)

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

Index Scan using nveventsrecordtable_20191101000830_3_kohls_sid_idx on nveventsrecordtable_20191101000830_3_kohls (cost=0.15..0.23 rows=1 width=20) (actual rows= loops=)

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

Index Scan using nveventsrecordtable_20191101000933_3_kohls_sid_idx on nveventsrecordtable_20191101000933_3_kohls (cost=0.15..0.23 rows=1 width=20) (actual rows= loops=)

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

Index Scan using nveventsrecordtable_20191101001107_3_kohls_sid_idx on nveventsrecordtable_20191101001107_3_kohls (cost=0.15..0.23 rows=1 width=20) (actual rows= loops=)

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

Index Scan using nveventsrecordtable_20191101001208_3_kohls_sid_idx on nveventsrecordtable_20191101001208_3_kohls (cost=0.15..0.23 rows=1 width=20) (actual rows= loops=)

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

Index Scan using nveventsrecordtable_20191101002302_3_kohls_sid_idx on nveventsrecordtable_20191101002302_3_kohls (cost=0.15..0.23 rows=1 width=20) (actual rows= loops=)

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

Index Scan using nveventsrecordtable_20191101002828_3_kohls_sid_idx on nveventsrecordtable_20191101002828_3_kohls (cost=0.15..0.23 rows=1 width=20) (actual rows= loops=)

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

Index Scan using nveventsrecordtable_20191101003821_3_kohls_sid_idx on nveventsrecordtable_20191101003821_3_kohls (cost=0.15..0.23 rows=1 width=20) (actual rows= loops=)

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

Index Scan using nveventsrecordtable_20191101005424_3_kohls_sid_idx on nveventsrecordtable_20191101005424_3_kohls (cost=0.15..0.23 rows=1 width=20) (actual rows= loops=)

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

Index Scan using nveventsrecordtable_20191101010035_3_kohls_sid_idx on nveventsrecordtable_20191101010035_3_kohls (cost=0.15..0.23 rows=1 width=20) (actual rows= loops=)

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

Index Scan using nveventsrecordtable_20191101010223_3_kohls_sid_idx on nveventsrecordtable_20191101010223_3_kohls (cost=0.15..0.23 rows=1 width=20) (actual rows= loops=)

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

Index Scan using nveventsrecordtable_20191101051117_3_kohls_sid_idx on nveventsrecordtable_20191101051117_3_kohls (cost=0.15..0.23 rows=1 width=20) (actual rows= loops=)

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

Index Scan using nveventsrecordtable_20191101080000_kohls_sid_idx on nveventsrecordtable_20191101080000_kohls (cost=0.42..0.54 rows=1 width=13) (actual rows= loops=)

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

Index Scan using nveventsrecordtable_20191101080000_3_kohls_sid_idx on nveventsrecordtable_20191101080000_3_kohls (cost=0.15..0.23 rows=1 width=20) (actual rows= loops=)

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

Index Scan using nveventsrecordtable_20191101080000_1_kohls_sid_idx on nveventsrecordtable_20191101080000_1_kohls (cost=0.42..0.54 rows=1 width=12) (actual rows= loops=)

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

Index Scan using nveventsrecordtable_20191101092141_3_kohls_sid_idx on nveventsrecordtable_20191101092141_3_kohls (cost=0.15..0.23 rows=1 width=20) (actual rows= loops=)

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

Index Scan using nveventsrecordtable_20191101091117_3_kohls_sid_idx on nveventsrecordtable_20191101091117_3_kohls (cost=0.15..0.23 rows=1 width=20) (actual rows= loops=)

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

Index Scan using nveventsrecordtable_20191101091749_1_kohls_sid_idx on nveventsrecordtable_20191101091749_1_kohls (cost=0.42..0.63 rows=1 width=12) (actual rows= loops=)

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

Index Scan using nveventsrecordtable_20191101092007_kohls_sid_idx on nveventsrecordtable_20191101092007_kohls (cost=0.42..0.60 rows=1 width=12) (actual rows= loops=)

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

Index Scan using nveventsrecordtable_20191101110602_1_kohls_sid_idx on nveventsrecordtable_20191101110602_1_kohls (cost=0.42..0.55 rows=1 width=12) (actual rows= loops=)

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

Index Scan using nveventsrecordtable_20191101114534_1_kohls_sid_idx on nveventsrecordtable_20191101114534_1_kohls (cost=0.29..0.36 rows=1 width=13) (actual rows= loops=)

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

Index Scan using nveventsrecordtable_20191101115516_1_kohls_sid_idx on nveventsrecordtable_20191101115516_1_kohls (cost=0.29..0.41 rows=1 width=13) (actual rows= loops=)

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

Index Scan using nveventsrecordtable_20191101122358_1_kohls_sid_idx on nveventsrecordtable_20191101122358_1_kohls (cost=0.42..0.63 rows=1 width=12) (actual rows= loops=)

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

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

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

Index Scan using nveventsrecordtable_20191101160000_1_kohls_sid_idx on nveventsrecordtable_20191101160000_1_kohls (cost=0.42..0.63 rows=1 width=12) (actual rows= loops=)

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

Index Scan using nveventsrecordtable_20191101203832_1_kohls_sid_idx on nveventsrecordtable_20191101203832_1_kohls (cost=0.42..0.65 rows=1 width=12) (actual rows= loops=)

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

Index Scan using nveventsrecordtable_20191102000002_kohls_sid_idx on nveventsrecordtable_20191102000002_kohls (cost=0.29..0.42 rows=1 width=13) (actual rows= loops=)

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

Index Scan using nveventsrecordtable_20191102000000_1_kohls_sid_idx on nveventsrecordtable_20191102000000_1_kohls (cost=0.29..0.39 rows=1 width=12) (actual rows= loops=)

  • Index Cond: (sid = rumsessiontable_11_2019_kohls.sid)
  • Filter: (("timestamp" >= 184050000) AND ("timestamp" <= 184143540) AND (eventid = 131))