Results of 1 - 10 of about 12 for logging (0.002 sec.)
- Logging 13973
- 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. Basics Th...e DuckDB logging mechanism can be enabled or disabled using a special function, enable_logging . Logs are stored in a special view named du...ckdb_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 is shel... - https://man.mtool.work/duckdb/2.0/operations_manual/logging/overview.html
- Profile and Monitor 10541
- 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
...llback: 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 = 'info'...)`) check(err) _, err = db.Exec(`SET logging_storage = 'my_log_storage'`) check(err) Logging is off by default, so enable it with CALL enable_logging() in addition to...selecting the storage with SET logging_storage . Once both are set, DuckDB forwards all log calls to the callback. Further Reading Profiling — DuckDB's query pro... - https://man.mtool.work/duckdb/2.0/clients/go/profiling.html
- Configuration 9091
- 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
...mory limit of the system to 10 GB. SET memory_limit = '10GB'; Configure the system to use 1 thread. SET threads TO 1; Turn logging on and set the logging level to debug . For additional details on logging levels, see Log Level . In the CLI client, the d...( shell_log_storage ) prints logs 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 leve...E log_level = 'DEBUG'; Check logs with the QueryLog type: SELECT * FROM duckdb_logs WHERE type = 'QueryLog'; Check current logging settings: SELECT * FROM duckdb_settings() WHERE name LIKE '%logging%'; Enable printing of a progress bar during long-runni... - https://man.mtool.work/duckdb/2.0/configuration/overview.html
- Azure Extension 9003
- The azure extension lets DuckDB read and write files in Azure Blob Storage and Azure Data Lake Storage (ADLS) Gen2. Installing and Loading The azure extension will be transparently autoloaded on first use from the official extension reposit
...Default azure_http_stats Include HTTP info from Azure Storage in the EXPLAIN ANALYZE statement . BOOLEAN false azure_http_logging Write Azure HTTP requests to the DuckDB HTTP log when it is enabled. See Logging . BOOLEAN true azure_http_logging_redact_...rated list of URL query parameter names (case-sensitive) whose values are redacted in the HTTP log. VARCHAR sig azure_http_logging_redact_headers Semicolon-separated list of header names (case-insensitive) whose values are redacted in the HTTP log, for...P proxy username if needed. VARCHAR - azure_proxy_password HTTP proxy password if needed. VARCHAR - Additional Information Logging Since v1.5.2, the Azure extension writes its HTTP requests to the DuckDB HTTP log . To inspect them: CALL enable_logging('... - https://man.mtool.work/duckdb/2.0/core_extensions/azure.html
- Migrating to DuckDB 2.0 8649
- 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
...d Settings The custom_profiling_settings setting was removed. Use tracked_metrics instead, see Profiling . The enable_http_logging and http_logging_output settings were removed. Use CALL enable_logging('HTTP') instead, see Logging . The profiling_mode s...e by default, which prints warnings to the console but cannot be queried. To query logs via duckdb_logs in the CLI, enable logging with CALL enable_logging(storage = 'memory') . Clients other than the CLI still default to the memory log storage. Client... - https://man.mtool.work/duckdb/2.0/operations_manual/migration.html
- Reference 8649
- 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
...ON. quack_loaded_at_us BIGINT Epoch microseconds at extension 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 Stru...ctured log of every Quack message (both client- and server-side): CALL enable_logging('Quack'); FROM quack_query('quack:localhost', 'SELECT 42'); SELECT * FROM duckdb_logs_parsed('Quack'); context_id scope co...n on (quack_connection_id, client_query_id) . HTTP Log The underlying HTTP transport can be logged separately: CALL enable_logging('HTTP'); FROM quack_query('quack:localhost', 'SELECT 1'); SELECT request.type, request.url, response.status FROM duckdb_lo... - https://man.mtool.work/duckdb/2.0/quack/reference.html
- Delta Extension 7924
- The delta extension adds support for the Delta Lake open-source storage format . It is built using the Delta Kernel . The extension reads Delta tables, local and remote, and writes them: it can create tables and append to them. For implemen
...without Parquet field IDs: strict raises an error, lenient matches its columns by name. See Column Mapping . delta_kernel_logging BOOLEAN false Forward the internal logging of the Delta Kernel to the DuckDB logger. May impact performance even when Duck...DB logging is disabled. delta_scan_explain_files_filtered BOOLEAN true Add the filtered files to the EXPLAIN output. May impact the p... - https://man.mtool.work/duckdb/2.0/core_extensions/delta.html
- Pragmas 7871
- 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
...g The disabled_optimizers option should only be used for debugging performance issues and should be avoided in production. Logging Set a path for query logging: SET log_query_path = '/tmp/duckdb_log/'; Disable query logging: SET log_query_path = ''; Ful... - https://man.mtool.work/duckdb/2.0/configuration/pragmas.html
- Go Client 7641
- The latest stable release of the DuckDB Go client bundles DuckDB 2.0.0. Its own version tag encodes that DuckDB version; see Versioning below. The DuckDB Go client, duckdb-go , is a SQL driver that conforms to Go's built-in database/sql int
...ined Functions — scalar and table user-defined functions, and replacement scans. Profile and Monitor — query profiling and logging. Troubleshoot — linking, cgo, Windows setup, and other build and runtime issues. Clients Overview — the other client APIs... - https://man.mtool.work/duckdb/2.0/clients/go/overview.html
- Quack Remote Protocol 7588
- The Quack extension turns a DuckDB instance into a server that other DuckDB instances (clients) can connect to over HTTP. This page covers the protocol at a glance and walks through basic usage on both sides of the wire. For the full list o
...f functions, settings, and logging knobs, see the Reference . For configuring TLS and authentication / authorization, see Security . For user guides, see Gui... - https://man.mtool.work/duckdb/2.0/quack/overview.html
DuckDB 2.0 Documentation / man.mtool.work