Search Shortcut cmd + k | ctrl + k
query_limiter

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 []