explain.depesz.com

PostgreSQL's explain analyze made readable

Result: g78o

Settings
# exclusive inclusive rows x rows loops node
1. 11.954 8,973.113 ↑ 1.0 1 1

Aggregate (cost=5,199.25..5,199.26 rows=1 width=8) (actual time=8,973.113..8,973.113 rows=1 loops=1)

2. 8.945 8,961.159 ↓ 19.9 1,133 1

Nested Loop Left Join (cost=4,253.87..5,199.10 rows=57 width=31) (actual time=40.381..8,961.159 rows=1,133 loops=1)

3. 10.305 8,368.719 ↓ 19.9 1,133 1

Nested Loop Left Join (cost=4,253.73..5,131.56 rows=57 width=39) (actual time=39.824..8,368.719 rows=1,133 loops=1)

4. 12.046 7,771.520 ↓ 19.9 1,133 1

Nested Loop Left Join (cost=4,253.59..5,064.01 rows=57 width=39) (actual time=39.221..7,771.520 rows=1,133 loops=1)

5. 6.624 7,147.654 ↓ 19.9 1,133 1

Nested Loop Left Join (cost=4,253.45..4,996.47 rows=57 width=39) (actual time=38.616..7,147.654 rows=1,133 loops=1)

6. 4.807 6,543.939 ↓ 19.9 1,133 1

Nested Loop Left Join (cost=4,253.31..4,928.92 rows=57 width=39) (actual time=33.577..6,543.939 rows=1,133 loops=1)

7. 12.593 5,964.701 ↓ 19.9 1,133 1

Nested Loop Left Join (cost=4,253.17..4,861.38 rows=57 width=39) (actual time=33.009..5,964.701 rows=1,133 loops=1)

8. 7.701 5,326.692 ↓ 19.9 1,133 1

Nested Loop Left Join (cost=4,253.03..4,793.83 rows=57 width=39) (actual time=32.484..5,326.692 rows=1,133 loops=1)

9. 7.724 4,710.570 ↓ 19.9 1,133 1

Nested Loop Left Join (cost=4,252.89..4,726.29 rows=57 width=39) (actual time=31.912..4,710.570 rows=1,133 loops=1)

10. 5.713 4,117.085 ↓ 19.9 1,133 1

Nested Loop Left Join (cost=4,252.75..4,658.74 rows=57 width=39) (actual time=31.380..4,117.085 rows=1,133 loops=1)

11. 12.630 3,523.345 ↓ 19.9 1,133 1

Nested Loop Left Join (cost=4,252.61..4,591.20 rows=57 width=39) (actual time=30.845..3,523.345 rows=1,133 loops=1)

12. 14.388 2,914.757 ↓ 19.9 1,133 1

Nested Loop Left Join (cost=4,252.47..4,523.65 rows=57 width=39) (actual time=30.321..2,914.757 rows=1,133 loops=1)

13. 13.641 2,339.534 ↓ 19.9 1,133 1

Nested Loop Left Join (cost=4,252.33..4,456.11 rows=57 width=39) (actual time=29.763..2,339.534 rows=1,133 loops=1)

14. 15.537 1,725.403 ↓ 19.9 1,133 1

Nested Loop Left Join (cost=4,252.19..4,388.56 rows=57 width=39) (actual time=29.180..1,725.403 rows=1,133 loops=1)

15. 10.938 1,120.706 ↓ 19.9 1,133 1

Nested Loop Left Join (cost=4,252.05..4,321.02 rows=57 width=39) (actual time=28.523..1,120.706 rows=1,133 loops=1)

16. 21.787 56.078 ↓ 19.9 1,133 1

GroupAggregate (cost=4,251.91..4,252.90 rows=57 width=43) (actual time=26.539..56.078 rows=1,133 loops=1)

  • Group Key: tbl."trackedUserId
17. 9.974 34.291 ↓ 29.0 1,652 1

Sort (cost=4,251.91..4,252.05 rows=57 width=39) (actual time=26.525..34.291 rows=1,652 loops=1)

  • Sort Key: tbl."trackedUserId
  • Sort Method: quicksort Memory: 178kB
18. 0.164 24.317 ↓ 29.0 1,652 1

Append (cost=0.42..4,250.24 rows=57 width=39) (actual time=1.106..24.317 rows=1,652 loops=1)

19. 5.405 5.405 ↓ 35.8 358 1

Index Scan using "_hyper_15_64_chunk_user_history_projectId_searchParsed_idx" on _hyper_15_64_chunk tbl (cost=0.42..1,126.42 rows=10 width=39) (actual time=1.103..5.405 rows=358 loops=1)

  • Index Cond: (("projectId")::text = '80874934d6'::text)
  • Filter: (("time" >= '2020-08-04 07:49:59.625'::timestamp without time zone) AND ("time" <= '2020-09-03 07:49:59.625'::timestamp without time zone) AND ((url)::text ~ '/apply'::text))
  • Rows Removed by Filter: 1,633
20. 4.432 4.432 ↓ 27.0 432 1

Index Scan using "_hyper_15_58_chunk_user_history_projectId_searchParsed_idx" on _hyper_15_58_chunk tbl_1 (cost=0.41..738.33 rows=16 width=39) (actual time=1.501..4.432 rows=432 loops=1)

  • Index Cond: (("projectId")::text = '80874934d6'::text)
  • Filter: (("time" >= '2020-08-04 07:49:59.625'::timestamp without time zone) AND ("time" <= '2020-09-03 07:49:59.625'::timestamp without time zone) AND ((url)::text ~ '/apply'::text))
  • Rows Removed by Filter: 1,495
21. 1.518 1.518 ↓ 15.0 15 1

Index Scan using "_hyper_15_66_chunk_IDX_1607e47604c0536bca9ce4c16f" on _hyper_15_66_chunk tbl_2 (cost=0.28..38.70 rows=1 width=39) (actual time=0.041..1.518 rows=15 loops=1)

  • Index Cond: ((("projectId")::text = '80874934d6'::text) AND ("time" >= '2020-08-04 07:49:59.625'::timestamp without time zone) AND ("time" <= '2020-09-03 07:49:59.625'::timestamp without time zone))
  • Filter: ((url)::text ~ '/apply'::text)
  • Rows Removed by Filter: 42
22. 4.831 4.831 ↓ 23.8 405 1

Index Scan using "_hyper_15_60_chunk_user_history_projectId_searchParsed_idx" on _hyper_15_60_chunk tbl_3 (cost=0.41..953.35 rows=17 width=39) (actual time=0.406..4.831 rows=405 loops=1)

  • Index Cond: (("projectId")::text = '80874934d6'::text)
  • Filter: (("time" >= '2020-08-04 07:49:59.625'::timestamp without time zone) AND ("time" <= '2020-09-03 07:49:59.625'::timestamp without time zone) AND ((url)::text ~ '/apply'::text))
  • Rows Removed by Filter: 1,933
23. 2.614 2.614 ↓ 27.8 111 1

Index Scan using "_hyper_15_56_chunk_IDX_1607e47604c0536bca9ce4c16f" on _hyper_15_56_chunk tbl_4 (cost=0.41..349.11 rows=4 width=39) (actual time=0.964..2.614 rows=111 loops=1)

  • Index Cond: ((("projectId")::text = '80874934d6'::text) AND ("time" >= '2020-08-04 07:49:59.625'::timestamp without time zone) AND ("time" <= '2020-09-03 07:49:59.625'::timestamp without time zone))
  • Filter: ((url)::text ~ '/apply'::text)
  • Rows Removed by Filter: 341
24. 5.353 5.353 ↓ 36.8 331 1

Index Scan using "_hyper_15_62_chunk_user_history_projectId_searchParsed_idx" on _hyper_15_62_chunk tbl_5 (cost=0.42..1,044.06 rows=9 width=39) (actual time=0.644..5.353 rows=331 loops=1)

  • Index Cond: (("projectId")::text = '80874934d6'::text)
  • Filter: (("time" >= '2020-08-04 07:49:59.625'::timestamp without time zone) AND ("time" <= '2020-09-03 07:49:59.625'::timestamp without time zone) AND ((url)::text ~ '/apply'::text))
  • Rows Removed by Filter: 1,446
25. 125.763 1,053.690 ↑ 1.0 1 1,133

Limit (cost=0.14..1.16 rows=1 width=12) (actual time=0.930..0.930 rows=1 loops=1,133)

26. 530.710 927.927 ↑ 1.0 1 1,133

Custom Scan (ChunkAppend) on user_events tbl_6 (cost=0.14..1.16 rows=1 width=12) (actual time=0.819..0.819 rows=1 loops=1,133)

  • Order: tbl_6."time
  • Chunks excluded during runtime: 25
27. 0.000 0.000 ↓ 0.0 0

Index Only Scan using "_hyper_16_11_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_11_chunk tbl_7 (cost=0.14..1.16 rows=1 width=8) (never executed)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= (min(tbl."time"))) AND ("time" <= ((min(tbl."time")) + '30 days'::interval)) AND (event = 'Location Details'::text))
  • Heap Fetches: 0
28. 0.000 0.000 ↓ 0.0 0

Index Only Scan using "_hyper_16_13_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_13_chunk tbl_8 (cost=0.14..1.17 rows=1 width=8) (never executed)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= (min(tbl."time"))) AND ("time" <= ((min(tbl."time")) + '30 days'::interval)) AND (event = 'Location Details'::text))
  • Heap Fetches: 0
29. 0.000 0.000 ↓ 0.0 0

Index Only Scan using "_hyper_16_15_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_15_chunk tbl_9 (cost=0.14..1.17 rows=1 width=8) (never executed)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= (min(tbl."time"))) AND ("time" <= ((min(tbl."time")) + '30 days'::interval)) AND (event = 'Location Details'::text))
  • Heap Fetches: 0
30. 0.000 0.000 ↓ 0.0 0

Index Only Scan using "_hyper_16_17_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_17_chunk tbl_10 (cost=0.14..1.17 rows=1 width=8) (never executed)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= (min(tbl."time"))) AND ("time" <= ((min(tbl."time")) + '30 days'::interval)) AND (event = 'Location Details'::text))
  • Heap Fetches: 0
31. 0.000 0.000 ↓ 0.0 0

Index Only Scan using "_hyper_16_19_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_19_chunk tbl_11 (cost=0.14..1.17 rows=1 width=8) (never executed)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= (min(tbl."time"))) AND ("time" <= ((min(tbl."time")) + '30 days'::interval)) AND (event = 'Location Details'::text))
  • Heap Fetches: 0
32. 0.000 0.000 ↓ 0.0 0

Index Only Scan using "_hyper_16_21_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_21_chunk tbl_12 (cost=0.27..2.30 rows=1 width=8) (never executed)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= (min(tbl."time"))) AND ("time" <= ((min(tbl."time")) + '30 days'::interval)) AND (event = 'Location Details'::text))
  • Heap Fetches: 0
33. 0.000 0.000 ↓ 0.0 0

Index Only Scan using "_hyper_16_23_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_23_chunk tbl_13 (cost=0.28..1.30 rows=1 width=8) (never executed)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= (min(tbl."time"))) AND ("time" <= ((min(tbl."time")) + '30 days'::interval)) AND (event = 'Location Details'::text))
  • Heap Fetches: 0
34. 0.000 0.000 ↓ 0.0 0

Index Only Scan using "_hyper_16_25_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_25_chunk tbl_14 (cost=0.28..2.30 rows=1 width=8) (never executed)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= (min(tbl."time"))) AND ("time" <= ((min(tbl."time")) + '30 days'::interval)) AND (event = 'Location Details'::text))
  • Heap Fetches: 0
35. 0.000 0.000 ↓ 0.0 0

Index Only Scan using "_hyper_16_27_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_27_chunk tbl_15 (cost=0.28..1.30 rows=1 width=8) (never executed)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= (min(tbl."time"))) AND ("time" <= ((min(tbl."time")) + '30 days'::interval)) AND (event = 'Location Details'::text))
  • Heap Fetches: 0
36. 0.000 0.000 ↓ 0.0 0

Index Only Scan using "_hyper_16_29_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_29_chunk tbl_16 (cost=0.28..1.30 rows=1 width=8) (never executed)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= (min(tbl."time"))) AND ("time" <= ((min(tbl."time")) + '30 days'::interval)) AND (event = 'Location Details'::text))
  • Heap Fetches: 0
37. 0.000 0.000 ↓ 0.0 0

Index Only Scan using "_hyper_16_31_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_31_chunk tbl_17 (cost=0.28..1.30 rows=1 width=8) (never executed)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= (min(tbl."time"))) AND ("time" <= ((min(tbl."time")) + '30 days'::interval)) AND (event = 'Location Details'::text))
  • Heap Fetches: 0
38. 0.000 0.000 ↓ 0.0 0

Index Only Scan using "_hyper_16_33_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_33_chunk tbl_18 (cost=0.28..2.31 rows=1 width=8) (never executed)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= (min(tbl."time"))) AND ("time" <= ((min(tbl."time")) + '30 days'::interval)) AND (event = 'Location Details'::text))
  • Heap Fetches: 0
39. 0.000 0.000 ↓ 0.0 0

Index Only Scan using "_hyper_16_35_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_35_chunk tbl_19 (cost=0.28..1.31 rows=1 width=8) (never executed)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= (min(tbl."time"))) AND ("time" <= ((min(tbl."time")) + '30 days'::interval)) AND (event = 'Location Details'::text))
  • Heap Fetches: 0
40. 0.000 0.000 ↓ 0.0 0

Index Only Scan using "_hyper_16_37_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_37_chunk tbl_20 (cost=0.28..1.30 rows=1 width=8) (never executed)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= (min(tbl."time"))) AND ("time" <= ((min(tbl."time")) + '30 days'::interval)) AND (event = 'Location Details'::text))
  • Heap Fetches: 0
41. 0.000 0.000 ↓ 0.0 0

Index Only Scan using "_hyper_16_39_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_39_chunk tbl_21 (cost=0.28..1.31 rows=1 width=8) (never executed)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= (min(tbl."time"))) AND ("time" <= ((min(tbl."time")) + '30 days'::interval)) AND (event = 'Location Details'::text))
  • Heap Fetches: 0
42. 0.000 0.000 ↓ 0.0 0

Index Only Scan using "_hyper_16_40_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_40_chunk tbl_22 (cost=0.29..1.31 rows=1 width=8) (never executed)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= (min(tbl."time"))) AND ("time" <= ((min(tbl."time")) + '30 days'::interval)) AND (event = 'Location Details'::text))
  • Heap Fetches: 0
43. 0.000 0.000 ↓ 0.0 0

Index Only Scan using "_hyper_16_43_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_43_chunk tbl_23 (cost=0.28..1.31 rows=1 width=8) (never executed)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= (min(tbl."time"))) AND ("time" <= ((min(tbl."time")) + '30 days'::interval)) AND (event = 'Location Details'::text))
  • Heap Fetches: 0
44. 0.000 0.000 ↓ 0.0 0

Index Only Scan using "_hyper_16_45_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_45_chunk tbl_24 (cost=0.29..1.31 rows=1 width=8) (never executed)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= (min(tbl."time"))) AND ("time" <= ((min(tbl."time")) + '30 days'::interval)) AND (event = 'Location Details'::text))
  • Heap Fetches: 0
45. 0.000 0.000 ↓ 0.0 0

Index Only Scan using "_hyper_16_47_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_47_chunk tbl_25 (cost=0.28..1.31 rows=1 width=8) (never executed)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= (min(tbl."time"))) AND ("time" <= ((min(tbl."time")) + '30 days'::interval)) AND (event = 'Location Details'::text))
  • Heap Fetches: 0
46. 0.000 0.000 ↓ 0.0 0

Index Only Scan using "_hyper_16_49_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_49_chunk tbl_26 (cost=0.28..1.31 rows=1 width=8) (never executed)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= (min(tbl."time"))) AND ("time" <= ((min(tbl."time")) + '30 days'::interval)) AND (event = 'Location Details'::text))
  • Heap Fetches: 0
47. 0.000 0.000 ↓ 0.0 0

Index Only Scan using "_hyper_16_51_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_51_chunk tbl_27 (cost=0.41..2.44 rows=1 width=8) (never executed)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= (min(tbl."time"))) AND ("time" <= ((min(tbl."time")) + '30 days'::interval)) AND (event = 'Location Details'::text))
  • Heap Fetches: 0
48. 0.000 0.000 ↓ 0.0 0

Index Only Scan using "_hyper_16_53_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_53_chunk tbl_28 (cost=0.29..2.31 rows=1 width=8) (never executed)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= (min(tbl."time"))) AND ("time" <= ((min(tbl."time")) + '30 days'::interval)) AND (event = 'Location Details'::text))
  • Heap Fetches: 0
49. 0.000 0.000 ↓ 0.0 0

Index Only Scan using "_hyper_16_55_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_55_chunk tbl_29 (cost=0.29..2.31 rows=1 width=8) (never executed)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= (min(tbl."time"))) AND ("time" <= ((min(tbl."time")) + '30 days'::interval)) AND (event = 'Location Details'::text))
  • Heap Fetches: 0
50. 32.851 32.851 ↓ 0.0 0 91

Index Only Scan using "_hyper_16_57_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_57_chunk tbl_30 (cost=0.29..2.31 rows=1 width=8) (actual time=0.361..0.361 rows=0 loops=91)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= (min(tbl."time"))) AND ("time" <= ((min(tbl."time")) + '30 days'::interval)) AND (event = 'Location Details'::text))
  • Heap Fetches: 45
51. 80.736 80.736 ↑ 1.0 1 348

Index Only Scan using "_hyper_16_59_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_59_chunk tbl_31 (cost=0.29..2.31 rows=1 width=8) (actual time=0.232..0.232 rows=1 loops=348)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= (min(tbl."time"))) AND ("time" <= ((min(tbl."time")) + '30 days'::interval)) AND (event = 'Location Details'::text))
  • Heap Fetches: 177
52. 68.586 68.586 ↓ 0.0 0 426

Index Only Scan using "_hyper_16_61_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_61_chunk tbl_32 (cost=0.29..2.31 rows=1 width=8) (actual time=0.161..0.161 rows=0 loops=426)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= (min(tbl."time"))) AND ("time" <= ((min(tbl."time")) + '30 days'::interval)) AND (event = 'Location Details'::text))
  • Heap Fetches: 159
53. 90.090 90.090 ↓ 0.0 0 495

Index Scan using "63_183_PK_e5cf5cfc2b74171115175cf9b5e" on _hyper_16_63_chunk tbl_33 (cost=0.29..2.31 rows=1 width=8) (actual time=0.182..0.182 rows=0 loops=495)

  • Index Cond: ((("trackedUserId")::text = (tbl."trackedUserId")::text) AND ("time" >= (min(tbl."time"))) AND ("time" <= ((min(tbl."time")) + '30 days'::interval)))
  • Filter: ((event)::text = 'Location Details'::text)
  • Rows Removed by Filter: 0
54. 111.672 111.672 ↓ 0.0 0 594

Index Only Scan using "_hyper_16_65_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_65_chunk tbl_34 (cost=0.29..2.31 rows=1 width=8) (actual time=0.188..0.188 rows=0 loops=594)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= (min(tbl."time"))) AND ("time" <= ((min(tbl."time")) + '30 days'::interval)) AND (event = 'Location Details'::text))
  • Heap Fetches: 147
55. 13.282 13.282 ↓ 0.0 0 458

Index Only Scan using "_hyper_16_67_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_67_chunk tbl_35 (cost=0.28..2.30 rows=1 width=8) (actual time=0.029..0.029 rows=0 loops=458)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= (min(tbl."time"))) AND ("time" <= ((min(tbl."time")) + '30 days'::interval)) AND (event = 'Location Details'::text))
  • Heap Fetches: 7
