Skip to content
ClickHouse Docs
49.6kGet Started

totals_* session settings

View as MarkdownEdit this pageReport an issueSet up docs MCP

Autogenerated from ClickHouse system tables

These settings are available in system.settings and are autogenerated from the ClickHouse snapshot.

totals_auto_threshold

TypeFloatDefault0.5

The threshold for totals_mode = 'auto'. See the section “WITH TOTALS modifier”.

totals_mode

TypeTotalsModeDefaultafter_having_exclusive

How to calculate TOTALS when HAVING is present, as well as when max_rows_to_group_by and group_by_overflow_mode = ‘any’ are present. See the section “WITH TOTALS modifier”.

Navigation