⌘K ctrl+k
Search Shortcut cmd + k | ctrl + k
DuckDB 2.0 ドキュメント 全文検索
per page, with , order by , clip by
Results of 1 - 6 of about 6 for duration (0.002 sec.)
Conversion between DuckDB and Python 12996
This page documents the rules for converting DuckDB results to Python and Python objects to DuckDB . Result Conversion: DuckDB Results to Python A result is read from a relation or, when using the DB-API / con.execute() , from the connectio ... s months, days and microseconds, so it maps onto Arrow's month_day_nano_interval type. On import, every Arrow interval and duration type, including duration[s] , duration[ms] , duration[us] and duration[ns] , is read into that one INTERVAL type. As a res ... ult, a duration column that is passed through DuckDB and read back as Arrow is returned as a month_day_nano_interval rather than as its or ... iginal duration type. This is expected. The resolution and unit of the original Arrow type are not preserved. Polars pl() fetches the data ...
https://man.mtool.work/duckdb/2.0/clients/python/conversion.html
Profile and Monitor 9340
Overview The JDBC driver exposes several ways to observe a running or completed query: cancelling and timing out queries, polling query progress, retrieving profiling output, and emitting memory-usage events through Java Flight Recorder . T ... mmatically with the jdk.jfr.Recording API: try (Recording r = new Recording()) { r.enable("duckdb.MemoryUsage").withPeriod(Duration.ofSeconds(1)); r.start(); // ... application work ... r.stop(); r.dump(Path.of("app.jfr")); } The equivalent .jfc snippet: ... ted for this tag. temporaryStorageBytes long Bytes spilled to temporary storage for this tag. The standard JFR startTime , duration , and eventThread fields are also present. Stack traces are disabled for this event. Attribution The monitor is keyed on t ...
https://man.mtool.work/duckdb/2.0/clients/java/profiling.html
Reference 8920
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 ... d transaction_id query_id thread_id timestamp type log_level message_type quack_connection_id client_query_id query server duration_ms response_type error 60 CONNECTION 2 18 18 NULL 2026-05-10 09:06:19.841623+02 Quack DEBUG CONNECTION_REQUEST 18 NULL htt ... ent / server logs. query SQL payload for PREPARE_REQUEST s. server HTTP URL on client-side logs, NULL on server-side logs. duration_ms Round-trip time (client) or handling time (server). response_type Response type or ERROR . error Error message if the r ...
https://man.mtool.work/duckdb/2.0/quack/reference.html
R-Tree Indexes 7914
The spatial extension provides support for spatial indexing through the R-tree extension index type. Why Should I Use an R-Tree Index? When working with geospatial datasets, it is very common that you want to filter rows based on their spat ... his means that if you end up scanning the entire index, the entire index will be loaded into memory and stay there for the duration of the database connection. However, all memory used by the R-tree index (even during bulk-loading) is tracked by DuckDB, ...
https://man.mtool.work/duckdb/2.0/core_extensions/spatial/r-tree_indexes.html
Logging 7914
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 ... a FileSystem fs VARCHAR , path VARCHAR , op VARCHAR , bytes BIGINT , pos BIGINT HTTP request STRUCT(type, url, start_time, duration_ms, headers MAP) , response STRUCT(status, reason, headers MAP) PhysicalOperator operator_type VARCHAR , parameters MAP(VA ...
https://man.mtool.work/duckdb/2.0/operations_manual/logging/overview.html
Instantiate 7713
Overview DuckDB-Wasm can be instantiated in several ways, depending on how your application bundles and serves its assets. Each approach resolves the mainModule (the WebAssembly file) and the mainWorker (the worker script) for the browser's ... bundle.pthreadWorker); await db.open({ path: ':memory:', query: { castBigIntToDouble: true, castDecimalToDouble: true, castDurationToTime64: true, castTimestampToDate: true, queryPollingInterval: 1000, }, }); const conn = await db.connect(); Commonly use ... ad of DuckDB's exact decimal representation. castTimestampToDate : return TIMESTAMP values as JavaScript Date objects. castDurationToTime64 : return duration values as 64-bit (microsecond) time values. queryPollingInterval : the interval, in milliseconds ...
https://man.mtool.work/duckdb/2.0/clients/wasm/instantiation.html
PREV 1 NEXT
DuckDB 2.0 Documentation / man.mtool.work