56. 141.625 589.160 ↓ 0.0 0 1,133

Limit (cost=0.14..1.16 rows=1 width=12) (actual time=0.520..0.520 rows=0 loops=1,133)

57. 386.611 447.535 ↓ 0.0 0 1,133

Custom Scan (ChunkAppend) on user_events tbl_36 (cost=0.14..1.16 rows=1 width=12) (actual time=0.395..0.395 rows=0 loops=1,133)

  • Order: tbl_36."time
  • Chunks excluded during runtime: 15
58. 0.451 0.451 ↓ 0.0 0 451

Index Only Scan using "_hyper_16_11_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_11_chunk tbl_37 (cost=0.14..1.16 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=451)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_6."time") AND ("time" <= (tbl_6."time" + '30 days'::interval)) AND (event = 'Hiring Type'::text))
  • Heap Fetches: 0
59. 0.451 0.451 ↓ 0.0 0 451

Index Only Scan using "_hyper_16_13_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_13_chunk tbl_38 (cost=0.14..1.17 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=451)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_6."time") AND ("time" <= (tbl_6."time" + '30 days'::interval)) AND (event = 'Hiring Type'::text))
  • Heap Fetches: 0
60. 0.902 0.902 ↓ 0.0 0 451

Index Only Scan using "_hyper_16_15_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_15_chunk tbl_39 (cost=0.14..1.17 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=451)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_6."time") AND ("time" <= (tbl_6."time" + '30 days'::interval)) AND (event = 'Hiring Type'::text))
  • Heap Fetches: 0
61. 0.451 0.451 ↓ 0.0 0 451

Index Only Scan using "_hyper_16_17_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_17_chunk tbl_40 (cost=0.14..1.17 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=451)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_6."time") AND ("time" <= (tbl_6."time" + '30 days'::interval)) AND (event = 'Hiring Type'::text))
  • Heap Fetches: 0
62. 0.451 0.451 ↓ 0.0 0 451

Index Only Scan using "_hyper_16_19_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_19_chunk tbl_41 (cost=0.14..1.17 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=451)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_6."time") AND ("time" <= (tbl_6."time" + '30 days'::interval)) AND (event = 'Hiring Type'::text))
  • Heap Fetches: 0
63. 0.451 0.451 ↓ 0.0 0 451

Index Only Scan using "_hyper_16_21_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_21_chunk tbl_42 (cost=0.27..2.30 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=451)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_6."time") AND ("time" <= (tbl_6."time" + '30 days'::interval)) AND (event = 'Hiring Type'::text))
  • Heap Fetches: 0
64. 0.902 0.902 ↓ 0.0 0 451

Index Only Scan using "_hyper_16_23_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_23_chunk tbl_43 (cost=0.28..1.30 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=451)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_6."time") AND ("time" <= (tbl_6."time" + '30 days'::interval)) AND (event = 'Hiring Type'::text))
  • Heap Fetches: 0
65. 0.451 0.451 ↓ 0.0 0 451

Index Only Scan using "_hyper_16_25_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_25_chunk tbl_44 (cost=0.28..2.30 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=451)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_6."time") AND ("time" <= (tbl_6."time" + '30 days'::interval)) AND (event = 'Hiring Type'::text))
  • Heap Fetches: 0
66. 0.451 0.451 ↓ 0.0 0 451

Index Only Scan using "_hyper_16_27_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_27_chunk tbl_45 (cost=0.28..1.30 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=451)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_6."time") AND ("time" <= (tbl_6."time" + '30 days'::interval)) AND (event = 'Hiring Type'::text))
  • Heap Fetches: 0
67. 0.451 0.451 ↓ 0.0 0 451

Index Only Scan using "_hyper_16_29_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_29_chunk tbl_46 (cost=0.28..1.30 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=451)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_6."time") AND ("time" <= (tbl_6."time" + '30 days'::interval)) AND (event = 'Hiring Type'::text))
  • Heap Fetches: 0
68. 0.451 0.451 ↓ 0.0 0 451

Index Only Scan using "_hyper_16_31_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_31_chunk tbl_47 (cost=0.28..1.30 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=451)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_6."time") AND ("time" <= (tbl_6."time" + '30 days'::interval)) AND (event = 'Hiring Type'::text))
  • Heap Fetches: 0
69. 0.451 0.451 ↓ 0.0 0 451

Index Only Scan using "_hyper_16_33_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_33_chunk tbl_48 (cost=0.28..2.31 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=451)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_6."time") AND ("time" <= (tbl_6."time" + '30 days'::interval)) AND (event = 'Hiring Type'::text))
  • Heap Fetches: 0
70. 0.451 0.451 ↓ 0.0 0 451

Index Only Scan using "_hyper_16_35_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_35_chunk tbl_49 (cost=0.28..1.31 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=451)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_6."time") AND ("time" <= (tbl_6."time" + '30 days'::interval)) AND (event = 'Hiring Type'::text))
  • Heap Fetches: 0
71. 0.451 0.451 ↓ 0.0 0 451

Index Only Scan using "_hyper_16_37_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_37_chunk tbl_50 (cost=0.28..1.30 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=451)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_6."time") AND ("time" <= (tbl_6."time" + '30 days'::interval)) AND (event = 'Hiring Type'::text))
  • Heap Fetches: 0
72. 0.451 0.451 ↓ 0.0 0 451

Index Only Scan using "_hyper_16_39_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_39_chunk tbl_51 (cost=0.28..1.31 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=451)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_6."time") AND ("time" <= (tbl_6."time" + '30 days'::interval)) AND (event = 'Hiring Type'::text))
  • Heap Fetches: 0
73. 0.451 0.451 ↓ 0.0 0 451

Index Only Scan using "_hyper_16_40_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_40_chunk tbl_52 (cost=0.29..1.31 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=451)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_6."time") AND ("time" <= (tbl_6."time" + '30 days'::interval)) AND (event = 'Hiring Type'::text))
  • Heap Fetches: 0
74. 0.451 0.451 ↓ 0.0 0 451

Index Only Scan using "_hyper_16_43_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_43_chunk tbl_53 (cost=0.28..1.31 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=451)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_6."time") AND ("time" <= (tbl_6."time" + '30 days'::interval)) AND (event = 'Hiring Type'::text))
  • Heap Fetches: 0
75. 0.451 0.451 ↓ 0.0 0 451

Index Only Scan using "_hyper_16_45_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_45_chunk tbl_54 (cost=0.29..1.31 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=451)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_6."time") AND ("time" <= (tbl_6."time" + '30 days'::interval)) AND (event = 'Hiring Type'::text))
  • Heap Fetches: 0
76. 0.451 0.451 ↓ 0.0 0 451

Index Only Scan using "_hyper_16_47_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_47_chunk tbl_55 (cost=0.28..1.31 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=451)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_6."time") AND ("time" <= (tbl_6."time" + '30 days'::interval)) AND (event = 'Hiring Type'::text))
  • Heap Fetches: 0
77. 0.451 0.451 ↓ 0.0 0 451

Index Only Scan using "_hyper_16_49_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_49_chunk tbl_56 (cost=0.28..1.31 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=451)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_6."time") AND ("time" <= (tbl_6."time" + '30 days'::interval)) AND (event = 'Hiring Type'::text))
  • Heap Fetches: 0
78. 0.451 0.451 ↓ 0.0 0 451

Index Only Scan using "_hyper_16_51_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_51_chunk tbl_57 (cost=0.41..2.44 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=451)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_6."time") AND ("time" <= (tbl_6."time" + '30 days'::interval)) AND (event = 'Hiring Type'::text))
  • Heap Fetches: 0
79. 4.510 4.510 ↓ 0.0 0 451

Index Only Scan using "_hyper_16_53_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_53_chunk tbl_58 (cost=0.29..2.31 rows=1 width=8) (actual time=0.010..0.010 rows=0 loops=451)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_6."time") AND ("time" <= (tbl_6."time" + '30 days'::interval)) AND (event = 'Hiring Type'::text))
  • Heap Fetches: 0
80. 0.451 0.451 ↓ 0.0 0 451

Index Only Scan using "_hyper_16_55_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_55_chunk tbl_59 (cost=0.29..2.31 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=451)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_6."time") AND ("time" <= (tbl_6."time" + '30 days'::interval)) AND (event = 'Hiring Type'::text))
  • Heap Fetches: 0
81. 0.992 0.992 ↓ 0.0 0 496

Index Only Scan using "_hyper_16_57_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_57_chunk tbl_60 (cost=0.29..2.31 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=496)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_6."time") AND ("time" <= (tbl_6."time" + '30 days'::interval)) AND (event = 'Hiring Type'::text))
  • Heap Fetches: 40
82. 12.027 12.027 ↓ 0.0 0 633

Index Only Scan using "_hyper_16_59_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_59_chunk tbl_61 (cost=0.29..2.31 rows=1 width=8) (actual time=0.019..0.019 rows=0 loops=633)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_6."time") AND ("time" <= (tbl_6."time" + '30 days'::interval)) AND (event = 'Hiring Type'::text))
  • Heap Fetches: 170
83. 10.574 10.574 ↓ 0.0 0 622

Index Only Scan using "_hyper_16_61_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_61_chunk tbl_62 (cost=0.29..2.31 rows=1 width=8) (actual time=0.017..0.017 rows=0 loops=622)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_6."time") AND ("time" <= (tbl_6."time" + '30 days'::interval)) AND (event = 'Hiring Type'::text))
  • Heap Fetches: 146
84. 8.722 8.722 ↓ 0.0 0 623

Index Scan using "63_183_PK_e5cf5cfc2b74171115175cf9b5e" on _hyper_16_63_chunk tbl_63 (cost=0.29..2.31 rows=1 width=8) (actual time=0.014..0.014 rows=0 loops=623)

  • Index Cond: ((("trackedUserId")::text = (tbl."trackedUserId")::text) AND ("time" >= tbl_6."time") AND ("time" <= (tbl_6."time" + '30 days'::interval)))
  • Filter: ((event)::text = 'Hiring Type'::text)
  • Rows Removed by Filter: 1
85. 9.930 9.930 ↓ 0.0 0 662

Index Only Scan using "_hyper_16_65_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_65_chunk tbl_64 (cost=0.29..2.31 rows=1 width=8) (actual time=0.015..0.015 rows=0 loops=662)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_6."time") AND ("time" <= (tbl_6."time" + '30 days'::interval)) AND (event = 'Hiring Type'::text))
  • Heap Fetches: 0
86. 3.345 3.345 ↓ 0.0 0 669

Index Only Scan using "_hyper_16_67_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_67_chunk tbl_65 (cost=0.28..2.30 rows=1 width=8) (actual time=0.005..0.005 rows=0 loops=669)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_6."time") AND ("time" <= (tbl_6."time" + '30 days'::interval)) AND (event = 'Hiring Type'::text))
  • Heap Fetches: 0
87. 151.822 600.490 ↓ 0.0 0 1,133

Limit (cost=0.14..1.16 rows=1 width=12) (actual time=0.530..0.530 rows=0 loops=1,133)

88. 392.727 448.668 ↓ 0.0 0 1,133

Custom Scan (ChunkAppend) on user_events tbl_66 (cost=0.14..1.16 rows=1 width=12) (actual time=0.396..0.396 rows=0 loops=1,133)

  • Order: tbl_66."time
  • Chunks excluded during runtime: 10
89. 6.690 6.690 ↓ 0.0 0 669

Index Only Scan using "_hyper_16_11_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_11_chunk tbl_67 (cost=0.14..1.16 rows=1 width=8) (actual time=0.010..0.010 rows=0 loops=669)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_36."time") AND ("time" <= (tbl_36."time" + '30 days'::interval)) AND (event = 'Hourly Rate'::text))
  • Heap Fetches: 0
90. 0.669 0.669 ↓ 0.0 0 669

Index Only Scan using "_hyper_16_13_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_13_chunk tbl_68 (cost=0.14..1.17 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=669)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_36."time") AND ("time" <= (tbl_36."time" + '30 days'::interval)) AND (event = 'Hourly Rate'::text))
  • Heap Fetches: 0
91. 1.338 1.338 ↓ 0.0 0 669

Index Only Scan using "_hyper_16_15_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_15_chunk tbl_69 (cost=0.14..1.17 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=669)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_36."time") AND ("time" <= (tbl_36."time" + '30 days'::interval)) AND (event = 'Hourly Rate'::text))
  • Heap Fetches: 0
92. 0.669 0.669 ↓ 0.0 0 669

Index Only Scan using "_hyper_16_17_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_17_chunk tbl_70 (cost=0.14..1.17 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=669)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_36."time") AND ("time" <= (tbl_36."time" + '30 days'::interval)) AND (event = 'Hourly Rate'::text))
  • Heap Fetches: 0
93. 0.669 0.669 ↓ 0.0 0 669

Index Only Scan using "_hyper_16_19_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_19_chunk tbl_71 (cost=0.14..1.17 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=669)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_36."time") AND ("time" <= (tbl_36."time" + '30 days'::interval)) AND (event = 'Hourly Rate'::text))
  • Heap Fetches: 0
94. 0.669 0.669 ↓ 0.0 0 669

Index Only Scan using "_hyper_16_21_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_21_chunk tbl_72 (cost=0.27..2.30 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=669)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_36."time") AND ("time" <= (tbl_36."time" + '30 days'::interval)) AND (event = 'Hourly Rate'::text))
  • Heap Fetches: 0
95. 0.669 0.669 ↓ 0.0 0 669

Index Only Scan using "_hyper_16_23_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_23_chunk tbl_73 (cost=0.28..1.30 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=669)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_36."time") AND ("time" <= (tbl_36."time" + '30 days'::interval)) AND (event = 'Hourly Rate'::text))
  • Heap Fetches: 0
96. 0.669 0.669 ↓ 0.0 0 669

Index Only Scan using "_hyper_16_25_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_25_chunk tbl_74 (cost=0.28..2.30 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=669)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_36."time") AND ("time" <= (tbl_36."time" + '30 days'::interval)) AND (event = 'Hourly Rate'::text))
  • Heap Fetches: 0
97. 0.669 0.669 ↓ 0.0 0 669

Index Only Scan using "_hyper_16_27_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_27_chunk tbl_75 (cost=0.28..1.30 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=669)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_36."time") AND ("time" <= (tbl_36."time" + '30 days'::interval)) AND (event = 'Hourly Rate'::text))
  • Heap Fetches: 0
98. 0.669 0.669 ↓ 0.0 0 669

Index Only Scan using "_hyper_16_29_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_29_chunk tbl_76 (cost=0.28..1.30 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=669)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_36."time") AND ("time" <= (tbl_36."time" + '30 days'::interval)) AND (event = 'Hourly Rate'::text))
  • Heap Fetches: 0
99. 0.669 0.669 ↓ 0.0 0 669

Index Only Scan using "_hyper_16_31_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_31_chunk tbl_77 (cost=0.28..1.30 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=669)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_36."time") AND ("time" <= (tbl_36."time" + '30 days'::interval)) AND (event = 'Hourly Rate'::text))
  • Heap Fetches: 0
100. 0.669 0.669 ↓ 0.0 0 669

Index Only Scan using "_hyper_16_33_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_33_chunk tbl_78 (cost=0.28..2.31 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=669)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_36."time") AND ("time" <= (tbl_36."time" + '30 days'::interval)) AND (event = 'Hourly Rate'::text))
  • Heap Fetches: 0
101. 0.669 0.669 ↓ 0.0 0 669

Index Only Scan using "_hyper_16_35_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_35_chunk tbl_79 (cost=0.28..1.31 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=669)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_36."time") AND ("time" <= (tbl_36."time" + '30 days'::interval)) AND (event = 'Hourly Rate'::text))
  • Heap Fetches: 0
102. 2.007 2.007 ↓ 0.0 0 669

Index Only Scan using "_hyper_16_37_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_37_chunk tbl_80 (cost=0.28..1.30 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=669)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_36."time") AND ("time" <= (tbl_36."time" + '30 days'::interval)) AND (event = 'Hourly Rate'::text))
  • Heap Fetches: 0
103. 0.669 0.669 ↓ 0.0 0 669

Index Only Scan using "_hyper_16_39_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_39_chunk tbl_81 (cost=0.28..1.31 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=669)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_36."time") AND ("time" <= (tbl_36."time" + '30 days'::interval)) AND (event = 'Hourly Rate'::text))
  • Heap Fetches: 0
104. 0.669 0.669 ↓ 0.0 0 669

Index Only Scan using "_hyper_16_40_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_40_chunk tbl_82 (cost=0.29..1.31 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=669)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_36."time") AND ("time" <= (tbl_36."time" + '30 days'::interval)) AND (event = 'Hourly Rate'::text))
  • Heap Fetches: 0
105. 0.669 0.669 ↓ 0.0 0 669

Index Only Scan using "_hyper_16_43_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_43_chunk tbl_83 (cost=0.28..1.31 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=669)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_36."time") AND ("time" <= (tbl_36."time" + '30 days'::interval)) AND (event = 'Hourly Rate'::text))
  • Heap Fetches: 0
106. 0.669 0.669 ↓ 0.0 0 669

Index Only Scan using "_hyper_16_45_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_45_chunk tbl_84 (cost=0.29..1.31 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=669)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_36."time") AND ("time" <= (tbl_36."time" + '30 days'::interval)) AND (event = 'Hourly Rate'::text))
  • Heap Fetches: 0
107. 0.669 0.669 ↓ 0.0 0 669

Index Only Scan using "_hyper_16_47_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_47_chunk tbl_85 (cost=0.28..1.31 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=669)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_36."time") AND ("time" <= (tbl_36."time" + '30 days'::interval)) AND (event = 'Hourly Rate'::text))
  • Heap Fetches: 0
108. 0.669 0.669 ↓ 0.0 0 669

Index Only Scan using "_hyper_16_49_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_49_chunk tbl_86 (cost=0.28..1.31 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=669)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_36."time") AND ("time" <= (tbl_36."time" + '30 days'::interval)) AND (event = 'Hourly Rate'::text))
  • Heap Fetches: 0
109. 0.669 0.669 ↓ 0.0 0 669

Index Only Scan using "_hyper_16_51_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_51_chunk tbl_87 (cost=0.41..2.44 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=669)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_36."time") AND ("time" <= (tbl_36."time" + '30 days'::interval)) AND (event = 'Hourly Rate'::text))
  • Heap Fetches: 0
110. 0.669 0.669 ↓ 0.0 0 669

Index Only Scan using "_hyper_16_53_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_53_chunk tbl_88 (cost=0.29..2.31 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=669)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_36."time") AND ("time" <= (tbl_36."time" + '30 days'::interval)) AND (event = 'Hourly Rate'::text))
  • Heap Fetches: 0
111. 0.669 0.669 ↓ 0.0 0 669

Index Only Scan using "_hyper_16_55_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_55_chunk tbl_89 (cost=0.29..2.31 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=669)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_36."time") AND ("time" <= (tbl_36."time" + '30 days'::interval)) AND (event = 'Hourly Rate'::text))
  • Heap Fetches: 0
112. 0.709 0.709 ↓ 0.0 0 709

Index Only Scan using "_hyper_16_57_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_57_chunk tbl_90 (cost=0.29..2.31 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=709)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_36."time") AND ("time" <= (tbl_36."time" + '30 days'::interval)) AND (event = 'Hourly Rate'::text))
  • Heap Fetches: 39
113. 7.560 7.560 ↓ 0.0 0 840

Index Only Scan using "_hyper_16_59_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_59_chunk tbl_91 (cost=0.29..2.31 rows=1 width=8) (actual time=0.009..0.009 rows=0 loops=840)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_36."time") AND ("time" <= (tbl_36."time" + '30 days'::interval)) AND (event = 'Hourly Rate'::text))
  • Heap Fetches: 148
114. 4.190 4.190 ↓ 0.0 0 838

