Settings

Setting	Environment Variable	Description	Values
system.execution_mode	LINGODB_EXECUTION_MODE	Choose execution backend	DEFAULT: LLVM O2 CHEAP: fast LLVM SPEED: omit checks for speed DEBUGGING: LLVM O0 with debug info C: C Backend PERF: LLVM O2, with debug info, record with perf BASELINE: TPDE baseline backend (requires build with -DENABLE_BASELINE_BACKEND=ON) BASELINE_SPEED: TPDE baseline without MLIR verification (requires build with -DENABLE_BASELINE_BACKEND=ON)
system.subop.opt	LINGODB_SUBOP_OPT	Manually select SubOp optimizations	Comma-seperated list of the following pass names: ReuseLocal, Specialize, PullGatherUp, Compression
system.snapshot_passes	LINGODB_SNAPSHOT_PASSES	Enables snapshotting	Boolean value: true or false
system.snapshot_level	LINGODB_SNAPSHOT_LEVEL	Sets the detailedness of snapshotting	full: Perform a snapshot after every MLIR pass important: only performs snapshots at selected steps in the compilation pipeline
system.snapshot_dir	LINGODB_SNAPSHOT_DIR	Directory for output of snapshots	(relative) path to output directory (default: .)
system.execution.perf_file	LINGODB_EXECUTION_PERF_FILE	Sets the output path for the perf record output	(relative) path to output path (default: perf.data)
system.execution.perf_binary	LINGODB_EXECUTION_PERF_BINARY	Points to the perf binary that should be used for recording	path to perf binary (default: /usr/bin/perf)
system.trace_dir	LINGODB_TRACE_DIR	Sets the output directory for lightweight tracing	(relative) path to output directory (default: .)
sql.report_times	LINGODB_SQL_REPORT_TIMES	Make the sql REPL print compilation/execution times after each query	Boolean value: true or false (default: false)
sql.report_format	LINGODB_SQL_REPORT_FORMAT	Output format for the timing report when sql.report_times=true	simple (human-readable, default) | csv
sql.prompt	LINGODB_SQL_PROMPT	Show the interactive sql> prompt in the REPL	Boolean value: true or false (default: true)
system.opt.pushdown_restrictions	LINGODB_OPT_PUSHDOWN_RESTRICTIONS	Disable pushing down filter predicates as base-table restrictions during query optimization	Boolean value: true or false (default: true)