I have a ClickHouse cluster with 3 shards. I want to monitor this cluster using Prometheus, but the metrics provided by ClickHouse do not include data related to shard activity or availability.

I added the following configuration to config.xml to enable Prometheus integration:

<prometheus>
    <endpoint>/metrics</endpoint>
    <port>9363</port>
    <metrics>true</metrics>
    <events>true</events>
    <asynchronous_metrics>true</asynchronous_metrics> 
</prometheus>

I have a ClickHouse cluster with 3 shards. I want to monitor this cluster using Prometheus, but the metrics provided by ClickHouse do not include data related to shard activity or availability.

I added the following configuration to config.xml to enable Prometheus integration:

<prometheus>
    <endpoint>/metrics</endpoint>
    <port>9363</port>
    <metrics>true</metrics>
    <events>true</events>
    <asynchronous_metrics>true</asynchronous_metrics> 
</prometheus>

• prometheus
• grafana
• monitoring
• clickhouse

• So, you mean your prometheus scraps metrics that don't interest you? you can write your own custom metrics – John Galt Commented Jan 21 at 13:15

1 Answer 1

Actually you have lot of metrics related to Distributed tables in prometheus endpoint

look to SELECT * system.metrics WHERE metric ILIKE '%distrib%' FORMAT Vertical

SELECT * system.asynchronous_metrics WHERE metric ILIKE '%distrib%' FORMAT Vertical

and SELECT * FROM system.events WHERE event ILIKE '%distrib%' FORMAT Vertical

for description