Skip to main content

ClickHouse cluster logs

The Logs service is used for logging. Learn more about how the service works and its pricing in the General information about the Logs service guide. You can check the availability of the Logs service in different regions in the Availability Matrix.

To collect cluster logs in the Logs service, you need to enable logging. You can access logs in the control panel, via API requests, or using AWS CLI. If you no longer need to collect logs, you can disable logging.

Logs are stored for 30 days.

For more information about logs in ClickHouse databases, see the Logs and traces section of the ClickHouse documentation.

Enable logging

You can enable logging via the API or in the Control Panel:

Enable logging in an existing cluster

Logging uses a portion of the cluster's computing resources. To control the amount of consumed resources, monitor the cluster node metrics. For more information on how to view metrics, see the article Мониторинг кластера, групп нод and нод ClickHouse.

  1. In the Control Panel, in the top menu, click Products and select Managed Databases.
  2. Open the Active tab.
  3. Open the cluster page → Settings tab.
  4. In the Logging block, in the Log service field, click Connect.
  5. Select a log group or create a new group.
  6. If you selected a new group, enter its name.
  7. Click Save.

Retrieve logs

Use the Retrieve logs guide in the Logs section.

event streams clickhouse-<node_role>.log-<instance_id> will be created for the ClickHouse Managed Database cluster, where <node_role> is the ClickHouse cluster node role, and <instance_id> is the ClickHouse cluster node ID.

Disable logging

  1. In the Dashboard, on the top menu, click Products and select Managed Databases.
  2. Open the Active tab.
  3. Open the cluster page → Settings tab.
  4. In the Logging block, in the Log service field, click .
  5. Uncheck the Collect cluster technical logs to log service checkbox.
  6. Click Save.