Index Only Scan using "_hyper_16_61_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_61_chunk tbl_92 (cost=0.29..2.31 rows=1 width=8) (actual time=0.005..0.005 rows=0 loops=838)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_36."time") AND ("time" <= (tbl_36."time" + '30 days'::interval)) AND (event = 'Hourly Rate'::text))
  • Heap Fetches: 121
115. 15.675 15.675 ↓ 0.0 0 825

Index Scan using "63_183_PK_e5cf5cfc2b74171115175cf9b5e" on _hyper_16_63_chunk tbl_93 (cost=0.29..2.31 rows=1 width=8) (actual time=0.019..0.019 rows=0 loops=825)

  • Index Cond: ((("trackedUserId")::text = (tbl."trackedUserId")::text) AND ("time" >= tbl_36."time") AND ("time" <= (tbl_36."time" + '30 days'::interval)))
  • Filter: ((event)::text = 'Hourly Rate'::text)
  • Rows Removed by Filter: 0
116. 3.660 3.660 ↓ 0.0 0 732

Index Only Scan using "_hyper_16_65_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_65_chunk tbl_94 (cost=0.29..2.31 rows=1 width=8) (actual time=0.005..0.005 rows=0 loops=732)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_36."time") AND ("time" <= (tbl_36."time" + '30 days'::interval)) AND (event = 'Hourly Rate'::text))
  • Heap Fetches: 0
117. 0.732 0.732 ↓ 0.0 0 732

Index Only Scan using "_hyper_16_67_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_67_chunk tbl_95 (cost=0.28..2.30 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=732)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_36."time") AND ("time" <= (tbl_36."time" + '30 days'::interval)) AND (event = 'Hourly Rate'::text))
  • Heap Fetches: 0
118. 142.758 560.835 ↓ 0.0 0 1,133

Limit (cost=0.14..1.16 rows=1 width=12) (actual time=0.495..0.495 rows=0 loops=1,133)

119. 372.204 418.077 ↓ 0.0 0 1,133

Custom Scan (ChunkAppend) on user_events tbl_96 (cost=0.14..1.16 rows=1 width=12) (actual time=0.369..0.369 rows=0 loops=1,133)

  • Order: tbl_96."time
  • Chunks excluded during runtime: 8
120. 1.464 1.464 ↓ 0.0 0 732

Index Only Scan using "_hyper_16_11_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_11_chunk tbl_97 (cost=0.14..1.16 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=732)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_66."time") AND ("time" <= (tbl_66."time" + '30 days'::interval)) AND (event = 'Salary Expectation'::text))
  • Heap Fetches: 0
121. 0.732 0.732 ↓ 0.0 0 732

Index Only Scan using "_hyper_16_13_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_13_chunk tbl_98 (cost=0.14..1.17 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=732)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_66."time") AND ("time" <= (tbl_66."time" + '30 days'::interval)) AND (event = 'Salary Expectation'::text))
  • Heap Fetches: 0
122. 0.732 0.732 ↓ 0.0 0 732

Index Only Scan using "_hyper_16_15_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_15_chunk tbl_99 (cost=0.14..1.17 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=732)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_66."time") AND ("time" <= (tbl_66."time" + '30 days'::interval)) AND (event = 'Salary Expectation'::text))
  • Heap Fetches: 0
123. 0.732 0.732 ↓ 0.0 0 732

Index Only Scan using "_hyper_16_17_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_17_chunk tbl_100 (cost=0.14..1.17 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=732)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_66."time") AND ("time" <= (tbl_66."time" + '30 days'::interval)) AND (event = 'Salary Expectation'::text))
  • Heap Fetches: 0
124. 0.732 0.732 ↓ 0.0 0 732

Index Only Scan using "_hyper_16_19_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_19_chunk tbl_101 (cost=0.14..1.17 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=732)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_66."time") AND ("time" <= (tbl_66."time" + '30 days'::interval)) AND (event = 'Salary Expectation'::text))
  • Heap Fetches: 0
125. 0.732 0.732 ↓ 0.0 0 732

Index Only Scan using "_hyper_16_21_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_21_chunk tbl_102 (cost=0.27..2.30 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=732)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_66."time") AND ("time" <= (tbl_66."time" + '30 days'::interval)) AND (event = 'Salary Expectation'::text))
  • Heap Fetches: 0
126. 0.732 0.732 ↓ 0.0 0 732

Index Only Scan using "_hyper_16_23_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_23_chunk tbl_103 (cost=0.28..1.30 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=732)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_66."time") AND ("time" <= (tbl_66."time" + '30 days'::interval)) AND (event = 'Salary Expectation'::text))
  • Heap Fetches: 0
127. 0.732 0.732 ↓ 0.0 0 732

Index Only Scan using "_hyper_16_25_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_25_chunk tbl_104 (cost=0.28..2.30 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=732)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_66."time") AND ("time" <= (tbl_66."time" + '30 days'::interval)) AND (event = 'Salary Expectation'::text))
  • Heap Fetches: 0
128. 0.732 0.732 ↓ 0.0 0 732

Index Only Scan using "_hyper_16_27_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_27_chunk tbl_105 (cost=0.28..1.30 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=732)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_66."time") AND ("time" <= (tbl_66."time" + '30 days'::interval)) AND (event = 'Salary Expectation'::text))
  • Heap Fetches: 0
129. 0.732 0.732 ↓ 0.0 0 732

Index Only Scan using "_hyper_16_29_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_29_chunk tbl_106 (cost=0.28..1.30 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=732)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_66."time") AND ("time" <= (tbl_66."time" + '30 days'::interval)) AND (event = 'Salary Expectation'::text))
  • Heap Fetches: 0
130. 0.732 0.732 ↓ 0.0 0 732

Index Only Scan using "_hyper_16_31_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_31_chunk tbl_107 (cost=0.28..1.30 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=732)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_66."time") AND ("time" <= (tbl_66."time" + '30 days'::interval)) AND (event = 'Salary Expectation'::text))
  • Heap Fetches: 0
131. 0.732 0.732 ↓ 0.0 0 732

Index Only Scan using "_hyper_16_33_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_33_chunk tbl_108 (cost=0.28..2.31 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=732)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_66."time") AND ("time" <= (tbl_66."time" + '30 days'::interval)) AND (event = 'Salary Expectation'::text))
  • Heap Fetches: 0
132. 0.732 0.732 ↓ 0.0 0 732

Index Only Scan using "_hyper_16_35_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_35_chunk tbl_109 (cost=0.28..1.31 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=732)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_66."time") AND ("time" <= (tbl_66."time" + '30 days'::interval)) AND (event = 'Salary Expectation'::text))
  • Heap Fetches: 0
133. 0.732 0.732 ↓ 0.0 0 732

Index Only Scan using "_hyper_16_37_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_37_chunk tbl_110 (cost=0.28..1.30 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=732)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_66."time") AND ("time" <= (tbl_66."time" + '30 days'::interval)) AND (event = 'Salary Expectation'::text))
  • Heap Fetches: 0
134. 0.732 0.732 ↓ 0.0 0 732

Index Only Scan using "_hyper_16_39_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_39_chunk tbl_111 (cost=0.28..1.31 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=732)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_66."time") AND ("time" <= (tbl_66."time" + '30 days'::interval)) AND (event = 'Salary Expectation'::text))
  • Heap Fetches: 0
135. 0.732 0.732 ↓ 0.0 0 732

Index Only Scan using "_hyper_16_40_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_40_chunk tbl_112 (cost=0.29..1.31 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=732)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_66."time") AND ("time" <= (tbl_66."time" + '30 days'::interval)) AND (event = 'Salary Expectation'::text))
  • Heap Fetches: 0
136. 0.732 0.732 ↓ 0.0 0 732

Index Only Scan using "_hyper_16_43_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_43_chunk tbl_113 (cost=0.28..1.31 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=732)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_66."time") AND ("time" <= (tbl_66."time" + '30 days'::interval)) AND (event = 'Salary Expectation'::text))
  • Heap Fetches: 0
137. 0.732 0.732 ↓ 0.0 0 732

Index Only Scan using "_hyper_16_45_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_45_chunk tbl_114 (cost=0.29..1.31 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=732)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_66."time") AND ("time" <= (tbl_66."time" + '30 days'::interval)) AND (event = 'Salary Expectation'::text))
  • Heap Fetches: 0
138. 0.732 0.732 ↓ 0.0 0 732

Index Only Scan using "_hyper_16_47_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_47_chunk tbl_115 (cost=0.28..1.31 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=732)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_66."time") AND ("time" <= (tbl_66."time" + '30 days'::interval)) AND (event = 'Salary Expectation'::text))
  • Heap Fetches: 0
139. 0.732 0.732 ↓ 0.0 0 732

Index Only Scan using "_hyper_16_49_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_49_chunk tbl_116 (cost=0.28..1.31 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=732)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_66."time") AND ("time" <= (tbl_66."time" + '30 days'::interval)) AND (event = 'Salary Expectation'::text))
  • Heap Fetches: 0
140. 0.732 0.732 ↓ 0.0 0 732

Index Only Scan using "_hyper_16_51_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_51_chunk tbl_117 (cost=0.41..2.44 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=732)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_66."time") AND ("time" <= (tbl_66."time" + '30 days'::interval)) AND (event = 'Salary Expectation'::text))
  • Heap Fetches: 0
141. 0.732 0.732 ↓ 0.0 0 732

Index Only Scan using "_hyper_16_53_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_53_chunk tbl_118 (cost=0.29..2.31 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=732)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_66."time") AND ("time" <= (tbl_66."time" + '30 days'::interval)) AND (event = 'Salary Expectation'::text))
  • Heap Fetches: 0
142. 0.732 0.732 ↓ 0.0 0 732

Index Only Scan using "_hyper_16_55_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_55_chunk tbl_119 (cost=0.29..2.31 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=732)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_66."time") AND ("time" <= (tbl_66."time" + '30 days'::interval)) AND (event = 'Salary Expectation'::text))
  • Heap Fetches: 0
143. 0.771 0.771 ↓ 0.0 0 771

Index Only Scan using "_hyper_16_57_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_57_chunk tbl_120 (cost=0.29..2.31 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=771)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_66."time") AND ("time" <= (tbl_66."time" + '30 days'::interval)) AND (event = 'Salary Expectation'::text))
  • Heap Fetches: 34
144. 3.540 3.540 ↓ 0.0 0 885

Index Only Scan using "_hyper_16_59_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_59_chunk tbl_121 (cost=0.29..2.31 rows=1 width=8) (actual time=0.004..0.004 rows=0 loops=885)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_66."time") AND ("time" <= (tbl_66."time" + '30 days'::interval)) AND (event = 'Salary Expectation'::text))
  • Heap Fetches: 127
145. 6.153 6.153 ↓ 0.0 0 879

Index Only Scan using "_hyper_16_61_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_61_chunk tbl_122 (cost=0.29..2.31 rows=1 width=8) (actual time=0.007..0.007 rows=0 loops=879)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_66."time") AND ("time" <= (tbl_66."time" + '30 days'::interval)) AND (event = 'Salary Expectation'::text))
  • Heap Fetches: 107
146. 14.705 14.705 ↓ 0.0 0 865

Index Scan using "63_183_PK_e5cf5cfc2b74171115175cf9b5e" on _hyper_16_63_chunk tbl_123 (cost=0.29..2.31 rows=1 width=8) (actual time=0.017..0.017 rows=0 loops=865)

  • Index Cond: ((("trackedUserId")::text = (tbl."trackedUserId")::text) AND ("time" >= tbl_66."time") AND ("time" <= (tbl_66."time" + '30 days'::interval)))
  • Filter: ((event)::text = 'Salary Expectation'::text)
  • Rows Removed by Filter: 0
147. 2.352 2.352 ↓ 0.0 0 784

Index Only Scan using "_hyper_16_65_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_65_chunk tbl_124 (cost=0.29..2.31 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=784)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_66."time") AND ("time" <= (tbl_66."time" + '30 days'::interval)) AND (event = 'Salary Expectation'::text))
  • Heap Fetches: 0
148. 0.784 0.784 ↓ 0.0 0 784

Index Only Scan using "_hyper_16_67_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_67_chunk tbl_125 (cost=0.28..2.30 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=784)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_66."time") AND ("time" <= (tbl_66."time" + '30 days'::interval)) AND (event = 'Salary Expectation'::text))
  • Heap Fetches: 0
149. 157.487 595.958 ↓ 0.0 0 1,133

Limit (cost=0.14..1.16 rows=1 width=12) (actual time=0.526..0.526 rows=0 loops=1,133)

150. 380.348 438.471 ↓ 0.0 0 1,133

Custom Scan (ChunkAppend) on user_events tbl_126 (cost=0.14..1.16 rows=1 width=12) (actual time=0.387..0.387 rows=0 loops=1,133)

  • Order: tbl_126."time
  • Chunks excluded during runtime: 7
151. 4.704 4.704 ↓ 0.0 0 784

Index Only Scan using "_hyper_16_11_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_11_chunk tbl_127 (cost=0.14..1.16 rows=1 width=8) (actual time=0.006..0.006 rows=0 loops=784)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_96."time") AND ("time" <= (tbl_96."time" + '30 days'::interval)) AND (event = 'Available Date'::text))
  • Heap Fetches: 0
152. 0.784 0.784 ↓ 0.0 0 784

Index Only Scan using "_hyper_16_13_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_13_chunk tbl_128 (cost=0.14..1.17 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=784)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_96."time") AND ("time" <= (tbl_96."time" + '30 days'::interval)) AND (event = 'Available Date'::text))
  • Heap Fetches: 0
153. 0.784 0.784 ↓ 0.0 0 784

Index Only Scan using "_hyper_16_15_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_15_chunk tbl_129 (cost=0.14..1.17 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=784)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_96."time") AND ("time" <= (tbl_96."time" + '30 days'::interval)) AND (event = 'Available Date'::text))
  • Heap Fetches: 0
154. 0.784 0.784 ↓ 0.0 0 784

Index Only Scan using "_hyper_16_17_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_17_chunk tbl_130 (cost=0.14..1.17 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=784)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_96."time") AND ("time" <= (tbl_96."time" + '30 days'::interval)) AND (event = 'Available Date'::text))
  • Heap Fetches: 0
155. 0.784 0.784 ↓ 0.0 0 784

Index Only Scan using "_hyper_16_19_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_19_chunk tbl_131 (cost=0.14..1.17 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=784)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_96."time") AND ("time" <= (tbl_96."time" + '30 days'::interval)) AND (event = 'Available Date'::text))
  • Heap Fetches: 0
156. 0.784 0.784 ↓ 0.0 0 784

Index Only Scan using "_hyper_16_21_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_21_chunk tbl_132 (cost=0.27..2.30 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=784)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_96."time") AND ("time" <= (tbl_96."time" + '30 days'::interval)) AND (event = 'Available Date'::text))
  • Heap Fetches: 0
157. 0.784 0.784 ↓ 0.0 0 784

Index Only Scan using "_hyper_16_23_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_23_chunk tbl_133 (cost=0.28..1.30 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=784)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_96."time") AND ("time" <= (tbl_96."time" + '30 days'::interval)) AND (event = 'Available Date'::text))
  • Heap Fetches: 0
158. 0.784 0.784 ↓ 0.0 0 784

Index Only Scan using "_hyper_16_25_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_25_chunk tbl_134 (cost=0.28..2.30 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=784)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_96."time") AND ("time" <= (tbl_96."time" + '30 days'::interval)) AND (event = 'Available Date'::text))
  • Heap Fetches: 0
159. 0.784 0.784 ↓ 0.0 0 784

Index Only Scan using "_hyper_16_27_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_27_chunk tbl_135 (cost=0.28..1.30 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=784)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_96."time") AND ("time" <= (tbl_96."time" + '30 days'::interval)) AND (event = 'Available Date'::text))
  • Heap Fetches: 0
160. 0.784 0.784 ↓ 0.0 0 784

Index Only Scan using "_hyper_16_29_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_29_chunk tbl_136 (cost=0.28..1.30 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=784)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_96."time") AND ("time" <= (tbl_96."time" + '30 days'::interval)) AND (event = 'Available Date'::text))
  • Heap Fetches: 0
161. 0.784 0.784 ↓ 0.0 0 784

Index Only Scan using "_hyper_16_31_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_31_chunk tbl_137 (cost=0.28..1.30 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=784)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_96."time") AND ("time" <= (tbl_96."time" + '30 days'::interval)) AND (event = 'Available Date'::text))
  • Heap Fetches: 0
162. 0.784 0.784 ↓ 0.0 0 784

Index Only Scan using "_hyper_16_33_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_33_chunk tbl_138 (cost=0.28..2.31 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=784)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_96."time") AND ("time" <= (tbl_96."time" + '30 days'::interval)) AND (event = 'Available Date'::text))
  • Heap Fetches: 0
163. 0.784 0.784 ↓ 0.0 0 784

Index Only Scan using "_hyper_16_35_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_35_chunk tbl_139 (cost=0.28..1.31 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=784)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_96."time") AND ("time" <= (tbl_96."time" + '30 days'::interval)) AND (event = 'Available Date'::text))
  • Heap Fetches: 0
164. 0.784 0.784 ↓ 0.0 0 784

Index Only Scan using "_hyper_16_37_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_37_chunk tbl_140 (cost=0.28..1.30 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=784)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_96."time") AND ("time" <= (tbl_96."time" + '30 days'::interval)) AND (event = 'Available Date'::text))
  • Heap Fetches: 0
165. 0.784 0.784 ↓ 0.0 0 784

Index Only Scan using "_hyper_16_39_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_39_chunk tbl_141 (cost=0.28..1.31 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=784)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_96."time") AND ("time" <= (tbl_96."time" + '30 days'::interval)) AND (event = 'Available Date'::text))
  • Heap Fetches: 0
166. 0.784 0.784 ↓ 0.0 0 784

Index Only Scan using "_hyper_16_40_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_40_chunk tbl_142 (cost=0.29..1.31 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=784)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_96."time") AND ("time" <= (tbl_96."time" + '30 days'::interval)) AND (event = 'Available Date'::text))
  • Heap Fetches: 0
167. 3.920 3.920 ↓ 0.0 0 784

Index Only Scan using "_hyper_16_43_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_43_chunk tbl_143 (cost=0.28..1.31 rows=1 width=8) (actual time=0.005..0.005 rows=0 loops=784)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_96."time") AND ("time" <= (tbl_96."time" + '30 days'::interval)) AND (event = 'Available Date'::text))
  • Heap Fetches: 0
168. 0.784 0.784 ↓ 0.0 0 784

Index Only Scan using "_hyper_16_45_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_45_chunk tbl_144 (cost=0.29..1.31 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=784)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_96."time") AND ("time" <= (tbl_96."time" + '30 days'::interval)) AND (event = 'Available Date'::text))
  • Heap Fetches: 0
169. 0.784 0.784 ↓ 0.0 0 784

Index Only Scan using "_hyper_16_47_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_47_chunk tbl_145 (cost=0.28..1.31 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=784)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_96."time") AND ("time" <= (tbl_96."time" + '30 days'::interval)) AND (event = 'Available Date'::text))
  • Heap Fetches: 0
170. 1.568 1.568 ↓ 0.0 0 784

Index Only Scan using "_hyper_16_49_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_49_chunk tbl_146 (cost=0.28..1.31 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=784)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_96."time") AND ("time" <= (tbl_96."time" + '30 days'::interval)) AND (event = 'Available Date'::text))
  • Heap Fetches: 0
171. 0.784 0.784 ↓ 0.0 0 784

Index Only Scan using "_hyper_16_51_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_51_chunk tbl_147 (cost=0.41..2.44 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=784)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_96."time") AND ("time" <= (tbl_96."time" + '30 days'::interval)) AND (event = 'Available Date'::text))
  • Heap Fetches: 0
172. 0.784 0.784 ↓ 0.0 0 784

Index Only Scan using "_hyper_16_53_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_53_chunk tbl_148 (cost=0.29..2.31 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=784)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_96."time") AND ("time" <= (tbl_96."time" + '30 days'::interval)) AND (event = 'Available Date'::text))
  • Heap Fetches: 0
173. 0.784 0.784 ↓ 0.0 0 784

Index Only Scan using "_hyper_16_55_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_55_chunk tbl_149 (cost=0.29..2.31 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=784)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_96."time") AND ("time" <= (tbl_96."time" + '30 days'::interval)) AND (event = 'Available Date'::text))
  • Heap Fetches: 0
174. 4.090 4.090 ↓ 0.0 0 818

Index Only Scan using "_hyper_16_57_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_57_chunk tbl_150 (cost=0.29..2.31 rows=1 width=8) (actual time=0.005..0.005 rows=0 loops=818)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_96."time") AND ("time" <= (tbl_96."time" + '30 days'::interval)) AND (event = 'Available Date'::text))
  • Heap Fetches: 34
175. 10.021 10.021 ↓ 0.0 0 911

Index Only Scan using "_hyper_16_59_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_59_chunk tbl_151 (cost=0.29..2.31 rows=1 width=8) (actual time=0.011..0.011 rows=0 loops=911)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_96."time") AND ("time" <= (tbl_96."time" + '30 days'::interval)) AND (event = 'Available Date'::text))
  • Heap Fetches: 126
176. 2.676 2.676 ↓ 0.0 0 892

Index Only Scan using "_hyper_16_61_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_61_chunk tbl_152 (cost=0.29..2.31 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=892)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_96."time") AND ("time" <= (tbl_96."time" + '30 days'::interval)) AND (event = 'Available Date'::text))
  • Heap Fetches: 105
177. 13.888 13.888 ↓ 0.0 0 868

Index Scan using "63_183_PK_e5cf5cfc2b74171115175cf9b5e" on _hyper_16_63_chunk tbl_153 (cost=0.29..2.31 rows=1 width=8) (actual time=0.016..0.016 rows=0 loops=868)

  • Index Cond: ((("trackedUserId")::text = (tbl."trackedUserId")::text) AND ("time" >= tbl_96."time") AND ("time" <= (tbl_96."time" + '30 days'::interval)))
  • Filter: ((event)::text = 'Available Date'::text)
  • Rows Removed by Filter: 0
178. 0.788 0.788 ↓ 0.0 0 788

Index Only Scan using "_hyper_16_65_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_65_chunk tbl_154 (cost=0.29..2.31 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=788)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_96."time") AND ("time" <= (tbl_96."time" + '30 days'::interval)) AND (event = 'Available Date'::text))
  • Heap Fetches: 0
179. 0.788 0.788 ↓ 0.0 0 788

Index Only Scan using "_hyper_16_67_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_67_chunk tbl_155 (cost=0.28..2.30 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=788)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_96."time") AND ("time" <= (tbl_96."time" + '30 days'::interval)) AND (event = 'Available Date'::text))
  • Heap Fetches: 0
180. 147.290 588.027 ↓ 0.0 0 1,133

Limit (cost=0.14..1.16 rows=1 width=12) (actual time=0.519..0.519 rows=0 loops=1,133)

181. 390.647 440.737 ↓ 0.0 0 1,133

Custom Scan (ChunkAppend) on user_events tbl_156 (cost=0.14..1.16 rows=1 width=12) (actual time=0.389..0.389 rows=0 loops=1,133)

  • Order: tbl_156."time
  • Chunks excluded during runtime: 7
182. 0.788 0.788 ↓ 0.0 0 788

Index Only Scan using "_hyper_16_11_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_11_chunk tbl_157 (cost=0.14..1.16 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=788)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_126."time") AND ("time" <= (tbl_126."time" + '30 days'::interval)) AND (event = 'Available Hours'::text))
  • Heap Fetches: 0
183. 0.788 0.788 ↓ 0.0 0 788

Index Only Scan using "_hyper_16_13_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_13_chunk tbl_158 (cost=0.14..1.17 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=788)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_126."time") AND ("time" <= (tbl_126."time" + '30 days'::interval)) AND (event = 'Available Hours'::text))
  • Heap Fetches: 0
184. 4.728 4.728 ↓ 0.0 0 788

Index Only Scan using "_hyper_16_15_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_15_chunk tbl_159 (cost=0.14..1.17 rows=1 width=8) (actual time=0.006..0.006 rows=0 loops=788)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_126."time") AND ("time" <= (tbl_126."time" + '30 days'::interval)) AND (event = 'Available Hours'::text))
  • Heap Fetches: 0
185. 0.788 0.788 ↓ 0.0 0 788

Index Only Scan using "_hyper_16_17_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_17_chunk tbl_160 (cost=0.14..1.17 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=788)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_126."time") AND ("time" <= (tbl_126."time" + '30 days'::interval)) AND (event = 'Available Hours'::text))
  • Heap Fetches: 0
186. 0.788 0.788 ↓ 0.0 0 788

Index Only Scan using "_hyper_16_19_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_19_chunk tbl_161 (cost=0.14..1.17 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=788)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_126."time") AND ("time" <= (tbl_126."time" + '30 days'::interval)) AND (event = 'Available Hours'::text))
  • Heap Fetches: 0
187. 0.788 0.788 ↓ 0.0 0 788

Index Only Scan using "_hyper_16_21_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_21_chunk tbl_162 (cost=0.27..2.30 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=788)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_126."time") AND ("time" <= (tbl_126."time" + '30 days'::interval)) AND (event = 'Available Hours'::text))
  • Heap Fetches: 0
188. 0.788 0.788 ↓ 0.0 0 788

Index Only Scan using "_hyper_16_23_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_23_chunk tbl_163 (cost=0.28..1.30 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=788)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_126."time") AND ("time" <= (tbl_126."time" + '30 days'::interval)) AND (event = 'Available Hours'::text))
  • Heap Fetches: 0
189. 0.788 0.788 ↓ 0.0 0 788

Index Only Scan using "_hyper_16_25_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_25_chunk tbl_164 (cost=0.28..2.30 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=788)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_126."time") AND ("time" <= (tbl_126."time" + '30 days'::interval)) AND (event = 'Available Hours'::text))
  • Heap Fetches: 0
190. 0.788 0.788 ↓ 0.0 0 788

Index Only Scan using "_hyper_16_27_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_27_chunk tbl_165 (cost=0.28..1.30 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=788)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_126."time") AND ("time" <= (tbl_126."time" + '30 days'::interval)) AND (event = 'Available Hours'::text))
  • Heap Fetches: 0
191. 0.788 0.788 ↓ 0.0 0 788

Index Only Scan using "_hyper_16_29_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_29_chunk tbl_166 (cost=0.28..1.30 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=788)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_126."time") AND ("time" <= (tbl_126."time" + '30 days'::interval)) AND (event = 'Available Hours'::text))
  • Heap Fetches: 0
192. 0.788 0.788 ↓ 0.0 0 788

Index Only Scan using "_hyper_16_31_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_31_chunk tbl_167 (cost=0.28..1.30 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=788)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_126."time") AND ("time" <= (tbl_126."time" + '30 days'::interval)) AND (event = 'Available Hours'::text))
  • Heap Fetches: 0
193. 0.788 0.788 ↓ 0.0 0 788

Index Only Scan using "_hyper_16_33_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_33_chunk tbl_168 (cost=0.28..2.31 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=788)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_126."time") AND ("time" <= (tbl_126."time" + '30 days'::interval)) AND (event = 'Available Hours'::text))
  • Heap Fetches: 0
194. 0.788 0.788 ↓ 0.0 0 788

Index Only Scan using "_hyper_16_35_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_35_chunk tbl_169 (cost=0.28..1.31 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=788)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_126."time") AND ("time" <= (tbl_126."time" + '30 days'::interval)) AND (event = 'Available Hours'::text))
  • Heap Fetches: 0
195. 0.788 0.788 ↓ 0.0 0 788

Index Only Scan using "_hyper_16_37_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_37_chunk tbl_170 (cost=0.28..1.30 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=788)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_126."time") AND ("time" <= (tbl_126."time" + '30 days'::interval)) AND (event = 'Available Hours'::text))
  • Heap Fetches: 0
196. 0.788 0.788 ↓ 0.0 0 788

Index Only Scan using "_hyper_16_39_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_39_chunk tbl_171 (cost=0.28..1.31 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=788)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_126."time") AND ("time" <= (tbl_126."time" + '30 days'::interval)) AND (event = 'Available Hours'::text))
  • Heap Fetches: 0
197. 0.788 0.788 ↓ 0.0 0 788

Index Only Scan using "_hyper_16_40_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_40_chunk tbl_172 (cost=0.29..1.31 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=788)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_126."time") AND ("time" <= (tbl_126."time" + '30 days'::interval)) AND (event = 'Available Hours'::text))
  • Heap Fetches: 0
198. 0.000 0.000 ↓ 0.0 0 788

Index Only Scan using "_hyper_16_43_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_43_chunk tbl_173 (cost=0.28..1.31 rows=1 width=8) (actual time=0.000..0.000 rows=0 loops=788)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_126."time") AND ("time" <= (tbl_126."time" + '30 days'::interval)) AND (event = 'Available Hours'::text))
  • Heap Fetches: 0
199. 3.152 3.152 ↓ 0.0 0 788

Index Only Scan using "_hyper_16_45_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_45_chunk tbl_174 (cost=0.29..1.31 rows=1 width=8) (actual time=0.004..0.004 rows=0 loops=788)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_126."time") AND ("time" <= (tbl_126."time" + '30 days'::interval)) AND (event = 'Available Hours'::text))
  • Heap Fetches: 0
200. 0.000 0.000 ↓ 0.0 0 788

Index Only Scan using "_hyper_16_47_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_47_chunk tbl_175 (cost=0.28..1.31 rows=1 width=8) (actual time=0.000..0.000 rows=0 loops=788)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_126."time") AND ("time" <= (tbl_126."time" + '30 days'::interval)) AND (event = 'Available Hours'::text))
  • Heap Fetches: 0
201. 0.788 0.788 ↓ 0.0 0 788

Index Only Scan using "_hyper_16_49_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_49_chunk tbl_176 (cost=0.28..1.31 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=788)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_126."time") AND ("time" <= (tbl_126."time" + '30 days'::interval)) AND (event = 'Available Hours'::text))
  • Heap Fetches: 0
202. 0.788 0.788 ↓ 0.0 0 788

Index Only Scan using "_hyper_16_51_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_51_chunk tbl_177 (cost=0.41..2.44 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=788)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_126."time") AND ("time" <= (tbl_126."time" + '30 days'::interval)) AND (event = 'Available Hours'::text))
  • Heap Fetches: 0
203. 0.788 0.788 ↓ 0.0 0 788

Index Only Scan using "_hyper_16_53_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_53_chunk tbl_178 (cost=0.29..2.31 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=788)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_126."time") AND ("time" <= (tbl_126."time" + '30 days'::interval)) AND (event = 'Available Hours'::text))
  • Heap Fetches: 0
204. 0.000 0.000 ↓ 0.0 0 788

Index Only Scan using "_hyper_16_55_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_55_chunk tbl_179 (cost=0.29..2.31 rows=1 width=8) (actual time=0.000..0.000 rows=0 loops=788)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_126."time") AND ("time" <= (tbl_126."time" + '30 days'::interval)) AND (event = 'Available Hours'::text))
  • Heap Fetches: 0
205. 1.644 1.644 ↓ 0.0 0 822

Index Only Scan using "_hyper_16_57_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_57_chunk tbl_180 (cost=0.29..2.31 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=822)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_126."time") AND ("time" <= (tbl_126."time" + '30 days'::interval)) AND (event = 'Available Hours'::text))
  • Heap Fetches: 34
206. 14.624 14.624 ↓ 0.0 0 914

Index Only Scan using "_hyper_16_59_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_59_chunk tbl_181 (cost=0.29..2.31 rows=1 width=8) (actual time=0.016..0.016 rows=0 loops=914)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_126."time") AND ("time" <= (tbl_126."time" + '30 days'::interval)) AND (event = 'Available Hours'::text))
  • Heap Fetches: 126
207. 2.679 2.679 ↓ 0.0 0 893

Index Only Scan using "_hyper_16_61_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_61_chunk tbl_182 (cost=0.29..2.31 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=893)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_126."time") AND ("time" <= (tbl_126."time" + '30 days'::interval)) AND (event = 'Available Hours'::text))
  • Heap Fetches: 104
208. 4.345 4.345 ↓ 0.0 0 869

Index Scan using "63_183_PK_e5cf5cfc2b74171115175cf9b5e" on _hyper_16_63_chunk tbl_183 (cost=0.29..2.31 rows=1 width=8) (actual time=0.005..0.005 rows=0 loops=869)

  • Index Cond: ((("trackedUserId")::text = (tbl."trackedUserId")::text) AND ("time" >= tbl_126."time") AND ("time" <= (tbl_126."time" + '30 days'::interval)))
  • Filter: ((event)::text = 'Available Hours'::text)
  • Rows Removed by Filter: 0
209. 4.734 4.734 ↓ 0.0 0 789

Index Only Scan using "_hyper_16_65_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_65_chunk tbl_184 (cost=0.29..2.31 rows=1 width=8) (actual time=0.006..0.006 rows=0 loops=789)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_126."time") AND ("time" <= (tbl_126."time" + '30 days'::interval)) AND (event = 'Available Hours'::text))
  • Heap Fetches: 0
210. 0.000 0.000 ↓ 0.0 0 789

Index Only Scan using "_hyper_16_67_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_67_chunk tbl_185 (cost=0.28..2.30 rows=1 width=8) (actual time=0.000..0.000 rows=0 loops=789)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_126."time") AND ("time" <= (tbl_126."time" + '30 days'::interval)) AND (event = 'Available Hours'::text))
  • Heap Fetches: 0
211. 132.561 585.761 ↓ 0.0 0 1,133

Limit (cost=0.14..1.16 rows=1 width=12) (actual time=0.517..0.517 rows=0 loops=1,133)

212. 414.593 453.200 ↓ 0.0 0 1,133

Custom Scan (ChunkAppend) on user_events tbl_186 (cost=0.14..1.16 rows=1 width=12) (actual time=0.400..0.400 rows=0 loops=1,133)

  • Order: tbl_186."time
  • Chunks excluded during runtime: 7
213. 1.578 1.578 ↓ 0.0 0 789

Index Only Scan using "_hyper_16_11_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_11_chunk tbl_187 (cost=0.14..1.16 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=789)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_156."time") AND ("time" <= (tbl_156."time" + '30 days'::interval)) AND (event = 'Preferred Technologies'::text))
  • Heap Fetches: 0
214. 0.789 0.789 ↓ 0.0 0 789

Index Only Scan using "_hyper_16_13_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_13_chunk tbl_188 (cost=0.14..1.17 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=789)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_156."time") AND ("time" <= (tbl_156."time" + '30 days'::interval)) AND (event = 'Preferred Technologies'::text))
  • Heap Fetches: 0
215. 0.789 0.789 ↓ 0.0 0 789

Index Only Scan using "_hyper_16_15_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_15_chunk tbl_189 (cost=0.14..1.17 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=789)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_156."time") AND ("time" <= (tbl_156."time" + '30 days'::interval)) AND (event = 'Preferred Technologies'::text))
  • Heap Fetches: 0
216. 0.789 0.789 ↓ 0.0 0 789

Index Only Scan using "_hyper_16_17_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_17_chunk tbl_190 (cost=0.14..1.17 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=789)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_156."time") AND ("time" <= (tbl_156."time" + '30 days'::interval)) AND (event = 'Preferred Technologies'::text))
  • Heap Fetches: 0
217. 0.789 0.789 ↓ 0.0 0 789

Index Only Scan using "_hyper_16_19_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_19_chunk tbl_191 (cost=0.14..1.17 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=789)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_156."time") AND ("time" <= (tbl_156."time" + '30 days'::interval)) AND (event = 'Preferred Technologies'::text))
  • Heap Fetches: 0
218. 0.789 0.789 ↓ 0.0 0 789

Index Only Scan using "_hyper_16_21_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_21_chunk tbl_192 (cost=0.27..2.30 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=789)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_156."time") AND ("time" <= (tbl_156."time" + '30 days'::interval)) AND (event = 'Preferred Technologies'::text))
  • Heap Fetches: 0
219. 6.312 6.312 ↓ 0.0 0 789

Index Only Scan using "_hyper_16_23_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_23_chunk tbl_193 (cost=0.28..1.30 rows=1 width=8) (actual time=0.008..0.008 rows=0 loops=789)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_156."time") AND ("time" <= (tbl_156."time" + '30 days'::interval)) AND (event = 'Preferred Technologies'::text))
  • Heap Fetches: 0
220. 0.789 0.789 ↓ 0.0 0 789

Index Only Scan using "_hyper_16_25_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_25_chunk tbl_194 (cost=0.28..2.30 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=789)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_156."time") AND ("time" <= (tbl_156."time" + '30 days'::interval)) AND (event = 'Preferred Technologies'::text))
  • Heap Fetches: 0
221. 0.789 0.789 ↓ 0.0 0 789

Index Only Scan using "_hyper_16_27_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_27_chunk tbl_195 (cost=0.28..1.30 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=789)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_156."time") AND ("time" <= (tbl_156."time" + '30 days'::interval)) AND (event = 'Preferred Technologies'::text))
  • Heap Fetches: 0
222. 0.789 0.789 ↓ 0.0 0 789

Index Only Scan using "_hyper_16_29_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_29_chunk tbl_196 (cost=0.28..1.30 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=789)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_156."time") AND ("time" <= (tbl_156."time" + '30 days'::interval)) AND (event = 'Preferred Technologies'::text))
  • Heap Fetches: 0
223. 0.789 0.789 ↓ 0.0 0 789

Index Only Scan using "_hyper_16_31_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_31_chunk tbl_197 (cost=0.28..1.30 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=789)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_156."time") AND ("time" <= (tbl_156."time" + '30 days'::interval)) AND (event = 'Preferred Technologies'::text))
  • Heap Fetches: 0
224. 0.000 0.000 ↓ 0.0 0 789

Index Only Scan using "_hyper_16_33_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_33_chunk tbl_198 (cost=0.28..2.31 rows=1 width=8) (actual time=0.000..0.000 rows=0 loops=789)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_156."time") AND ("time" <= (tbl_156."time" + '30 days'::interval)) AND (event = 'Preferred Technologies'::text))
  • Heap Fetches: 0
225. 0.789 0.789 ↓ 0.0 0 789

Index Only Scan using "_hyper_16_35_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_35_chunk tbl_199 (cost=0.28..1.31 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=789)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_156."time") AND ("time" <= (tbl_156."time" + '30 days'::interval)) AND (event = 'Preferred Technologies'::text))
  • Heap Fetches: 0
226. 0.789 0.789 ↓ 0.0 0 789

Index Only Scan using "_hyper_16_37_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_37_chunk tbl_200 (cost=0.28..1.30 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=789)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_156."time") AND ("time" <= (tbl_156."time" + '30 days'::interval)) AND (event = 'Preferred Technologies'::text))
  • Heap Fetches: 0
227. 0.789 0.789 ↓ 0.0 0 789

Index Only Scan using "_hyper_16_39_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_39_chunk tbl_201 (cost=0.28..1.31 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=789)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_156."time") AND ("time" <= (tbl_156."time" + '30 days'::interval)) AND (event = 'Preferred Technologies'::text))
  • Heap Fetches: 0
228. 0.789 0.789 ↓ 0.0 0 789

