v.24.2New Feature

Implemented system.dns_cache table for DNS debugging

Official CH changelog text
Implemented system.dns_cache table, which can be useful for debugging DNS issues. #59856 (Kirill Nikiforov).
Introduced the system.dns_cache table in ClickHouse to allow users to inspect and debug DNS resolution caching within the system.

Why it matters

This feature helps diagnose and troubleshoot DNS-related issues by providing visibility into the DNS cache entries used by ClickHouse for name resolution, thereby improving debugging capabilities and system transparency.

How to use it

Query the system.dns_cache table using a standard SELECT statement, for example:

SELECT * FROM system.dns_cache

This will display the current DNS cache entries and their states.

Related resources

PreviousNext