This message was deleted.
# support
s
This message was deleted.
n
This is my query, which aims to compute our Clickhouse instance's disk utilization:
Copy code
WITH
    left_table AS (select metric, value, event_time from system.asynchronous_metric_log where metric = 'DiskTotal_default' and toSecond(event_time) == 0 and modulo(toMinute(event_time),5) == 0 limit 288),
    right_table AS (select metric, value, event_time from system.asynchronous_metric_log where  metric = 'DiskUsed_default' and toSecond(event_time) == 0 and modulo(toMinute(event_time),5) == 0 limit 288)
SELECT
    r.value / l.value as value, l.event_time FROM left_table AS l
LEFT JOIN right_table AS r ON l.event_time = r.event_time;
cc @Samuel Bacaner
🙏 1
s
When you run the query directly on ClickHouse what do you get as a result? Did you change any ClickHouse server settings?