Index Only Scan using "_hyper_16_40_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_40_chunk tbl_202 (cost=0.29..1.31 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=789)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_156."time") AND ("time" <= (tbl_156."time" + '30 days'::interval)) AND (event = 'Preferred Technologies'::text))
  • Heap Fetches: 0
229. 0.789 0.789 ↓ 0.0 0 789

Index Only Scan using "_hyper_16_43_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_43_chunk tbl_203 (cost=0.28..1.31 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=789)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_156."time") AND ("time" <= (tbl_156."time" + '30 days'::interval)) AND (event = 'Preferred Technologies'::text))
  • Heap Fetches: 0
230. 0.000 0.000 ↓ 0.0 0 789

Index Only Scan using "_hyper_16_45_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_45_chunk tbl_204 (cost=0.29..1.31 rows=1 width=8) (actual time=0.000..0.000 rows=0 loops=789)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_156."time") AND ("time" <= (tbl_156."time" + '30 days'::interval)) AND (event = 'Preferred Technologies'::text))
  • Heap Fetches: 0
231. 0.789 0.789 ↓ 0.0 0 789

Index Only Scan using "_hyper_16_47_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_47_chunk tbl_205 (cost=0.28..1.31 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=789)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_156."time") AND ("time" <= (tbl_156."time" + '30 days'::interval)) AND (event = 'Preferred Technologies'::text))
  • Heap Fetches: 0
232. 0.789 0.789 ↓ 0.0 0 789

Index Only Scan using "_hyper_16_49_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_49_chunk tbl_206 (cost=0.28..1.31 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=789)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_156."time") AND ("time" <= (tbl_156."time" + '30 days'::interval)) AND (event = 'Preferred Technologies'::text))
  • Heap Fetches: 0
233. 0.789 0.789 ↓ 0.0 0 789

Index Only Scan using "_hyper_16_51_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_51_chunk tbl_207 (cost=0.41..2.44 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=789)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_156."time") AND ("time" <= (tbl_156."time" + '30 days'::interval)) AND (event = 'Preferred Technologies'::text))
  • Heap Fetches: 0
234. 0.000 0.000 ↓ 0.0 0 789

Index Only Scan using "_hyper_16_53_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_53_chunk tbl_208 (cost=0.29..2.31 rows=1 width=8) (actual time=0.000..0.000 rows=0 loops=789)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_156."time") AND ("time" <= (tbl_156."time" + '30 days'::interval)) AND (event = 'Preferred Technologies'::text))
  • Heap Fetches: 0
235. 0.000 0.000 ↓ 0.0 0 789

Index Only Scan using "_hyper_16_55_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_55_chunk tbl_209 (cost=0.29..2.31 rows=1 width=8) (actual time=0.000..0.000 rows=0 loops=789)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_156."time") AND ("time" <= (tbl_156."time" + '30 days'::interval)) AND (event = 'Preferred Technologies'::text))
  • Heap Fetches: 0
236. 3.292 3.292 ↓ 0.0 0 823

Index Only Scan using "_hyper_16_57_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_57_chunk tbl_210 (cost=0.29..2.31 rows=1 width=8) (actual time=0.004..0.004 rows=0 loops=823)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_156."time") AND ("time" <= (tbl_156."time" + '30 days'::interval)) AND (event = 'Preferred Technologies'::text))
  • Heap Fetches: 34
237. 3.660 3.660 ↓ 0.0 0 915

Index Only Scan using "_hyper_16_59_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_59_chunk tbl_211 (cost=0.29..2.31 rows=1 width=8) (actual time=0.004..0.004 rows=0 loops=915)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_156."time") AND ("time" <= (tbl_156."time" + '30 days'::interval)) AND (event = 'Preferred Technologies'::text))
  • Heap Fetches: 125
238. 2.682 2.682 ↓ 0.0 0 894

Index Only Scan using "_hyper_16_61_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_61_chunk tbl_212 (cost=0.29..2.31 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=894)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_156."time") AND ("time" <= (tbl_156."time" + '30 days'::interval)) AND (event = 'Preferred Technologies'::text))
  • Heap Fetches: 104
239. 6.090 6.090 ↓ 0.0 0 870

Index Scan using "63_183_PK_e5cf5cfc2b74171115175cf9b5e" on _hyper_16_63_chunk tbl_213 (cost=0.29..2.31 rows=1 width=8) (actual time=0.007..0.007 rows=0 loops=870)

  • Index Cond: ((("trackedUserId")::text = (tbl."trackedUserId")::text) AND ("time" >= tbl_156."time") AND ("time" <= (tbl_156."time" + '30 days'::interval)))
  • Filter: ((event)::text = 'Preferred Technologies'::text)
  • Rows Removed by Filter: 0
240. 0.790 0.790 ↓ 0.0 0 790

Index Only Scan using "_hyper_16_65_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_65_chunk tbl_214 (cost=0.29..2.31 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=790)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_156."time") AND ("time" <= (tbl_156."time" + '30 days'::interval)) AND (event = 'Preferred Technologies'::text))
  • Heap Fetches: 0
241. 0.790 0.790 ↓ 0.0 0 790

Index Only Scan using "_hyper_16_67_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_67_chunk tbl_215 (cost=0.28..2.30 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=790)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_156."time") AND ("time" <= (tbl_156."time" + '30 days'::interval)) AND (event = 'Preferred Technologies'::text))
  • Heap Fetches: 0
242. 150.689 608.421 ↓ 0.0 0 1,133

Limit (cost=0.14..1.16 rows=1 width=12) (actual time=0.537..0.537 rows=0 loops=1,133)

243. 416.102 457.732 ↓ 0.0 0 1,133

Custom Scan (ChunkAppend) on user_events tbl_216 (cost=0.14..1.16 rows=1 width=12) (actual time=0.404..0.404 rows=0 loops=1,133)

  • Order: tbl_216."time
  • Chunks excluded during runtime: 7
244. 3.950 3.950 ↓ 0.0 0 790

Index Only Scan using "_hyper_16_11_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_11_chunk tbl_217 (cost=0.14..1.16 rows=1 width=8) (actual time=0.005..0.005 rows=0 loops=790)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_186."time") AND ("time" <= (tbl_186."time" + '30 days'::interval)) AND (event = 'Production Experience'::text))
  • Heap Fetches: 0
245. 0.790 0.790 ↓ 0.0 0 790

Index Only Scan using "_hyper_16_13_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_13_chunk tbl_218 (cost=0.14..1.17 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=790)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_186."time") AND ("time" <= (tbl_186."time" + '30 days'::interval)) AND (event = 'Production Experience'::text))
  • Heap Fetches: 0
246. 0.790 0.790 ↓ 0.0 0 790

Index Only Scan using "_hyper_16_15_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_15_chunk tbl_219 (cost=0.14..1.17 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=790)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_186."time") AND ("time" <= (tbl_186."time" + '30 days'::interval)) AND (event = 'Production Experience'::text))
  • Heap Fetches: 0
247. 2.370 2.370 ↓ 0.0 0 790

Index Only Scan using "_hyper_16_17_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_17_chunk tbl_220 (cost=0.14..1.17 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=790)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_186."time") AND ("time" <= (tbl_186."time" + '30 days'::interval)) AND (event = 'Production Experience'::text))
  • Heap Fetches: 0
248. 0.790 0.790 ↓ 0.0 0 790

Index Only Scan using "_hyper_16_19_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_19_chunk tbl_221 (cost=0.14..1.17 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=790)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_186."time") AND ("time" <= (tbl_186."time" + '30 days'::interval)) AND (event = 'Production Experience'::text))
  • Heap Fetches: 0
249. 0.790 0.790 ↓ 0.0 0 790

Index Only Scan using "_hyper_16_21_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_21_chunk tbl_222 (cost=0.27..2.30 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=790)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_186."time") AND ("time" <= (tbl_186."time" + '30 days'::interval)) AND (event = 'Production Experience'::text))
  • Heap Fetches: 0
250. 0.790 0.790 ↓ 0.0 0 790

Index Only Scan using "_hyper_16_23_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_23_chunk tbl_223 (cost=0.28..1.30 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=790)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_186."time") AND ("time" <= (tbl_186."time" + '30 days'::interval)) AND (event = 'Production Experience'::text))
  • Heap Fetches: 0
251. 0.790 0.790 ↓ 0.0 0 790

Index Only Scan using "_hyper_16_25_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_25_chunk tbl_224 (cost=0.28..2.30 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=790)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_186."time") AND ("time" <= (tbl_186."time" + '30 days'::interval)) AND (event = 'Production Experience'::text))
  • Heap Fetches: 0
252. 1.580 1.580 ↓ 0.0 0 790

Index Only Scan using "_hyper_16_27_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_27_chunk tbl_225 (cost=0.28..1.30 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=790)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_186."time") AND ("time" <= (tbl_186."time" + '30 days'::interval)) AND (event = 'Production Experience'::text))
  • Heap Fetches: 0
253. 0.790 0.790 ↓ 0.0 0 790

Index Only Scan using "_hyper_16_29_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_29_chunk tbl_226 (cost=0.28..1.30 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=790)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_186."time") AND ("time" <= (tbl_186."time" + '30 days'::interval)) AND (event = 'Production Experience'::text))
  • Heap Fetches: 0
254. 0.790 0.790 ↓ 0.0 0 790

Index Only Scan using "_hyper_16_31_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_31_chunk tbl_227 (cost=0.28..1.30 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=790)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_186."time") AND ("time" <= (tbl_186."time" + '30 days'::interval)) AND (event = 'Production Experience'::text))
  • Heap Fetches: 0
255. 0.790 0.790 ↓ 0.0 0 790

Index Only Scan using "_hyper_16_33_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_33_chunk tbl_228 (cost=0.28..2.31 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=790)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_186."time") AND ("time" <= (tbl_186."time" + '30 days'::interval)) AND (event = 'Production Experience'::text))
  • Heap Fetches: 0
256. 0.790 0.790 ↓ 0.0 0 790

Index Only Scan using "_hyper_16_35_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_35_chunk tbl_229 (cost=0.28..1.31 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=790)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_186."time") AND ("time" <= (tbl_186."time" + '30 days'::interval)) AND (event = 'Production Experience'::text))
  • Heap Fetches: 0
257. 0.790 0.790 ↓ 0.0 0 790

Index Only Scan using "_hyper_16_37_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_37_chunk tbl_230 (cost=0.28..1.30 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=790)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_186."time") AND ("time" <= (tbl_186."time" + '30 days'::interval)) AND (event = 'Production Experience'::text))
  • Heap Fetches: 0
258. 0.790 0.790 ↓ 0.0 0 790

Index Only Scan using "_hyper_16_39_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_39_chunk tbl_231 (cost=0.28..1.31 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=790)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_186."time") AND ("time" <= (tbl_186."time" + '30 days'::interval)) AND (event = 'Production Experience'::text))
  • Heap Fetches: 0
259. 0.790 0.790 ↓ 0.0 0 790

Index Only Scan using "_hyper_16_40_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_40_chunk tbl_232 (cost=0.29..1.31 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=790)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_186."time") AND ("time" <= (tbl_186."time" + '30 days'::interval)) AND (event = 'Production Experience'::text))
  • Heap Fetches: 0
260. 0.790 0.790 ↓ 0.0 0 790

Index Only Scan using "_hyper_16_43_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_43_chunk tbl_233 (cost=0.28..1.31 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=790)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_186."time") AND ("time" <= (tbl_186."time" + '30 days'::interval)) AND (event = 'Production Experience'::text))
  • Heap Fetches: 0
261. 3.160 3.160 ↓ 0.0 0 790

Index Only Scan using "_hyper_16_45_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_45_chunk tbl_234 (cost=0.29..1.31 rows=1 width=8) (actual time=0.004..0.004 rows=0 loops=790)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_186."time") AND ("time" <= (tbl_186."time" + '30 days'::interval)) AND (event = 'Production Experience'::text))
  • Heap Fetches: 0
262. 0.790 0.790 ↓ 0.0 0 790

Index Only Scan using "_hyper_16_47_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_47_chunk tbl_235 (cost=0.28..1.31 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=790)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_186."time") AND ("time" <= (tbl_186."time" + '30 days'::interval)) AND (event = 'Production Experience'::text))
  • Heap Fetches: 0
263. 0.790 0.790 ↓ 0.0 0 790

Index Only Scan using "_hyper_16_49_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_49_chunk tbl_236 (cost=0.28..1.31 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=790)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_186."time") AND ("time" <= (tbl_186."time" + '30 days'::interval)) AND (event = 'Production Experience'::text))
  • Heap Fetches: 0
264. 0.790 0.790 ↓ 0.0 0 790

Index Only Scan using "_hyper_16_51_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_51_chunk tbl_237 (cost=0.41..2.44 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=790)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_186."time") AND ("time" <= (tbl_186."time" + '30 days'::interval)) AND (event = 'Production Experience'::text))
  • Heap Fetches: 0
265. 0.790 0.790 ↓ 0.0 0 790

Index Only Scan using "_hyper_16_53_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_53_chunk tbl_238 (cost=0.29..2.31 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=790)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_186."time") AND ("time" <= (tbl_186."time" + '30 days'::interval)) AND (event = 'Production Experience'::text))
  • Heap Fetches: 0
266. 0.790 0.790 ↓ 0.0 0 790

Index Only Scan using "_hyper_16_55_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_55_chunk tbl_239 (cost=0.29..2.31 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=790)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_186."time") AND ("time" <= (tbl_186."time" + '30 days'::interval)) AND (event = 'Production Experience'::text))
  • Heap Fetches: 0
267. 0.824 0.824 ↓ 0.0 0 824

Index Only Scan using "_hyper_16_57_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_57_chunk tbl_240 (cost=0.29..2.31 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=824)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_186."time") AND ("time" <= (tbl_186."time" + '30 days'::interval)) AND (event = 'Production Experience'::text))
  • Heap Fetches: 34
268. 1.830 1.830 ↓ 0.0 0 915

Index Only Scan using "_hyper_16_59_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_59_chunk tbl_241 (cost=0.29..2.31 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=915)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_186."time") AND ("time" <= (tbl_186."time" + '30 days'::interval)) AND (event = 'Production Experience'::text))
  • Heap Fetches: 125
269. 6.258 6.258 ↓ 0.0 0 894

Index Only Scan using "_hyper_16_61_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_61_chunk tbl_242 (cost=0.29..2.31 rows=1 width=8) (actual time=0.007..0.007 rows=0 loops=894)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_186."time") AND ("time" <= (tbl_186."time" + '30 days'::interval)) AND (event = 'Production Experience'::text))
  • Heap Fetches: 103
270. 3.484 3.484 ↓ 0.0 0 871

Index Scan using "63_183_PK_e5cf5cfc2b74171115175cf9b5e" on _hyper_16_63_chunk tbl_243 (cost=0.29..2.31 rows=1 width=8) (actual time=0.004..0.004 rows=0 loops=871)

  • Index Cond: ((("trackedUserId")::text = (tbl."trackedUserId")::text) AND ("time" >= tbl_186."time") AND ("time" <= (tbl_186."time" + '30 days'::interval)))
  • Filter: ((event)::text = 'Production Experience'::text)
  • Rows Removed by Filter: 0
271. 2.373 2.373 ↓ 0.0 0 791

Index Only Scan using "_hyper_16_65_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_65_chunk tbl_244 (cost=0.29..2.31 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=791)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_186."time") AND ("time" <= (tbl_186."time" + '30 days'::interval)) AND (event = 'Production Experience'::text))
  • Heap Fetches: 0
272. 0.791 0.791 ↓ 0.0 0 791

Index Only Scan using "_hyper_16_67_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_67_chunk tbl_245 (cost=0.28..2.30 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=791)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_186."time") AND ("time" <= (tbl_186."time" + '30 days'::interval)) AND (event = 'Production Experience'::text))
  • Heap Fetches: 0
273. 149.556 625.416 ↓ 0.0 0 1,133

Limit (cost=0.14..1.16 rows=1 width=12) (actual time=0.552..0.552 rows=0 loops=1,133)

274. 422.260 475.860 ↓ 0.0 0 1,133

Custom Scan (ChunkAppend) on user_events tbl_246 (cost=0.14..1.16 rows=1 width=12) (actual time=0.420..0.420 rows=0 loops=1,133)

  • Order: tbl_246."time
  • Chunks excluded during runtime: 7
275. 0.791 0.791 ↓ 0.0 0 791

Index Only Scan using "_hyper_16_11_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_11_chunk tbl_247 (cost=0.14..1.16 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=791)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_216."time") AND ("time" <= (tbl_216."time" + '30 days'::interval)) AND (event = 'Production Experience Years'::text))
  • Heap Fetches: 0
276. 2.373 2.373 ↓ 0.0 0 791

Index Only Scan using "_hyper_16_13_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_13_chunk tbl_248 (cost=0.14..1.17 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=791)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_216."time") AND ("time" <= (tbl_216."time" + '30 days'::interval)) AND (event = 'Production Experience Years'::text))
  • Heap Fetches: 0
277. 0.791 0.791 ↓ 0.0 0 791

Index Only Scan using "_hyper_16_15_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_15_chunk tbl_249 (cost=0.14..1.17 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=791)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_216."time") AND ("time" <= (tbl_216."time" + '30 days'::interval)) AND (event = 'Production Experience Years'::text))
  • Heap Fetches: 0
278. 0.791 0.791 ↓ 0.0 0 791

Index Only Scan using "_hyper_16_17_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_17_chunk tbl_250 (cost=0.14..1.17 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=791)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_216."time") AND ("time" <= (tbl_216."time" + '30 days'::interval)) AND (event = 'Production Experience Years'::text))
  • Heap Fetches: 0
279. 0.791 0.791 ↓ 0.0 0 791

Index Only Scan using "_hyper_16_19_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_19_chunk tbl_251 (cost=0.14..1.17 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=791)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_216."time") AND ("time" <= (tbl_216."time" + '30 days'::interval)) AND (event = 'Production Experience Years'::text))
  • Heap Fetches: 0
280. 0.791 0.791 ↓ 0.0 0 791

Index Only Scan using "_hyper_16_21_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_21_chunk tbl_252 (cost=0.27..2.30 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=791)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_216."time") AND ("time" <= (tbl_216."time" + '30 days'::interval)) AND (event = 'Production Experience Years'::text))
  • Heap Fetches: 0
281. 0.791 0.791 ↓ 0.0 0 791

Index Only Scan using "_hyper_16_23_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_23_chunk tbl_253 (cost=0.28..1.30 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=791)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_216."time") AND ("time" <= (tbl_216."time" + '30 days'::interval)) AND (event = 'Production Experience Years'::text))
  • Heap Fetches: 0
282. 0.791 0.791 ↓ 0.0 0 791

Index Only Scan using "_hyper_16_25_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_25_chunk tbl_254 (cost=0.28..2.30 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=791)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_216."time") AND ("time" <= (tbl_216."time" + '30 days'::interval)) AND (event = 'Production Experience Years'::text))
  • Heap Fetches: 0
283. 0.791 0.791 ↓ 0.0 0 791

Index Only Scan using "_hyper_16_27_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_27_chunk tbl_255 (cost=0.28..1.30 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=791)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_216."time") AND ("time" <= (tbl_216."time" + '30 days'::interval)) AND (event = 'Production Experience Years'::text))
  • Heap Fetches: 0
284. 0.791 0.791 ↓ 0.0 0 791

Index Only Scan using "_hyper_16_29_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_29_chunk tbl_256 (cost=0.28..1.30 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=791)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_216."time") AND ("time" <= (tbl_216."time" + '30 days'::interval)) AND (event = 'Production Experience Years'::text))
  • Heap Fetches: 0
285. 0.791 0.791 ↓ 0.0 0 791

Index Only Scan using "_hyper_16_31_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_31_chunk tbl_257 (cost=0.28..1.30 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=791)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_216."time") AND ("time" <= (tbl_216."time" + '30 days'::interval)) AND (event = 'Production Experience Years'::text))
  • Heap Fetches: 0
