Results of 1 - 10 of about 64 for enable (0.002 sec.)
- Logging 13138
- DuckDB implements a logging mechanism that provides users with detailed information about events such as query execution, performance metrics and system events. Warning Logs may contain sensitive information, including secrets and credentia
...ls. Enable logging with care and consider where logs are stored and who can access them. Review their contents before sharing them. B...asics The DuckDB logging mechanism can be enabled or disabled using a special function, enable_logging . Logs are stored in a special view named duckdb_logs , which can be...queried like any standard table. Example: CALL enable_logging(storage = 'memory'); -- Run some queries... SELECT * FROM duckdb_logs; In the CLI client , the default log storage... - https://man.mtool.work/duckdb/2.0/operations_manual/logging/overview.html
- Configuration 12405
- DuckDB has a number of configuration options that can be used to change the behavior of the system. The configuration options can be set using either the SET statement or the PRAGMA statement . They can be reset to their original values usi
...gs to the console but cannot be queried, so we switch to the memory log storage first: SET logging_storage = 'memory'; SET enable_logging = true; SET logging_level = 'debug'; Write a single log message with the debug level and a connection scope: SELEC...logs WHERE type = 'QueryLog'; Check current logging settings: SELECT * FROM duckdb_settings() WHERE name LIKE '%logging%'; Enable printing of a progress bar during long-running queries: SET enable_progress_bar = true; Set the default null order to NULL...ss mode of the database ( AUTOMATIC , READ_ONLY or READ_WRITE ). VARCHAR automatic allocator_background_threads Whether to enable the allocator background threads. BOOLEAN false allocator_bulk_deallocation_flush_threshold If a bulk deallocation larger... - https://man.mtool.work/duckdb/2.0/configuration/overview.html
- Pragmas 12204
- The PRAGMA statement is a SQL extension adopted by DuckDB from SQLite. PRAGMA statements can be issued in a similar manner to regular SQL statements. PRAGMA commands may alter the internal state of the database engine, and can influence the
...e is deprecated and emits a warning. Use SET name = value instead. The warning becomes an error when warnings_as_errors is enabled. Function-style PRAGMA calls (for example, PRAGMA table_info('table_name') ) and the SQLite-compatible PRAGMA table_info...nstall_mode , and installed_from ): PRAGMA extension_versions; Progress Bar Show progress bar when running queries: PRAGMA enable_progress_bar; Or: PRAGMA enable_print_progress_bar; Don't show a progress bar for running queries: PRAGMA disable_progress...ptimized query plan: SET explain_output = 'optimized_only'; To show all query plans: SET explain_output = 'all'; Profiling Enable Profiling The following query enables profiling with the default format, query_tree . Independent of the format, enable_pr... - https://man.mtool.work/duckdb/2.0/configuration/pragmas.html
- Profile and Monitor 10122
- Overview The Go client can observe query execution: it can retrieve per-operator profiling metrics after a query runs, and register a log storage that receives DuckDB's log messages. Both are described below. Profiling Profiling information
...is connection-local, so it is read from a *sql.Conn checked out with db.Conn() . Enable profiling on that connection with the enable_profiling setting , run the query to profile, then read the result with duckd....Close() // Do not print profiling output to stdout after each query. _, err = conn.ExecContext(context.Background(), `SET enable_profiling = 'no_output'`) check(err) // Run the query to profile. res, err := conn.QueryContext(context.Background(), `SEL...oggerCallback: func(level, logType, logMsg string) { log.Printf("[%s] %s: %s", level, logType, logMsg) }, }) check(err) // Enable logging, then point it at the registered storage. db := sql.OpenDB(connector) _, err = db.Exec(`CALL enable_logging(level... - https://man.mtool.work/duckdb/2.0/clients/go/profiling.html
- Profiling 9448
- Profiling is essential to help understand why certain queries exhibit specific performance characteristics. DuckDB contains several built-in features to enable query profiling, which this page covers. For a high-level example of using EXPLA
...he performance numbers of individual operators and the cardinalities that pass through them. The EXPLAIN ANALYZE statement enables obtaining these, as it pretty-prints the query plan and also executes the query. Thus, it provides the actual run-time pe...e setting name. For more information, see the “Profiling” section of the pragmas page. Setting Description Default Options enable_profiling , enable_profile Turn on profiling query_tree query_tree , json , query_tree_optimizer , no_output profiling_cov...rn off profiling Table Functions These table functions were introduced in DuckDB 1.5.0. DuckDB provides table functions to enable and disable profiling, consolidating multiple settings into a single call. enable_profiling() The enable_profiling() funct... - https://man.mtool.work/duckdb/2.0/dev/profiling.html
- PostgreSQL Extension Connection Pool 8873
- PostgreSQL server spawns a backend process for every incoming client connection. This model leads to the two following points with the postgres extension that can cause performance problems: opening a new connection is relatively expensive
...that exceed idle_timeout_millis or max_lifetime_millis values. Separate thread is run for each connections pool, it can be enabled/disabled using pg_pool_enable_reaper_thread configuraton option. When the reaper thread is not running, idle_timeout_mill...hat subsequent queries from the same thread are run on the same connection as the first query. To support this the pg_pool_enable_thread_local_cache configuration option can be used - it makes an idle connection to be returned to a thread-local (and th...of milliseconds to wait when acquiring a connection from a pool where all available connections are already taken. pg_pool_enable_thread_local_cache ( BOOLEAN , default: FALSE ): whether to enable the connection caching in thread-local cache. Such conn... - https://man.mtool.work/duckdb/2.0/core_extensions/postgres/connection_pool.html
- Migrating to DuckDB 2.0 8816
- DuckDB 2.0.0 is packed with new features and performance improvements, including query optimization and asynchronous I/O. It also ships a small set of breaking changes, most notably a new default storage format, which DuckDB versions before
...style syntax instead SELECT list_transform([1, 2, 3], lambda x : x + 1); If you cannot update your queries yet, you can re-enable the old syntax for the session: SET lambda_syntax = 'enable_single_arrow'; This flag is a temporary bridge: DuckDB 2.1 wil...the legacy_parser extension . To install and activate it, run the following commands: INSTALL AND LOAD legacy_parser; SET enable_legacy_parser = true; C API v2 DuckDB 2.0.0 ships a revamped C API , which is considerably more powerful than its predeces...ext are now treated as part of the object key. Use secrets instead or, if you need the legacy behavior, opt in with SET s3_enable_deprecated_url_parameters = true (available after loading the httpfs extension). Removed and Deprecated Settings The custo... - https://man.mtool.work/duckdb/2.0/operations_manual/migration.html
- Profile and Monitor 8141
- Overview The Rust client can observe a running or completed query: it can retrieve per-operator profiling metrics after a query runs, and interrupt a long-running query from another thread. Both are shown below. Profiling Profiling must be
...enabled on a connection before metrics are collected. Enable it with the enable_profiling PRAGMA , run a query, then read the result with get_profiling_info() : use duckdb::Connection...Connection::open_in_memory()?; // Do not print profiling output to stdout after each query (the default when profiling is enabled). conn.execute("PRAGMA enable_profiling = 'no_output'", [])?; conn.execute("SELECT 42", [])?; let info = conn.get_profili...ng_info().expect("profiling should be enabled"); println!("profiled children: {}", info.children.len()); get_profiling_info() returns an Option<ProfilingInfo> , which... - https://man.mtool.work/duckdb/2.0/clients/rust/profiling.html
- PostgreSQL Extension Functions 7768
- postgres_clear_cache postgres_configure_pool postgres_execute postgres_hstore_get postgres_hstore_to_json postgres_query read_postgres_binary postgres_clear_cache postgres_clear_cache() -> TABLE Clears cached schema entries (like table name
...number of milliseconds to wait when acquiring a connection from a pool where all available connections are already taken. enable_thread_local_cache ( BOOLEAN ): whether to enable the connection caching in thread-local cache. Such connections are getti...is checked when the connection is taken from the pool and returned to the pool. When the connection pool reaper thread is enabled ( enable_reaper_thread argument), then this number is checked in background periodically. idle_timeout_millis ( UBIGINT )...in the pool. This number is checked when the connection is taken from the pool. When the connection pool reaper thread is enabled ( enable_reaper_thread option), then this number is checked in background periodically. enable_reaper_thread ( BOOLEAN ):... - https://man.mtool.work/duckdb/2.0/core_extensions/postgres/functions.html
- Reference 7667
- This page lists the functions, settings, and log types exposed by the quack extension . For a tour of the protocol, start with the Overview . Function Reference Server Management Function Description quack_serve(⟨listen_uri⟩, ...) Start a s
...BIGINT 60 Heartbeat lease timeout in seconds requested by clients when ATTACH / quack_query omit heartbeat_timeout . quack_enable_reconnects BOOLEAN false Enable reconnect support: clients acknowledge results and the server caches the last result until...ension load Fallback uptime anchor when whoami_started_at is empty. Logging Two log types are registered by the extension. Enable them to debug connectivity or measure request timing. Quack Log Structured log of every Quack message (both client- and se...rver-side): CALL enable_logging('Quack'); FROM quack_query('quack:localhost', 'SELECT 42'); SELECT * FROM duckdb_logs_parsed('Quack'); context_id... - https://man.mtool.work/duckdb/2.0/quack/reference.html
DuckDB 2.0 Documentation / man.mtool.work