Monitoring and logs
What metrics and processes can be tracked using monitoring?
For all DBMS types, you can track:
- CPU, memory, network, or disk usage, in absolute terms.
- Memory, network, or disk usage as a percentage of the set limits for the corresponding cluster's host class.
- The amount of data in the DB cluster and the remaining free space in data storage.
For DB hosts, you can track metrics specific to the corresponding type of DBMS. For example, for PostgreSQL, you can track:
- Average query execution time.
- Number of queries per second.
- Number of errors in logs.
Monitoring can be performed with a minimum granularity of 5 seconds.
What is the retention period for logs?
Cluster logs are stored for 30 days.
How do I track the amount of free storage space on ZooKeeper hosts?
Follow the instructions in Monitoring the state of ClickHouse clusters and hosts to track the host state.