Results of 1 - 10 of about 15 for Logs (0.006 sec.)
- Logging 14855
- 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 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_loggin...g(storage = 'memory'); -- Run some queries... SELECT * FROM duckdb_logs; In the CLI client , the default log storage is shell_log_storage , which prints log messages to the console but does not... - https://man.mtool.work/duckdb/2.0/operations_manual/logging/overview.html
- Reference 9996
- 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
...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 server-side): CALL enable_logging('Quack'); FROM quack_query('quack...:localhost', 'SELECT 42'); SELECT * FROM duckdb_logs_parsed('Quack'); context_id scope connection_id transaction_id query_id thread_id timestamp type log_level message_type qu...d (stable across requests in one ATTACH ). client_query_id Monotonic id assigned by the client, correlates client / server logs. query SQL payload for PREPARE_REQUEST s. server HTTP URL on client-side logs, NULL on server-side logs. duration_ms Round... - https://man.mtool.work/duckdb/2.0/quack/reference.html
- PHP Client (PDO) 9038
- The PHP DuckDB PDO extension is a tertiary client and is maintained by a third-party. To use pdo_duckdb , follow the instructions below . The latest version of pdo_duckdb supports DuckDB 2.0.0. pdo_duckdb is a native DuckDB database driver
...# ) # [1] => Array # ( # [aaa] => aaa # [bbb] => bbb # [ccc] => ccc # ) # ) Read JSON files <?php file_put_contents('/tmp/logs.json', json_encode(['log' => 'log text']) . PHP_EOL, FILE_APPEND); file_put_contents('/tmp/logs.json', json_encode(['log'...=> 'log text 2']) . PHP_EOL, FILE_APPEND); $db = new PDO('duckdb::memory:'); $statement = $db->query("SELECT * FROM '/tmp/logs.json'"); print_r($statement->fetchAll(PDO::FETCH_ASSOC)); # Array # ( # [0] => Array # ( # [log] => log text # ) # [1] =>...Array # ( # [log] => log text 2 # ) # ) $db->exec("COPY (SELECT * FROM '/tmp/logs.json') TO '/tmp/logs_json.parquet' (COMPRESSION zstd)"); Use structured columns with a fixed schema <?php # s is array{v:... - https://man.mtool.work/duckdb/2.0/clients/tertiary_clients/php_pdo.html
- Configuration 8638
- 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
...set the logging level to debug . For additional details on logging levels, see Log Level . In the CLI client, the default log storage ( shell_log_storage ) prints logs to the console but cannot be queried, so we switch to the memory log storage firs...uck has connected to the lake.', level := 'debug', scope := 'connection', log_type := 'duckdb.docs.example.quack' ); Check logs with the DEBUG log level: SELECT * FROM duckdb_logs WHERE 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%'; Enab... - https://man.mtool.work/duckdb/2.0/configuration/overview.html
- Azure Extension 8359
- 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
...ELECT * FROM 'az://⟨my_container⟩/⟨path⟩/⟨my_file⟩.parquet'; SELECT request.type, request.url, response.status FROM duckdb_logs_parsed('HTTP'); Logged requests show the DuckDB User-Agent header. The values of the sig query parameter and the Authoriza...act_headers = 'Authorization;x-ms-date'; Warning The Azure extension applies only these settings, not DuckDB's redact_http_logs setting. To keep Azure requests out of the HTTP log, run SET azure_http_logging = false; . The Azure extension relies on t...he Azure SDK to connect to Azure Blob storage and supports printing the SDK logs to the console. To control the log level, set the AZURE_LOG_LEVEL environment variable. For instance, to start the DuckDB... - https://man.mtool.work/duckdb/2.0/core_extensions/azure.html
- Analyzing a Git Repository 8185
- You can use DuckDB to analyze Git logs using the output of the git log command . Exporting the Git Log We start by picking a character that doesn't occur in any part of the commit log (author names, messages, etc). Since version v1.2.0, Duc
...oji Movie (IMDb rating: 3.4), we can assume that the Fish Cake with Swirl emoji (?) is not a common occurrence in most Git logs. So, let's clone the duckdb/duckdb repository and export its log as follows: git log --date=iso-strict --pretty=format:%ad... - https://man.mtool.work/duckdb/2.0/guides/snippets/analyze_git_repository.html
- Migrating to DuckDB 2.0 8081
- 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
...value has no effect: detailed profiling information is always collected. Use PRAGMA enable_profiling to enable profiling. Log Storage in the CLI Since v1.5.0, the CLI uses the shell_log_storage log storage by default, which prints warnings to the co...nsole 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 APIs Some client APIs ship their own breaking changes with DuckDB 2.0. In particular, the Python client req... - https://man.mtool.work/duckdb/2.0/operations_manual/migration.html
- DuckDB_% Metadata Functions 8046
- DuckDB offers a collection of table functions that provide metadata about the current database. These functions reside in the main schema and their names are prefixed with duckdb_ . The resultset returned by a duckdb_ table function may be
...DuckDB log entries. Column Description Type context_id The identifier of the context. The context_id column in the duckdb_logs table is a foreign key that points to this column. UBIGINT scope The scope of the context ( connection , database or file_...transaction. UBIGINT query_id The identifier of the query. UBIGINT thread_id The identifier of the thread. UBIGINT duckdb_logs The duckdb_logs() function returns a table of DuckDB log entries. Column Description Type context_id The identifier of the... - https://man.mtool.work/duckdb/2.0/sql/meta/duckdb_table_functions.html
- Profile and Monitor 7993
- 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
...restrict them, set the tracked_metrics option. See the Profiling page and the metrics list for the available metric names. Log Storage DuckDB can forward its log messages to a custom storage registered from Go. Register one on a Connector with duckdb....RegisterLogStorage() , giving it a name and a duckdb.LoggerCallbacks whose DefaultLoggerCallback receives each entry's level, type, and...message: connector, err := duckdb.NewConnector("", nil) check(err) defer connector.Close() err = duckdb.RegisterLogStorage(connector, "my_log_storage", duckdb.LoggerCallbacks{ DefaultLoggerCallback: func(level, logType, logMsg string) { lo... - https://man.mtool.work/duckdb/2.0/clients/go/profiling.html
- Building Configuration 7959
- Build Types DuckDB can be built in many different settings, most of these correspond directly to CMake but not all of them. release This build has been stripped of all the assertions and debug symbols and code, optimized for performance. de
...OVERRIDE_GIT_DESCRIBE is not set and Git is not available, DuckDB falls back to a placeholder version and commit hash, and logs a message during the CMake configuration step. The build still succeeds.... - https://man.mtool.work/duckdb/2.0/dev/building/build_configuration.html
DuckDB 2.0 Documentation / man.mtool.work