-
Notifications
You must be signed in to change notification settings - Fork 849
/
cagg_concurrent_invalidation.out
38 lines (29 loc) · 1.13 KB
/
cagg_concurrent_invalidation.out
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
Parsed test spec with 3 sessions
starting permutation: s3_lock_invalidation s1_run_update s2_run_update s3_release_invalidation s3_check_watermarks
step s3_lock_invalidation:
SELECT debug_waitpoint_enable('invalidation_threshold_scan_update_enter');
debug_waitpoint_enable
----------------------
(1 row)
step s1_run_update:
CALL refresh_continuous_aggregate('cagg_1', '2020-01-01 00:00:00', '2021-01-01 00:00:00');
<waiting ...>
step s2_run_update:
CALL refresh_continuous_aggregate('cagg_2', '2020-01-01 00:00:00', '2021-01-01 00:00:00');
<waiting ...>
step s3_release_invalidation:
SELECT debug_waitpoint_release('invalidation_threshold_scan_update_enter');
debug_waitpoint_release
-----------------------
(1 row)
step s1_run_update: <... completed>
step s2_run_update: <... completed>
step s3_check_watermarks:
SELECT _timescaledb_functions.to_timestamp(watermark)
FROM _timescaledb_catalog.continuous_aggs_watermark
ORDER BY mat_hypertable_id;
to_timestamp
----------------------------
Wed Jan 01 16:00:00 2020 PST
Wed Jan 01 16:00:00 2020 PST
(2 rows)