I am trying to track the latency inside my materialized view which is composed of 2 joins between 3 tables. Each table has a field representing the moment a row was Inserted/Updated in the source db. I want to add a time.now() column in my MV to compute the latency. However, NOW() or PROCTIME() methods only work in TABLES/STREAMS in RisingWave. Do you have any recommendations on how to track the latency inside a materialized view?
Robert Gargalac
Asked on Mar 29, 2024
In RisingWave, you can't directly track the latency of each row inside a materialized view using methods like NOW() or PROCTIME(). However, you can monitor the overall latency in the Grafana dashboard, which shows the time of the barrier flowing down the entire stream. This can serve as a good measure of the current data freshness.
