Skip to content

Instantly share code, notes, and snippets.

@tom-clickhouse

tom-clickhouse/dashboard-2-memory-usage-of-incremental-materialized-view.md Secret

Created March 19, 2025 08:45
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save tom-clickhouse/ee2ebbd5868fc99e1ff03439b76a7043 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save tom-clickhouse/ee2ebbd5868fc99e1ff03439b76a7043 to your computer and use it in GitHub Desktop.
Download ZIP
Dashboard 2 - memory usage of incremental materialized view
Raw
dashboard-2-memory-usage-of-incremental-materialized-view.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.top_event_types_mv'
FORMAT Vertical;

avg_duration:       0 seconds and 746 milliseconds
avg_processed_rows: 571.42 thousand
avg_memory_used:    276.47 MiB
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment