totals_* session settings

View as MarkdownEdit this pageReport an issueSet up docs MCP

These settings are available in system.settings and are autogenerated from source.

totals_auto_threshold

Type

Float

Default

0.5

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

totals_mode

Type

TotalsMode

Default

after_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”.