Dashboard 3 v2 - memory usage of incremental materialized view 1

dashboard-3-v2-memory-usage-of-incremental-materialized-view-1.md

SELECT
    formatReadableTimeDelta(avg(view_duration_ms) / 1000, 'minutes', 'milliseconds') AS avg_duration,
    formatReadableQuantity(avg(read_rows)) AS avg_processed_rows,
    formatReadableSize(avg(peak_memory_usage)) AS avg_memory_used
FROM clusterAllReplicas(default, system.query_views_log)
WHERE status = 'QueryFinish' AND view_name = 'bluesky.reposts_per_post_mv'
FORMAT Vertical;

avg_duration:       0 seconds and 412 milliseconds
avg_processed_rows: 647.18 thousand
avg_memory_used:    37.62 MiB

Processes ~647k new rows in 412ms per update and uses 37.62 MiB RAM.