Viewing ClickHouse cluster logs
Managed Service for ClickHouse allows you to get a cluster log snippet for the selected period and view logs in real time.
Note
Cluster logs are kept for 30 days.
Getting cluster logs
- Go to the folder page and select Managed Service for ClickHouse.
- Click the cluster name and select the
- Specify the time period for logs to be displayed: enter it manually or select in the calendar by clicking the date input field.
- Select the hosts and logging level in the drop-down lists next to the date input field, if required.
A list of log entries for the selected time period will be displayed. To view detailed information about an event, click the respective entry in the list.
If there are too many records and not all of them are displayed, click the Load more link at the end of the list.
If you don't have the Nebius AI command line interface yet, install and initialize it.
The folder specified in the CLI profile is used by default. You can specify a different folder using the --folder-name
or --folder-id
parameter.
-
View a description of the CLI command to view cluster logs:
ncp managed-clickhouse cluster list-logs --help
-
Run this command to get cluster logs:
ncp managed-clickhouse cluster list-logs <cluster name or ID> \ --limit <record number limit> \ --columns <list of columns to display information> \ --filter <record filter settings> \ --since <left boundary of time range> \ --until <right boundary of time range>
Where:
-
--limit
: limits on the number of entries to output. --columns
: List of columns to display information:hostname
: Name of the host.component
: Type of component to be logged. For example,HTTP-Session
.message
: Message output by the component.query_id
: Query ID.severity
: Logging level, such asDebug
.thread
: ID of the thread involved in query handling.
-
--filter
: record filter settings, for example,message.hostname='node1.mdb.nemax.nebius.cloud'
. -
--since
: Left boundary of a time range in RFC-3339 ,HH:MM:SS
format or a time interval relative to the current time. Examples:2006-01-02T15:04:05Z
,15:04:05
,2h
,3h30m ago
. -
--until
: right boundary of a time range, the format is similar to that of--since
.
-
You can request a cluster name and ID with a list of clusters in the folder.
Getting a cluster log stream
This method allows you to get cluster logs in real time.
If you don't have the Nebius AI command line interface yet, install and initialize it.
The folder specified in the CLI profile is used by default. You can specify a different folder using the --folder-name
or --folder-id
parameter.
To view cluster logs as they become available, run this command:
ncp managed-clickhouse cluster list-logs <cluster name or ID> --follow
You can request a cluster name and ID with a list of clusters in the folder.