SELECT current_setting('memory_limit') AS memlimit;

SELECT value AS memlimit
FROM duckdb_settings()
WHERE name = 'memory_limit';

SET memory_limit = '10GB';

SET threads TO 1;

SET enable_logging = true;
SET logging_level = 'debug';

SELECT write_log('A new client has connected.', level := 'debug', scope := 'connection');

SELECT write_log(
        'A new duck has connected to the lake.', 
        level := 'debug', 
        scope := 'connection', 
        log_type := 'duckdb.docs.example.quack'
    );

SELECT * FROM duckdb_logs WHERE log_level = 'DEBUG';

SELECT * FROM duckdb_logs WHERE type = 'QueryLog';

SELECT * FROM duckdb_settings() WHERE name LIKE '%logging%';

SET enable_progress_bar = true;

SET default_null_order = 'nulls_last';

SELECT current_setting('threads') AS threads;

SELECT *
FROM duckdb_settings()
WHERE name = 'threads';

SELECT *
FROM duckdb_settings();

RESET memory_limit;