286. 0.791 0.791 ↓ 0.0 0 791

Index Only Scan using "_hyper_16_33_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_33_chunk tbl_258 (cost=0.28..2.31 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=791)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_216."time") AND ("time" <= (tbl_216."time" + '30 days'::interval)) AND (event = 'Production Experience Years'::text))
  • Heap Fetches: 0
287. 0.791 0.791 ↓ 0.0 0 791

Index Only Scan using "_hyper_16_35_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_35_chunk tbl_259 (cost=0.28..1.31 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=791)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_216."time") AND ("time" <= (tbl_216."time" + '30 days'::interval)) AND (event = 'Production Experience Years'::text))
  • Heap Fetches: 0
288. 0.791 0.791 ↓ 0.0 0 791

Index Only Scan using "_hyper_16_37_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_37_chunk tbl_260 (cost=0.28..1.30 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=791)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_216."time") AND ("time" <= (tbl_216."time" + '30 days'::interval)) AND (event = 'Production Experience Years'::text))
  • Heap Fetches: 0
289. 1.582 1.582 ↓ 0.0 0 791

Index Only Scan using "_hyper_16_39_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_39_chunk tbl_261 (cost=0.28..1.31 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=791)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_216."time") AND ("time" <= (tbl_216."time" + '30 days'::interval)) AND (event = 'Production Experience Years'::text))
  • Heap Fetches: 0
290. 0.791 0.791 ↓ 0.0 0 791

Index Only Scan using "_hyper_16_40_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_40_chunk tbl_262 (cost=0.29..1.31 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=791)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_216."time") AND ("time" <= (tbl_216."time" + '30 days'::interval)) AND (event = 'Production Experience Years'::text))
  • Heap Fetches: 0
291. 0.791 0.791 ↓ 0.0 0 791

Index Only Scan using "_hyper_16_43_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_43_chunk tbl_263 (cost=0.28..1.31 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=791)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_216."time") AND ("time" <= (tbl_216."time" + '30 days'::interval)) AND (event = 'Production Experience Years'::text))
  • Heap Fetches: 0
292. 0.791 0.791 ↓ 0.0 0 791

Index Only Scan using "_hyper_16_45_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_45_chunk tbl_264 (cost=0.29..1.31 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=791)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_216."time") AND ("time" <= (tbl_216."time" + '30 days'::interval)) AND (event = 'Production Experience Years'::text))
  • Heap Fetches: 0
293. 0.791 0.791 ↓ 0.0 0 791

Index Only Scan using "_hyper_16_47_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_47_chunk tbl_265 (cost=0.28..1.31 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=791)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_216."time") AND ("time" <= (tbl_216."time" + '30 days'::interval)) AND (event = 'Production Experience Years'::text))
  • Heap Fetches: 0
294. 0.791 0.791 ↓ 0.0 0 791

Index Only Scan using "_hyper_16_49_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_49_chunk tbl_266 (cost=0.28..1.31 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=791)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_216."time") AND ("time" <= (tbl_216."time" + '30 days'::interval)) AND (event = 'Production Experience Years'::text))
  • Heap Fetches: 0
295. 0.791 0.791 ↓ 0.0 0 791

Index Only Scan using "_hyper_16_51_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_51_chunk tbl_267 (cost=0.41..2.44 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=791)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_216."time") AND ("time" <= (tbl_216."time" + '30 days'::interval)) AND (event = 'Production Experience Years'::text))
  • Heap Fetches: 0
296. 1.582 1.582 ↓ 0.0 0 791

Index Only Scan using "_hyper_16_53_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_53_chunk tbl_268 (cost=0.29..2.31 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=791)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_216."time") AND ("time" <= (tbl_216."time" + '30 days'::interval)) AND (event = 'Production Experience Years'::text))
  • Heap Fetches: 0
297. 3.164 3.164 ↓ 0.0 0 791

Index Only Scan using "_hyper_16_55_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_55_chunk tbl_269 (cost=0.29..2.31 rows=1 width=8) (actual time=0.004..0.004 rows=0 loops=791)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_216."time") AND ("time" <= (tbl_216."time" + '30 days'::interval)) AND (event = 'Production Experience Years'::text))
  • Heap Fetches: 0
298. 4.125 4.125 ↓ 0.0 0 825

Index Only Scan using "_hyper_16_57_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_57_chunk tbl_270 (cost=0.29..2.31 rows=1 width=8) (actual time=0.005..0.005 rows=0 loops=825)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_216."time") AND ("time" <= (tbl_216."time" + '30 days'::interval)) AND (event = 'Production Experience Years'::text))
  • Heap Fetches: 34
299. 2.748 2.748 ↓ 0.0 0 916

Index Only Scan using "_hyper_16_59_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_59_chunk tbl_271 (cost=0.29..2.31 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=916)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_216."time") AND ("time" <= (tbl_216."time" + '30 days'::interval)) AND (event = 'Production Experience Years'::text))
  • Heap Fetches: 122
300. 7.176 7.176 ↓ 0.0 0 897

Index Only Scan using "_hyper_16_61_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_61_chunk tbl_272 (cost=0.29..2.31 rows=1 width=8) (actual time=0.008..0.008 rows=0 loops=897)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_216."time") AND ("time" <= (tbl_216."time" + '30 days'::interval)) AND (event = 'Production Experience Years'::text))
  • Heap Fetches: 98
301. 7.032 7.032 ↓ 0.0 0 879

Index Scan using "63_183_PK_e5cf5cfc2b74171115175cf9b5e" on _hyper_16_63_chunk tbl_273 (cost=0.29..2.31 rows=1 width=8) (actual time=0.008..0.008 rows=0 loops=879)

  • Index Cond: ((("trackedUserId")::text = (tbl."trackedUserId")::text) AND ("time" >= tbl_216."time") AND ("time" <= (tbl_216."time" + '30 days'::interval)))
  • Filter: ((event)::text = 'Production Experience Years'::text)
  • Rows Removed by Filter: 0
302. 4.794 4.794 ↓ 0.0 0 799

Index Only Scan using "_hyper_16_65_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_65_chunk tbl_274 (cost=0.29..2.31 rows=1 width=8) (actual time=0.006..0.006 rows=0 loops=799)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_216."time") AND ("time" <= (tbl_216."time" + '30 days'::interval)) AND (event = 'Production Experience Years'::text))
  • Heap Fetches: 0
303. 3.995 3.995 ↓ 0.0 0 799

Index Only Scan using "_hyper_16_67_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_67_chunk tbl_275 (cost=0.28..2.30 rows=1 width=8) (actual time=0.005..0.005 rows=0 loops=799)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_216."time") AND ("time" <= (tbl_216."time" + '30 days'::interval)) AND (event = 'Production Experience Years'::text))
  • Heap Fetches: 0
304. 148.423 574.431 ↓ 0.0 0 1,133

Limit (cost=0.14..1.16 rows=1 width=12) (actual time=0.507..0.507 rows=0 loops=1,133)

305. 387.625 426.008 ↓ 0.0 0 1,133

Custom Scan (ChunkAppend) on user_events tbl_276 (cost=0.14..1.16 rows=1 width=12) (actual time=0.376..0.376 rows=0 loops=1,133)

  • Order: tbl_276."time
  • Chunks excluded during runtime: 7
306. 3.995 3.995 ↓ 0.0 0 799

Index Only Scan using "_hyper_16_11_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_11_chunk tbl_277 (cost=0.14..1.16 rows=1 width=8) (actual time=0.005..0.005 rows=0 loops=799)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_246."time") AND ("time" <= (tbl_246."time" + '30 days'::interval)) AND (event = 'US Authorized'::text))
  • Heap Fetches: 0
307. 0.799 0.799 ↓ 0.0 0 799

Index Only Scan using "_hyper_16_13_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_13_chunk tbl_278 (cost=0.14..1.17 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=799)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_246."time") AND ("time" <= (tbl_246."time" + '30 days'::interval)) AND (event = 'US Authorized'::text))
  • Heap Fetches: 0
308. 0.799 0.799 ↓ 0.0 0 799

Index Only Scan using "_hyper_16_15_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_15_chunk tbl_279 (cost=0.14..1.17 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=799)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_246."time") AND ("time" <= (tbl_246."time" + '30 days'::interval)) AND (event = 'US Authorized'::text))
  • Heap Fetches: 0
309. 0.799 0.799 ↓ 0.0 0 799

Index Only Scan using "_hyper_16_17_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_17_chunk tbl_280 (cost=0.14..1.17 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=799)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_246."time") AND ("time" <= (tbl_246."time" + '30 days'::interval)) AND (event = 'US Authorized'::text))
  • Heap Fetches: 0
310. 0.799 0.799 ↓ 0.0 0 799

Index Only Scan using "_hyper_16_19_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_19_chunk tbl_281 (cost=0.14..1.17 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=799)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_246."time") AND ("time" <= (tbl_246."time" + '30 days'::interval)) AND (event = 'US Authorized'::text))
  • Heap Fetches: 0
311. 0.799 0.799 ↓ 0.0 0 799

Index Only Scan using "_hyper_16_21_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_21_chunk tbl_282 (cost=0.27..2.30 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=799)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_246."time") AND ("time" <= (tbl_246."time" + '30 days'::interval)) AND (event = 'US Authorized'::text))
  • Heap Fetches: 0
312. 1.598 1.598 ↓ 0.0 0 799

Index Only Scan using "_hyper_16_23_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_23_chunk tbl_283 (cost=0.28..1.30 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=799)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_246."time") AND ("time" <= (tbl_246."time" + '30 days'::interval)) AND (event = 'US Authorized'::text))
  • Heap Fetches: 0
313. 0.799 0.799 ↓ 0.0 0 799

Index Only Scan using "_hyper_16_25_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_25_chunk tbl_284 (cost=0.28..2.30 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=799)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_246."time") AND ("time" <= (tbl_246."time" + '30 days'::interval)) AND (event = 'US Authorized'::text))
  • Heap Fetches: 0
314. 0.799 0.799 ↓ 0.0 0 799

Index Only Scan using "_hyper_16_27_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_27_chunk tbl_285 (cost=0.28..1.30 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=799)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_246."time") AND ("time" <= (tbl_246."time" + '30 days'::interval)) AND (event = 'US Authorized'::text))
  • Heap Fetches: 0
315. 0.799 0.799 ↓ 0.0 0 799

Index Only Scan using "_hyper_16_29_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_29_chunk tbl_286 (cost=0.28..1.30 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=799)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_246."time") AND ("time" <= (tbl_246."time" + '30 days'::interval)) AND (event = 'US Authorized'::text))
  • Heap Fetches: 0
316. 0.799 0.799 ↓ 0.0 0 799

Index Only Scan using "_hyper_16_31_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_31_chunk tbl_287 (cost=0.28..1.30 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=799)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_246."time") AND ("time" <= (tbl_246."time" + '30 days'::interval)) AND (event = 'US Authorized'::text))
  • Heap Fetches: 0
317. 0.799 0.799 ↓ 0.0 0 799

Index Only Scan using "_hyper_16_33_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_33_chunk tbl_288 (cost=0.28..2.31 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=799)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_246."time") AND ("time" <= (tbl_246."time" + '30 days'::interval)) AND (event = 'US Authorized'::text))
  • Heap Fetches: 0
318. 1.598 1.598 ↓ 0.0 0 799

Index Only Scan using "_hyper_16_35_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_35_chunk tbl_289 (cost=0.28..1.31 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=799)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_246."time") AND ("time" <= (tbl_246."time" + '30 days'::interval)) AND (event = 'US Authorized'::text))
  • Heap Fetches: 0
319. 0.799 0.799 ↓ 0.0 0 799

Index Only Scan using "_hyper_16_37_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_37_chunk tbl_290 (cost=0.28..1.30 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=799)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_246."time") AND ("time" <= (tbl_246."time" + '30 days'::interval)) AND (event = 'US Authorized'::text))
  • Heap Fetches: 0
320. 0.799 0.799 ↓ 0.0 0 799

Index Only Scan using "_hyper_16_39_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_39_chunk tbl_291 (cost=0.28..1.31 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=799)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_246."time") AND ("time" <= (tbl_246."time" + '30 days'::interval)) AND (event = 'US Authorized'::text))
  • Heap Fetches: 0
321. 0.799 0.799 ↓ 0.0 0 799

Index Only Scan using "_hyper_16_40_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_40_chunk tbl_292 (cost=0.29..1.31 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=799)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_246."time") AND ("time" <= (tbl_246."time" + '30 days'::interval)) AND (event = 'US Authorized'::text))
  • Heap Fetches: 0
322. 0.799 0.799 ↓ 0.0 0 799

Index Only Scan using "_hyper_16_43_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_43_chunk tbl_293 (cost=0.28..1.31 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=799)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_246."time") AND ("time" <= (tbl_246."time" + '30 days'::interval)) AND (event = 'US Authorized'::text))
  • Heap Fetches: 0
323. 0.799 0.799 ↓ 0.0 0 799

Index Only Scan using "_hyper_16_45_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_45_chunk tbl_294 (cost=0.29..1.31 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=799)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_246."time") AND ("time" <= (tbl_246."time" + '30 days'::interval)) AND (event = 'US Authorized'::text))
  • Heap Fetches: 0
324. 0.000 0.000 ↓ 0.0 0 799

Index Only Scan using "_hyper_16_47_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_47_chunk tbl_295 (cost=0.28..1.31 rows=1 width=8) (actual time=0.000..0.000 rows=0 loops=799)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_246."time") AND ("time" <= (tbl_246."time" + '30 days'::interval)) AND (event = 'US Authorized'::text))
  • Heap Fetches: 0
325. 0.799 0.799 ↓ 0.0 0 799

Index Only Scan using "_hyper_16_49_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_49_chunk tbl_296 (cost=0.28..1.31 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=799)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_246."time") AND ("time" <= (tbl_246."time" + '30 days'::interval)) AND (event = 'US Authorized'::text))
  • Heap Fetches: 0
326. 0.799 0.799 ↓ 0.0 0 799

Index Only Scan using "_hyper_16_51_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_51_chunk tbl_297 (cost=0.41..2.44 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=799)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_246."time") AND ("time" <= (tbl_246."time" + '30 days'::interval)) AND (event = 'US Authorized'::text))
  • Heap Fetches: 0
327. 0.799 0.799 ↓ 0.0 0 799

Index Only Scan using "_hyper_16_53_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_53_chunk tbl_298 (cost=0.29..2.31 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=799)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_246."time") AND ("time" <= (tbl_246."time" + '30 days'::interval)) AND (event = 'US Authorized'::text))
  • Heap Fetches: 0
328. 0.799 0.799 ↓ 0.0 0 799

Index Only Scan using "_hyper_16_55_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_55_chunk tbl_299 (cost=0.29..2.31 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=799)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_246."time") AND ("time" <= (tbl_246."time" + '30 days'::interval)) AND (event = 'US Authorized'::text))
  • Heap Fetches: 0
329. 0.833 0.833 ↓ 0.0 0 833

Index Only Scan using "_hyper_16_57_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_57_chunk tbl_300 (cost=0.29..2.31 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=833)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_246."time") AND ("time" <= (tbl_246."time" + '30 days'::interval)) AND (event = 'US Authorized'::text))
  • Heap Fetches: 29
330. 2.778 2.778 ↓ 0.0 0 926

Index Only Scan using "_hyper_16_59_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_59_chunk tbl_301 (cost=0.29..2.31 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=926)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_246."time") AND ("time" <= (tbl_246."time" + '30 days'::interval)) AND (event = 'US Authorized'::text))
  • Heap Fetches: 121
331. 8.127 8.127 ↓ 0.0 0 903

Index Only Scan using "_hyper_16_61_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_61_chunk tbl_302 (cost=0.29..2.31 rows=1 width=8) (actual time=0.009..0.009 rows=0 loops=903)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_246."time") AND ("time" <= (tbl_246."time" + '30 days'::interval)) AND (event = 'US Authorized'::text))
  • Heap Fetches: 98
332. 2.655 2.655 ↓ 0.0 0 885

Index Scan using "63_183_PK_e5cf5cfc2b74171115175cf9b5e" on _hyper_16_63_chunk tbl_303 (cost=0.29..2.31 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=885)

  • Index Cond: ((("trackedUserId")::text = (tbl."trackedUserId")::text) AND ("time" >= tbl_246."time") AND ("time" <= (tbl_246."time" + '30 days'::interval)))
  • Filter: ((event)::text = 'US Authorized'::text)
  • Rows Removed by Filter: 0
333. 0.809 0.809 ↓ 0.0 0 809

Index Only Scan using "_hyper_16_65_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_65_chunk tbl_304 (cost=0.29..2.31 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=809)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_246."time") AND ("time" <= (tbl_246."time" + '30 days'::interval)) AND (event = 'US Authorized'::text))
  • Heap Fetches: 0
334. 0.809 0.809 ↓ 0.0 0 809

Index Only Scan using "_hyper_16_67_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_67_chunk tbl_305 (cost=0.28..2.30 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=809)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_246."time") AND ("time" <= (tbl_246."time" + '30 days'::interval)) AND (event = 'US Authorized'::text))
  • Heap Fetches: 0
335. 140.492 597.091 ↓ 0.0 0 1,133

Limit (cost=0.14..1.16 rows=1 width=12) (actual time=0.527..0.527 rows=0 loops=1,133)

336. 401.279 456.599 ↓ 0.0 0 1,133

Custom Scan (ChunkAppend) on user_events tbl_306 (cost=0.14..1.16 rows=1 width=12) (actual time=0.403..0.403 rows=0 loops=1,133)

  • Order: tbl_306."time
  • Chunks excluded during runtime: 7
337. 4.854 4.854 ↓ 0.0 0 809

Index Only Scan using "_hyper_16_11_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_11_chunk tbl_307 (cost=0.14..1.16 rows=1 width=8) (actual time=0.006..0.006 rows=0 loops=809)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_276."time") AND ("time" <= (tbl_276."time" + '30 days'::interval)) AND (event = 'Resume'::text))
  • Heap Fetches: 0
338. 0.809 0.809 ↓ 0.0 0 809

Index Only Scan using "_hyper_16_13_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_13_chunk tbl_308 (cost=0.14..1.17 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=809)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_276."time") AND ("time" <= (tbl_276."time" + '30 days'::interval)) AND (event = 'Resume'::text))
  • Heap Fetches: 0
339. 0.809 0.809 ↓ 0.0 0 809

Index Only Scan using "_hyper_16_15_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_15_chunk tbl_309 (cost=0.14..1.17 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=809)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_276."time") AND ("time" <= (tbl_276."time" + '30 days'::interval)) AND (event = 'Resume'::text))
  • Heap Fetches: 0
340. 1.618 1.618 ↓ 0.0 0 809

Index Only Scan using "_hyper_16_17_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_17_chunk tbl_310 (cost=0.14..1.17 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=809)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_276."time") AND ("time" <= (tbl_276."time" + '30 days'::interval)) AND (event = 'Resume'::text))
  • Heap Fetches: 0
341. 0.809 0.809 ↓ 0.0 0 809

Index Only Scan using "_hyper_16_19_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_19_chunk tbl_311 (cost=0.14..1.17 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=809)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_276."time") AND ("time" <= (tbl_276."time" + '30 days'::interval)) AND (event = 'Resume'::text))
  • Heap Fetches: 0
342. 0.809 0.809 ↓ 0.0 0 809

Index Only Scan using "_hyper_16_21_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_21_chunk tbl_312 (cost=0.27..2.30 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=809)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_276."time") AND ("time" <= (tbl_276."time" + '30 days'::interval)) AND (event = 'Resume'::text))
  • Heap Fetches: 0
343. 0.809 0.809 ↓ 0.0 0 809

