I'm fairly new to Clickhouse and as I'm developing queries I'd like to be able to optimize them. With a traditional RDBMS I can examine the query plan to get a sense of what my query will do without running it. I'd like for Clickhouse to be able to give me some kind of diagnostic output that would guide my optimization efforts. For example, see SQLite and Postgres.

I found a previously discussion but I don't have direct access to the server to read that log file.

In short, I'm asking for:

• some type of EXPLAIN syntax that can be prefixed to a query when it is sent to Clickhouse
• a query response detailing how Clickhouse intends to execute the query
• documentation describing what that EXPLAIN query response means and pointers on how to optimize queries

Thanks!