The threshold for totals_mode = 'auto'.
See the section “WITH TOTALS modifier”.
totals_mode
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”.