Index Only Scan using "_hyper_16_23_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_23_chunk tbl_313 (cost=0.28..1.30 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=809)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_276."time") AND ("time" <= (tbl_276."time" + '30 days'::interval)) AND (event = 'Resume'::text))
  • Heap Fetches: 0
344. 2.427 2.427 ↓ 0.0 0 809

Index Only Scan using "_hyper_16_25_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_25_chunk tbl_314 (cost=0.28..2.30 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=809)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_276."time") AND ("time" <= (tbl_276."time" + '30 days'::interval)) AND (event = 'Resume'::text))
  • Heap Fetches: 0
345. 0.809 0.809 ↓ 0.0 0 809

Index Only Scan using "_hyper_16_27_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_27_chunk tbl_315 (cost=0.28..1.30 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=809)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_276."time") AND ("time" <= (tbl_276."time" + '30 days'::interval)) AND (event = 'Resume'::text))
  • Heap Fetches: 0
346. 0.809 0.809 ↓ 0.0 0 809

Index Only Scan using "_hyper_16_29_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_29_chunk tbl_316 (cost=0.28..1.30 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=809)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_276."time") AND ("time" <= (tbl_276."time" + '30 days'::interval)) AND (event = 'Resume'::text))
  • Heap Fetches: 0
347. 0.809 0.809 ↓ 0.0 0 809

Index Only Scan using "_hyper_16_31_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_31_chunk tbl_317 (cost=0.28..1.30 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=809)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_276."time") AND ("time" <= (tbl_276."time" + '30 days'::interval)) AND (event = 'Resume'::text))
  • Heap Fetches: 0
348. 0.809 0.809 ↓ 0.0 0 809

Index Only Scan using "_hyper_16_33_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_33_chunk tbl_318 (cost=0.28..2.31 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=809)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_276."time") AND ("time" <= (tbl_276."time" + '30 days'::interval)) AND (event = 'Resume'::text))
  • Heap Fetches: 0
349. 0.809 0.809 ↓ 0.0 0 809

Index Only Scan using "_hyper_16_35_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_35_chunk tbl_319 (cost=0.28..1.31 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=809)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_276."time") AND ("time" <= (tbl_276."time" + '30 days'::interval)) AND (event = 'Resume'::text))
  • Heap Fetches: 0
350. 0.809 0.809 ↓ 0.0 0 809

Index Only Scan using "_hyper_16_37_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_37_chunk tbl_320 (cost=0.28..1.30 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=809)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_276."time") AND ("time" <= (tbl_276."time" + '30 days'::interval)) AND (event = 'Resume'::text))
  • Heap Fetches: 0
351. 0.809 0.809 ↓ 0.0 0 809

Index Only Scan using "_hyper_16_39_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_39_chunk tbl_321 (cost=0.28..1.31 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=809)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_276."time") AND ("time" <= (tbl_276."time" + '30 days'::interval)) AND (event = 'Resume'::text))
  • Heap Fetches: 0
352. 0.809 0.809 ↓ 0.0 0 809

Index Only Scan using "_hyper_16_40_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_40_chunk tbl_322 (cost=0.29..1.31 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=809)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_276."time") AND ("time" <= (tbl_276."time" + '30 days'::interval)) AND (event = 'Resume'::text))
  • Heap Fetches: 0
353. 0.809 0.809 ↓ 0.0 0 809

Index Only Scan using "_hyper_16_43_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_43_chunk tbl_323 (cost=0.28..1.31 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=809)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_276."time") AND ("time" <= (tbl_276."time" + '30 days'::interval)) AND (event = 'Resume'::text))
  • Heap Fetches: 0
354. 0.809 0.809 ↓ 0.0 0 809

Index Only Scan using "_hyper_16_45_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_45_chunk tbl_324 (cost=0.29..1.31 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=809)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_276."time") AND ("time" <= (tbl_276."time" + '30 days'::interval)) AND (event = 'Resume'::text))
  • Heap Fetches: 0
355. 0.809 0.809 ↓ 0.0 0 809

Index Only Scan using "_hyper_16_47_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_47_chunk tbl_325 (cost=0.28..1.31 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=809)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_276."time") AND ("time" <= (tbl_276."time" + '30 days'::interval)) AND (event = 'Resume'::text))
  • Heap Fetches: 0
356. 0.809 0.809 ↓ 0.0 0 809

Index Only Scan using "_hyper_16_49_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_49_chunk tbl_326 (cost=0.28..1.31 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=809)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_276."time") AND ("time" <= (tbl_276."time" + '30 days'::interval)) AND (event = 'Resume'::text))
  • Heap Fetches: 0
357. 4.854 4.854 ↓ 0.0 0 809

Index Only Scan using "_hyper_16_51_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_51_chunk tbl_327 (cost=0.41..2.44 rows=1 width=8) (actual time=0.006..0.006 rows=0 loops=809)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_276."time") AND ("time" <= (tbl_276."time" + '30 days'::interval)) AND (event = 'Resume'::text))
  • Heap Fetches: 0
358. 0.809 0.809 ↓ 0.0 0 809

Index Only Scan using "_hyper_16_53_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_53_chunk tbl_328 (cost=0.29..2.31 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=809)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_276."time") AND ("time" <= (tbl_276."time" + '30 days'::interval)) AND (event = 'Resume'::text))
  • Heap Fetches: 0
359. 0.809 0.809 ↓ 0.0 0 809

Index Only Scan using "_hyper_16_55_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_55_chunk tbl_329 (cost=0.29..2.31 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=809)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_276."time") AND ("time" <= (tbl_276."time" + '30 days'::interval)) AND (event = 'Resume'::text))
  • Heap Fetches: 0
360. 1.676 1.676 ↓ 0.0 0 838

Index Only Scan using "_hyper_16_57_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_57_chunk tbl_330 (cost=0.29..2.31 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=838)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_276."time") AND ("time" <= (tbl_276."time" + '30 days'::interval)) AND (event = 'Resume'::text))
  • Heap Fetches: 29
361. 5.580 5.580 ↓ 0.0 0 930

Index Only Scan using "_hyper_16_59_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_59_chunk tbl_331 (cost=0.29..2.31 rows=1 width=8) (actual time=0.006..0.006 rows=0 loops=930)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_276."time") AND ("time" <= (tbl_276."time" + '30 days'::interval)) AND (event = 'Resume'::text))
  • Heap Fetches: 121
362. 6.349 6.349 ↓ 0.0 0 907

Index Only Scan using "_hyper_16_61_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_61_chunk tbl_332 (cost=0.29..2.31 rows=1 width=8) (actual time=0.007..0.007 rows=0 loops=907)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_276."time") AND ("time" <= (tbl_276."time" + '30 days'::interval)) AND (event = 'Resume'::text))
  • Heap Fetches: 98
363. 5.310 5.310 ↓ 0.0 0 885

Index Scan using "63_183_PK_e5cf5cfc2b74171115175cf9b5e" on _hyper_16_63_chunk tbl_333 (cost=0.29..2.31 rows=1 width=8) (actual time=0.006..0.006 rows=0 loops=885)

  • Index Cond: ((("trackedUserId")::text = (tbl."trackedUserId")::text) AND ("time" >= tbl_276."time") AND ("time" <= (tbl_276."time" + '30 days'::interval)))
  • Filter: ((event)::text = 'Resume'::text)
  • Rows Removed by Filter: 0
364. 6.472 6.472 ↓ 0.0 0 809

Index Only Scan using "_hyper_16_65_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_65_chunk tbl_334 (cost=0.29..2.31 rows=1 width=8) (actual time=0.008..0.008 rows=0 loops=809)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_276."time") AND ("time" <= (tbl_276."time" + '30 days'::interval)) AND (event = 'Resume'::text))
  • Heap Fetches: 0
365. 0.809 0.809 ↓ 0.0 0 809

Index Only Scan using "_hyper_16_67_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_67_chunk tbl_335 (cost=0.28..2.30 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=809)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_276."time") AND ("time" <= (tbl_276."time" + '30 days'::interval)) AND (event = 'Resume'::text))
  • Heap Fetches: 0
366. 155.221 611.820 ↓ 0.0 0 1,133

Limit (cost=0.14..1.16 rows=1 width=12) (actual time=0.540..0.540 rows=0 loops=1,133)

367. 409.630 456.599 ↓ 0.0 0 1,133

Custom Scan (ChunkAppend) on user_events tbl_336 (cost=0.14..1.16 rows=1 width=12) (actual time=0.403..0.403 rows=0 loops=1,133)

  • Order: tbl_336."time
  • Chunks excluded during runtime: 7
368. 0.809 0.809 ↓ 0.0 0 809

Index Only Scan using "_hyper_16_11_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_11_chunk tbl_337 (cost=0.14..1.16 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=809)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_306."time") AND ("time" <= (tbl_306."time" + '30 days'::interval)) AND (event = 'Links'::text))
  • Heap Fetches: 0
369. 0.809 0.809 ↓ 0.0 0 809

Index Only Scan using "_hyper_16_13_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_13_chunk tbl_338 (cost=0.14..1.17 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=809)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_306."time") AND ("time" <= (tbl_306."time" + '30 days'::interval)) AND (event = 'Links'::text))
  • Heap Fetches: 0
370. 0.809 0.809 ↓ 0.0 0 809

Index Only Scan using "_hyper_16_15_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_15_chunk tbl_339 (cost=0.14..1.17 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=809)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_306."time") AND ("time" <= (tbl_306."time" + '30 days'::interval)) AND (event = 'Links'::text))
  • Heap Fetches: 0
371. 0.809 0.809 ↓ 0.0 0 809

Index Only Scan using "_hyper_16_17_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_17_chunk tbl_340 (cost=0.14..1.17 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=809)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_306."time") AND ("time" <= (tbl_306."time" + '30 days'::interval)) AND (event = 'Links'::text))
  • Heap Fetches: 0
372. 0.809 0.809 ↓ 0.0 0 809

Index Only Scan using "_hyper_16_19_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_19_chunk tbl_341 (cost=0.14..1.17 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=809)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_306."time") AND ("time" <= (tbl_306."time" + '30 days'::interval)) AND (event = 'Links'::text))
  • Heap Fetches: 0
373. 0.809 0.809 ↓ 0.0 0 809

Index Only Scan using "_hyper_16_21_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_21_chunk tbl_342 (cost=0.27..2.30 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=809)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_306."time") AND ("time" <= (tbl_306."time" + '30 days'::interval)) AND (event = 'Links'::text))
  • Heap Fetches: 0
374. 0.809 0.809 ↓ 0.0 0 809

Index Only Scan using "_hyper_16_23_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_23_chunk tbl_343 (cost=0.28..1.30 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=809)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_306."time") AND ("time" <= (tbl_306."time" + '30 days'::interval)) AND (event = 'Links'::text))
  • Heap Fetches: 0
375. 0.809 0.809 ↓ 0.0 0 809

Index Only Scan using "_hyper_16_25_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_25_chunk tbl_344 (cost=0.28..2.30 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=809)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_306."time") AND ("time" <= (tbl_306."time" + '30 days'::interval)) AND (event = 'Links'::text))
  • Heap Fetches: 0
376. 0.809 0.809 ↓ 0.0 0 809

Index Only Scan using "_hyper_16_27_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_27_chunk tbl_345 (cost=0.28..1.30 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=809)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_306."time") AND ("time" <= (tbl_306."time" + '30 days'::interval)) AND (event = 'Links'::text))
  • Heap Fetches: 0
377. 4.045 4.045 ↓ 0.0 0 809

Index Only Scan using "_hyper_16_29_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_29_chunk tbl_346 (cost=0.28..1.30 rows=1 width=8) (actual time=0.005..0.005 rows=0 loops=809)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_306."time") AND ("time" <= (tbl_306."time" + '30 days'::interval)) AND (event = 'Links'::text))
  • Heap Fetches: 0
378. 0.809 0.809 ↓ 0.0 0 809

Index Only Scan using "_hyper_16_31_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_31_chunk tbl_347 (cost=0.28..1.30 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=809)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_306."time") AND ("time" <= (tbl_306."time" + '30 days'::interval)) AND (event = 'Links'::text))
  • Heap Fetches: 0
379. 0.809 0.809 ↓ 0.0 0 809

Index Only Scan using "_hyper_16_33_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_33_chunk tbl_348 (cost=0.28..2.31 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=809)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_306."time") AND ("time" <= (tbl_306."time" + '30 days'::interval)) AND (event = 'Links'::text))
  • Heap Fetches: 0
380. 1.618 1.618 ↓ 0.0 0 809

Index Only Scan using "_hyper_16_35_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_35_chunk tbl_349 (cost=0.28..1.31 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=809)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_306."time") AND ("time" <= (tbl_306."time" + '30 days'::interval)) AND (event = 'Links'::text))
  • Heap Fetches: 0
381. 0.809 0.809 ↓ 0.0 0 809

Index Only Scan using "_hyper_16_37_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_37_chunk tbl_350 (cost=0.28..1.30 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=809)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_306."time") AND ("time" <= (tbl_306."time" + '30 days'::interval)) AND (event = 'Links'::text))
  • Heap Fetches: 0
382. 1.618 1.618 ↓ 0.0 0 809

Index Only Scan using "_hyper_16_39_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_39_chunk tbl_351 (cost=0.28..1.31 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=809)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_306."time") AND ("time" <= (tbl_306."time" + '30 days'::interval)) AND (event = 'Links'::text))
  • Heap Fetches: 0
383. 0.809 0.809 ↓ 0.0 0 809

Index Only Scan using "_hyper_16_40_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_40_chunk tbl_352 (cost=0.29..1.31 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=809)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_306."time") AND ("time" <= (tbl_306."time" + '30 days'::interval)) AND (event = 'Links'::text))
  • Heap Fetches: 0
384. 0.809 0.809 ↓ 0.0 0 809

Index Only Scan using "_hyper_16_43_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_43_chunk tbl_353 (cost=0.28..1.31 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=809)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_306."time") AND ("time" <= (tbl_306."time" + '30 days'::interval)) AND (event = 'Links'::text))
  • Heap Fetches: 0
385. 1.618 1.618 ↓ 0.0 0 809

Index Only Scan using "_hyper_16_45_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_45_chunk tbl_354 (cost=0.29..1.31 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=809)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_306."time") AND ("time" <= (tbl_306."time" + '30 days'::interval)) AND (event = 'Links'::text))
  • Heap Fetches: 0
386. 0.809 0.809 ↓ 0.0 0 809

Index Only Scan using "_hyper_16_47_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_47_chunk tbl_355 (cost=0.28..1.31 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=809)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_306."time") AND ("time" <= (tbl_306."time" + '30 days'::interval)) AND (event = 'Links'::text))
  • Heap Fetches: 0
387. 0.809 0.809 ↓ 0.0 0 809

Index Only Scan using "_hyper_16_49_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_49_chunk tbl_356 (cost=0.28..1.31 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=809)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_306."time") AND ("time" <= (tbl_306."time" + '30 days'::interval)) AND (event = 'Links'::text))
  • Heap Fetches: 0
388. 0.809 0.809 ↓ 0.0 0 809

Index Only Scan using "_hyper_16_51_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_51_chunk tbl_357 (cost=0.41..2.44 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=809)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_306."time") AND ("time" <= (tbl_306."time" + '30 days'::interval)) AND (event = 'Links'::text))
  • Heap Fetches: 0
389. 0.809 0.809 ↓ 0.0 0 809

Index Only Scan using "_hyper_16_53_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_53_chunk tbl_358 (cost=0.29..2.31 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=809)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_306."time") AND ("time" <= (tbl_306."time" + '30 days'::interval)) AND (event = 'Links'::text))
  • Heap Fetches: 0
390. 0.809 0.809 ↓ 0.0 0 809

Index Only Scan using "_hyper_16_55_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_55_chunk tbl_359 (cost=0.29..2.31 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=809)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_306."time") AND ("time" <= (tbl_306."time" + '30 days'::interval)) AND (event = 'Links'::text))
  • Heap Fetches: 0
391. 1.676 1.676 ↓ 0.0 0 838

Index Only Scan using "_hyper_16_57_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_57_chunk tbl_360 (cost=0.29..2.31 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=838)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_306."time") AND ("time" <= (tbl_306."time" + '30 days'::interval)) AND (event = 'Links'::text))
  • Heap Fetches: 25
392. 6.538 6.538 ↓ 0.0 0 934

Index Only Scan using "_hyper_16_59_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_59_chunk tbl_361 (cost=0.29..2.31 rows=1 width=8) (actual time=0.007..0.007 rows=0 loops=934)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_306."time") AND ("time" <= (tbl_306."time" + '30 days'::interval)) AND (event = 'Links'::text))
  • Heap Fetches: 110
393. 4.610 4.610 ↓ 0.0 0 922

Index Only Scan using "_hyper_16_61_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_61_chunk tbl_362 (cost=0.29..2.31 rows=1 width=8) (actual time=0.005..0.005 rows=0 loops=922)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_306."time") AND ("time" <= (tbl_306."time" + '30 days'::interval)) AND (event = 'Links'::text))
  • Heap Fetches: 87
394. 8.199 8.199 ↓ 0.0 0 911

Index Scan using "63_183_PK_e5cf5cfc2b74171115175cf9b5e" on _hyper_16_63_chunk tbl_363 (cost=0.29..2.31 rows=1 width=8) (actual time=0.009..0.009 rows=0 loops=911)

  • Index Cond: ((("trackedUserId")::text = (tbl."trackedUserId")::text) AND ("time" >= tbl_306."time") AND ("time" <= (tbl_306."time" + '30 days'::interval)))
  • Filter: ((event)::text = 'Links'::text)
  • Rows Removed by Filter: 0
395. 0.838 0.838 ↓ 0.0 0 838

Index Only Scan using "_hyper_16_65_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_65_chunk tbl_364 (cost=0.29..2.31 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=838)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_306."time") AND ("time" <= (tbl_306."time" + '30 days'::interval)) AND (event = 'Links'::text))
  • Heap Fetches: 0
396. 0.838 0.838 ↓ 0.0 0 838

Index Only Scan using "_hyper_16_67_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_67_chunk tbl_365 (cost=0.28..2.30 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=838)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_306."time") AND ("time" <= (tbl_306."time" + '30 days'::interval)) AND (event = 'Links'::text))
  • Heap Fetches: 0
397. 152.955 586.894 ↓ 0.0 0 1,133

Limit (cost=0.14..1.16 rows=1 width=12) (actual time=0.518..0.518 rows=0 loops=1,133)

398. 389.143 433.939 ↓ 0.0 0 1,133

Custom Scan (ChunkAppend) on user_events tbl_366 (cost=0.14..1.16 rows=1 width=12) (actual time=0.383..0.383 rows=0 loops=1,133)

  • Order: tbl_366."time
  • Chunks excluded during runtime: 6
399. 1.676 1.676 ↓ 0.0 0 838

Index Only Scan using "_hyper_16_11_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_11_chunk tbl_367 (cost=0.14..1.16 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=838)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_336."time") AND ("time" <= (tbl_336."time" + '30 days'::interval)) AND (event = 'Code Challenge'::text))
  • Heap Fetches: 0
400. 0.838 0.838 ↓ 0.0 0 838

Index Only Scan using "_hyper_16_13_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_13_chunk tbl_368 (cost=0.14..1.17 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=838)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_336."time") AND ("time" <= (tbl_336."time" + '30 days'::interval)) AND (event = 'Code Challenge'::text))
  • Heap Fetches: 0
401. 4.190 4.190 ↓ 0.0 0 838

Index Only Scan using "_hyper_16_15_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_15_chunk tbl_369 (cost=0.14..1.17 rows=1 width=8) (actual time=0.005..0.005 rows=0 loops=838)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_336."time") AND ("time" <= (tbl_336."time" + '30 days'::interval)) AND (event = 'Code Challenge'::text))
  • Heap Fetches: 0
