Reject queries before physical execution when estimated table scans exceed a configured row budget
Maintainer(s):
dentiny
Installing and Loading
INSTALL query_limiter FROM community;
LOAD query_limiter;
Example
SET max_rows_to_scan = 1000000;
CREATE TABLE limiter_demo AS SELECT i FROM range(100) tbl(i);
SELECT sum(i) FROM limiter_demo;
About query_limiter
Query Limiter is a DuckDB extension that rejects queries before physical execution when DuckDB estimates that table scans would exceed a configured row budget.
Added Functions
This extension does not add any functions.
Overloaded Functions
This extension does not add any function overloads.
Added Types
This extension does not add any types.
Added Settings
| name | description | input_type | scope | aliases |
|---|---|---|---|---|
| max_rows_to_scan | Reject queries before execution when estimated table-scan rows exceed this value. Defaults to the maximum idx_t value. | UBIGINT | GLOBAL | [] |
| max_rows_to_scan_unknown | Policy for scans without row estimates when max_rows_to_scan is enabled: allow or reject. | VARCHAR | GLOBAL | [] |