OptionStateRowLimit
Introduced Version1.51
Description

Maximum number of rows allowed in functions.

Default20,000 rows
 100,000 rows (introduced in 1.181.0)
 20,000 rows (removed in 1.180.99)

Maximum number of rows allowed in functions.

Used as an alternative for the environment variable MAX_STATE_LIMIT.

Attention

It is strongly recommended to not change this limit beyond its current default value as the consequences of doing so are cluster instability or cluster crashes.

If you experience a lot of query load, particularly from the sort(), table(), head(), and tail() functions, decreasing this limit can help alleviate said load, as it lowers the amount of events those functions are allowed to collect.