402. 0.838 0.838 ↓ 0.0 0 838

Index Only Scan using "_hyper_16_17_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_17_chunk tbl_370 (cost=0.14..1.17 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=838)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_336."time") AND ("time" <= (tbl_336."time" + '30 days'::interval)) AND (event = 'Code Challenge'::text))
  • Heap Fetches: 0
403. 0.838 0.838 ↓ 0.0 0 838

Index Only Scan using "_hyper_16_19_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_19_chunk tbl_371 (cost=0.14..1.17 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=838)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_336."time") AND ("time" <= (tbl_336."time" + '30 days'::interval)) AND (event = 'Code Challenge'::text))
  • Heap Fetches: 0
404. 2.514 2.514 ↓ 0.0 0 838

Index Only Scan using "_hyper_16_21_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_21_chunk tbl_372 (cost=0.27..2.30 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=838)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_336."time") AND ("time" <= (tbl_336."time" + '30 days'::interval)) AND (event = 'Code Challenge'::text))
  • Heap Fetches: 0
405. 0.838 0.838 ↓ 0.0 0 838

Index Only Scan using "_hyper_16_23_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_23_chunk tbl_373 (cost=0.28..1.30 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=838)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_336."time") AND ("time" <= (tbl_336."time" + '30 days'::interval)) AND (event = 'Code Challenge'::text))
  • Heap Fetches: 0
406. 0.838 0.838 ↓ 0.0 0 838

Index Only Scan using "_hyper_16_25_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_25_chunk tbl_374 (cost=0.28..2.30 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=838)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_336."time") AND ("time" <= (tbl_336."time" + '30 days'::interval)) AND (event = 'Code Challenge'::text))
  • Heap Fetches: 0
407. 5.866 5.866 ↓ 0.0 0 838

Index Only Scan using "_hyper_16_27_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_27_chunk tbl_375 (cost=0.28..1.30 rows=1 width=8) (actual time=0.007..0.007 rows=0 loops=838)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_336."time") AND ("time" <= (tbl_336."time" + '30 days'::interval)) AND (event = 'Code Challenge'::text))
  • Heap Fetches: 0
408. 0.838 0.838 ↓ 0.0 0 838

Index Only Scan using "_hyper_16_29_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_29_chunk tbl_376 (cost=0.28..1.30 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=838)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_336."time") AND ("time" <= (tbl_336."time" + '30 days'::interval)) AND (event = 'Code Challenge'::text))
  • Heap Fetches: 0
409. 0.838 0.838 ↓ 0.0 0 838

Index Only Scan using "_hyper_16_31_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_31_chunk tbl_377 (cost=0.28..1.30 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=838)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_336."time") AND ("time" <= (tbl_336."time" + '30 days'::interval)) AND (event = 'Code Challenge'::text))
  • Heap Fetches: 0
410. 0.838 0.838 ↓ 0.0 0 838

Index Only Scan using "_hyper_16_33_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_33_chunk tbl_378 (cost=0.28..2.31 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=838)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_336."time") AND ("time" <= (tbl_336."time" + '30 days'::interval)) AND (event = 'Code Challenge'::text))
  • Heap Fetches: 0
411. 0.838 0.838 ↓ 0.0 0 838

Index Only Scan using "_hyper_16_35_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_35_chunk tbl_379 (cost=0.28..1.31 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=838)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_336."time") AND ("time" <= (tbl_336."time" + '30 days'::interval)) AND (event = 'Code Challenge'::text))
  • Heap Fetches: 0
412. 0.838 0.838 ↓ 0.0 0 838

Index Only Scan using "_hyper_16_37_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_37_chunk tbl_380 (cost=0.28..1.30 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=838)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_336."time") AND ("time" <= (tbl_336."time" + '30 days'::interval)) AND (event = 'Code Challenge'::text))
  • Heap Fetches: 0
413. 0.838 0.838 ↓ 0.0 0 838

Index Only Scan using "_hyper_16_39_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_39_chunk tbl_381 (cost=0.28..1.31 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=838)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_336."time") AND ("time" <= (tbl_336."time" + '30 days'::interval)) AND (event = 'Code Challenge'::text))
  • Heap Fetches: 0
414. 0.838 0.838 ↓ 0.0 0 838

Index Only Scan using "_hyper_16_40_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_40_chunk tbl_382 (cost=0.29..1.31 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=838)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_336."time") AND ("time" <= (tbl_336."time" + '30 days'::interval)) AND (event = 'Code Challenge'::text))
  • Heap Fetches: 0
415. 0.838 0.838 ↓ 0.0 0 838

Index Only Scan using "_hyper_16_43_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_43_chunk tbl_383 (cost=0.28..1.31 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=838)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_336."time") AND ("time" <= (tbl_336."time" + '30 days'::interval)) AND (event = 'Code Challenge'::text))
  • Heap Fetches: 0
416. 0.838 0.838 ↓ 0.0 0 838

Index Only Scan using "_hyper_16_45_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_45_chunk tbl_384 (cost=0.29..1.31 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=838)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_336."time") AND ("time" <= (tbl_336."time" + '30 days'::interval)) AND (event = 'Code Challenge'::text))
  • Heap Fetches: 0
417. 0.838 0.838 ↓ 0.0 0 838

Index Only Scan using "_hyper_16_47_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_47_chunk tbl_385 (cost=0.28..1.31 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=838)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_336."time") AND ("time" <= (tbl_336."time" + '30 days'::interval)) AND (event = 'Code Challenge'::text))
  • Heap Fetches: 0
418. 0.838 0.838 ↓ 0.0 0 838

Index Only Scan using "_hyper_16_49_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_49_chunk tbl_386 (cost=0.28..1.31 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=838)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_336."time") AND ("time" <= (tbl_336."time" + '30 days'::interval)) AND (event = 'Code Challenge'::text))
  • Heap Fetches: 0
419. 0.838 0.838 ↓ 0.0 0 838

Index Only Scan using "_hyper_16_51_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_51_chunk tbl_387 (cost=0.41..2.44 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=838)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_336."time") AND ("time" <= (tbl_336."time" + '30 days'::interval)) AND (event = 'Code Challenge'::text))
  • Heap Fetches: 0
420. 0.838 0.838 ↓ 0.0 0 838

Index Only Scan using "_hyper_16_53_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_53_chunk tbl_388 (cost=0.29..2.31 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=838)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_336."time") AND ("time" <= (tbl_336."time" + '30 days'::interval)) AND (event = 'Code Challenge'::text))
  • Heap Fetches: 0
421. 0.838 0.838 ↓ 0.0 0 838

Index Only Scan using "_hyper_16_55_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_55_chunk tbl_389 (cost=0.29..2.31 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=838)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_336."time") AND ("time" <= (tbl_336."time" + '30 days'::interval)) AND (event = 'Code Challenge'::text))
  • Heap Fetches: 0
422. 0.863 0.863 ↓ 0.0 0 863

Index Only Scan using "_hyper_16_57_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_57_chunk tbl_390 (cost=0.29..2.31 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=863)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_336."time") AND ("time" <= (tbl_336."time" + '30 days'::interval)) AND (event = 'Code Challenge'::text))
  • Heap Fetches: 25
423. 1.896 1.896 ↓ 0.0 0 948

Index Only Scan using "_hyper_16_59_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_59_chunk tbl_391 (cost=0.29..2.31 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=948)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_336."time") AND ("time" <= (tbl_336."time" + '30 days'::interval)) AND (event = 'Code Challenge'::text))
  • Heap Fetches: 100
424. 5.610 5.610 ↓ 0.0 0 935

Index Only Scan using "_hyper_16_61_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_61_chunk tbl_392 (cost=0.29..2.31 rows=1 width=8) (actual time=0.006..0.006 rows=0 loops=935)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_336."time") AND ("time" <= (tbl_336."time" + '30 days'::interval)) AND (event = 'Code Challenge'::text))
  • Heap Fetches: 86
425. 3.688 3.688 ↓ 0.0 0 922

Index Scan using "63_183_PK_e5cf5cfc2b74171115175cf9b5e" on _hyper_16_63_chunk tbl_393 (cost=0.29..2.31 rows=1 width=8) (actual time=0.004..0.004 rows=0 loops=922)

  • Index Cond: ((("trackedUserId")::text = (tbl."trackedUserId")::text) AND ("time" >= tbl_336."time") AND ("time" <= (tbl_336."time" + '30 days'::interval)))
  • Filter: ((event)::text = 'Code Challenge'::text)
  • Rows Removed by Filter: 0
426. 1.714 1.714 ↓ 0.0 0 857

Index Only Scan using "_hyper_16_65_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_65_chunk tbl_394 (cost=0.29..2.31 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=857)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_336."time") AND ("time" <= (tbl_336."time" + '30 days'::interval)) AND (event = 'Code Challenge'::text))
  • Heap Fetches: 0
427. 0.857 0.857 ↓ 0.0 0 857

Index Only Scan using "_hyper_16_67_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_67_chunk tbl_395 (cost=0.28..2.30 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=857)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_336."time") AND ("time" <= (tbl_336."time" + '30 days'::interval)) AND (event = 'Code Challenge'::text))
  • Heap Fetches: 0
428. 140.492 583.495 ↓ 0.0 0 1,133

Limit (cost=0.14..1.16 rows=1 width=12) (actual time=0.515..0.515 rows=0 loops=1,133)

429. 403.826 443.003 ↓ 0.0 0 1,133

Custom Scan (ChunkAppend) on user_events tbl_396 (cost=0.14..1.16 rows=1 width=12) (actual time=0.391..0.391 rows=0 loops=1,133)

  • Order: tbl_396."time
  • Chunks excluded during runtime: 6
430. 0.857 0.857 ↓ 0.0 0 857

Index Only Scan using "_hyper_16_11_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_11_chunk tbl_397 (cost=0.14..1.16 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=857)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_366."time") AND ("time" <= (tbl_366."time" + '30 days'::interval)) AND (event = 'Completed'::text))
  • Heap Fetches: 0
431. 0.857 0.857 ↓ 0.0 0 857

Index Only Scan using "_hyper_16_13_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_13_chunk tbl_398 (cost=0.14..1.17 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=857)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_366."time") AND ("time" <= (tbl_366."time" + '30 days'::interval)) AND (event = 'Completed'::text))
  • Heap Fetches: 0
432. 0.857 0.857 ↓ 0.0 0 857

Index Only Scan using "_hyper_16_15_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_15_chunk tbl_399 (cost=0.14..1.17 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=857)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_366."time") AND ("time" <= (tbl_366."time" + '30 days'::interval)) AND (event = 'Completed'::text))
  • Heap Fetches: 0
433. 0.857 0.857 ↓ 0.0 0 857

Index Only Scan using "_hyper_16_17_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_17_chunk tbl_400 (cost=0.14..1.17 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=857)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_366."time") AND ("time" <= (tbl_366."time" + '30 days'::interval)) AND (event = 'Completed'::text))
  • Heap Fetches: 0
434. 0.857 0.857 ↓ 0.0 0 857

Index Only Scan using "_hyper_16_19_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_19_chunk tbl_401 (cost=0.14..1.17 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=857)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_366."time") AND ("time" <= (tbl_366."time" + '30 days'::interval)) AND (event = 'Completed'::text))
  • Heap Fetches: 0
435. 0.857 0.857 ↓ 0.0 0 857

Index Only Scan using "_hyper_16_21_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_21_chunk tbl_402 (cost=0.27..2.30 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=857)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_366."time") AND ("time" <= (tbl_366."time" + '30 days'::interval)) AND (event = 'Completed'::text))
  • Heap Fetches: 0
436. 0.857 0.857 ↓ 0.0 0 857

Index Only Scan using "_hyper_16_23_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_23_chunk tbl_403 (cost=0.28..1.30 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=857)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_366."time") AND ("time" <= (tbl_366."time" + '30 days'::interval)) AND (event = 'Completed'::text))
  • Heap Fetches: 0
437. 0.857 0.857 ↓ 0.0 0 857

Index Only Scan using "_hyper_16_25_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_25_chunk tbl_404 (cost=0.28..2.30 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=857)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_366."time") AND ("time" <= (tbl_366."time" + '30 days'::interval)) AND (event = 'Completed'::text))
  • Heap Fetches: 0
438. 1.714 1.714 ↓ 0.0 0 857

Index Only Scan using "_hyper_16_27_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_27_chunk tbl_405 (cost=0.28..1.30 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=857)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_366."time") AND ("time" <= (tbl_366."time" + '30 days'::interval)) AND (event = 'Completed'::text))
  • Heap Fetches: 0
439. 0.857 0.857 ↓ 0.0 0 857

Index Only Scan using "_hyper_16_29_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_29_chunk tbl_406 (cost=0.28..1.30 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=857)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_366."time") AND ("time" <= (tbl_366."time" + '30 days'::interval)) AND (event = 'Completed'::text))
  • Heap Fetches: 0
440. 0.857 0.857 ↓ 0.0 0 857

Index Only Scan using "_hyper_16_31_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_31_chunk tbl_407 (cost=0.28..1.30 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=857)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_366."time") AND ("time" <= (tbl_366."time" + '30 days'::interval)) AND (event = 'Completed'::text))
  • Heap Fetches: 0
441. 0.857 0.857 ↓ 0.0 0 857

Index Only Scan using "_hyper_16_33_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_33_chunk tbl_408 (cost=0.28..2.31 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=857)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_366."time") AND ("time" <= (tbl_366."time" + '30 days'::interval)) AND (event = 'Completed'::text))
  • Heap Fetches: 0
442. 0.857 0.857 ↓ 0.0 0 857

Index Only Scan using "_hyper_16_35_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_35_chunk tbl_409 (cost=0.28..1.31 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=857)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_366."time") AND ("time" <= (tbl_366."time" + '30 days'::interval)) AND (event = 'Completed'::text))
  • Heap Fetches: 0
443. 0.857 0.857 ↓ 0.0 0 857

Index Only Scan using "_hyper_16_37_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_37_chunk tbl_410 (cost=0.28..1.30 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=857)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_366."time") AND ("time" <= (tbl_366."time" + '30 days'::interval)) AND (event = 'Completed'::text))
  • Heap Fetches: 0
444. 0.857 0.857 ↓ 0.0 0 857

Index Only Scan using "_hyper_16_39_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_39_chunk tbl_411 (cost=0.28..1.31 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=857)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_366."time") AND ("time" <= (tbl_366."time" + '30 days'::interval)) AND (event = 'Completed'::text))
  • Heap Fetches: 0
445. 0.857 0.857 ↓ 0.0 0 857

Index Only Scan using "_hyper_16_40_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_40_chunk tbl_412 (cost=0.29..1.31 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=857)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_366."time") AND ("time" <= (tbl_366."time" + '30 days'::interval)) AND (event = 'Completed'::text))
  • Heap Fetches: 0
446. 0.857 0.857 ↓ 0.0 0 857

Index Only Scan using "_hyper_16_43_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_43_chunk tbl_413 (cost=0.28..1.31 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=857)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_366."time") AND ("time" <= (tbl_366."time" + '30 days'::interval)) AND (event = 'Completed'::text))
  • Heap Fetches: 0
447. 0.857 0.857 ↓ 0.0 0 857

Index Only Scan using "_hyper_16_45_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_45_chunk tbl_414 (cost=0.29..1.31 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=857)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_366."time") AND ("time" <= (tbl_366."time" + '30 days'::interval)) AND (event = 'Completed'::text))
  • Heap Fetches: 0
448. 0.000 0.000 ↓ 0.0 0 857

Index Only Scan using "_hyper_16_47_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_47_chunk tbl_415 (cost=0.28..1.31 rows=1 width=8) (actual time=0.000..0.000 rows=0 loops=857)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_366."time") AND ("time" <= (tbl_366."time" + '30 days'::interval)) AND (event = 'Completed'::text))
  • Heap Fetches: 0
449. 0.857 0.857 ↓ 0.0 0 857

Index Only Scan using "_hyper_16_49_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_49_chunk tbl_416 (cost=0.28..1.31 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=857)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_366."time") AND ("time" <= (tbl_366."time" + '30 days'::interval)) AND (event = 'Completed'::text))
  • Heap Fetches: 0
450. 0.857 0.857 ↓ 0.0 0 857

Index Only Scan using "_hyper_16_51_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_51_chunk tbl_417 (cost=0.41..2.44 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=857)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_366."time") AND ("time" <= (tbl_366."time" + '30 days'::interval)) AND (event = 'Completed'::text))
  • Heap Fetches: 0
451. 0.857 0.857 ↓ 0.0 0 857

Index Only Scan using "_hyper_16_53_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_53_chunk tbl_418 (cost=0.29..2.31 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=857)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_366."time") AND ("time" <= (tbl_366."time" + '30 days'::interval)) AND (event = 'Completed'::text))
  • Heap Fetches: 0
452. 0.857 0.857 ↓ 0.0 0 857

Index Only Scan using "_hyper_16_55_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_55_chunk tbl_419 (cost=0.29..2.31 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=857)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_366."time") AND ("time" <= (tbl_366."time" + '30 days'::interval)) AND (event = 'Completed'::text))
  • Heap Fetches: 0
453. 0.882 0.882 ↓ 0.0 0 882

Index Only Scan using "_hyper_16_57_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_57_chunk tbl_420 (cost=0.29..2.31 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=882)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_366."time") AND ("time" <= (tbl_366."time" + '30 days'::interval)) AND (event = 'Completed'::text))
  • Heap Fetches: 25
454. 1.914 1.914 ↓ 0.0 0 957

Index Only Scan using "_hyper_16_59_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_59_chunk tbl_421 (cost=0.29..2.31 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=957)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_366."time") AND ("time" <= (tbl_366."time" + '30 days'::interval)) AND (event = 'Completed'::text))
  • Heap Fetches: 100
455. 5.658 5.658 ↓ 0.0 0 943

Index Only Scan using "_hyper_16_61_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_61_chunk tbl_422 (cost=0.29..2.31 rows=1 width=8) (actual time=0.006..0.006 rows=0 loops=943)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_366."time") AND ("time" <= (tbl_366."time" + '30 days'::interval)) AND (event = 'Completed'::text))
  • Heap Fetches: 85
456. 10.153 10.153 ↓ 0.0 0 923

Index Scan using "63_183_PK_e5cf5cfc2b74171115175cf9b5e" on _hyper_16_63_chunk tbl_423 (cost=0.29..2.31 rows=1 width=8) (actual time=0.011..0.011 rows=0 loops=923)

  • Index Cond: ((("trackedUserId")::text = (tbl."trackedUserId")::text) AND ("time" >= tbl_366."time") AND ("time" <= (tbl_366."time" + '30 days'::interval)))
  • Filter: ((event)::text = 'Completed'::text)
  • Rows Removed by Filter: 0
457. 0.859 0.859 ↓ 0.0 0 859

Index Only Scan using "_hyper_16_65_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_65_chunk tbl_424 (cost=0.29..2.31 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=859)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_366."time") AND ("time" <= (tbl_366."time" + '30 days'::interval)) AND (event = 'Completed'::text))
  • Heap Fetches: 0
458. 0.000 0.000 ↓ 0.0 0 859

Index Only Scan using "_hyper_16_67_chunk_user_events_trackedUserId_time_event_idx" on _hyper_16_67_chunk tbl_425 (cost=0.28..2.30 rows=1 width=8) (actual time=0.000..0.000 rows=0 loops=859)

  • Index Cond: (("trackedUserId" = (tbl."trackedUserId")::text) AND ("time" >= tbl_366."time") AND ("time" <= (tbl_366."time" + '30 days'::interval)) AND (event = 'Completed'::text))
  • Heap Fetches: 0
Planning time : 68.114 ms
Execution time : 8,997.874 ms