Results of 1 - 10 of about 13 for collects (0.004 sec.)
- Metrics 12193
- DuckDB provides a set of metrics that can be used to monitor the performance and health of the database. Metrics are named ⟨group⟩.⟨metric⟩ , e.g., query.total_time or operator.timing . The set of collected metrics is controlled with the tr
...me spent generating the physical plan Examples The following example enables profiling, sets the output to a file and only collects the total query time along with the operator metrics. CREATE TABLE students (name VARCHAR, sid INTEGER); CREATE TABLE exam..., "timing": 4.4209e-05, "type": "HASH_JOIN", "children": [ ... "query": { "total_time": 0.001491167 } } The second example collects all query and planner metrics, as well as the total time spent in the optimizers. SET tracked_metrics = ['query.*', 'plann... - https://man.mtool.work/duckdb/2.0/dev/metrics.html
- Troubleshooting 12193
- This page collects the most common issues encountered when working with DuckDB and links to the detailed documentation for each. If you run into a problem that is not covered here, please consult the relevant section of the documentation or
... - https://man.mtool.work/duckdb/2.0/troubleshooting.html
- Integration with Polars 9976
- Polars is a DataFrames library built in Rust with bindings for Python and Node.js. It uses Apache Arrow's columnar format as its memory model. DuckDB can read Polars DataFrames and convert query results to Polars DataFrames. It does this in
...rrent scope. DuckDB pushes the column selections of a query, and the filters it can translate, into a LazyFrame, so Polars collects only the rows and columns the query needs. A DataFrame is converted in full and filtered afterwards. import duckdb import... - https://man.mtool.work/duckdb/2.0/guides/python/polars.html
- Troubleshoot 8868
- Overview This page collects common issues encountered when using the DuckDB Rust client, together with their workarounds. If you run into a problem that is not covered here, search the client's issue tracker on GitHub. Linking against a Sys
... - https://man.mtool.work/duckdb/2.0/clients/rust/troubleshoot.html
- Troubleshoot 8868
- Overview This page collects common issues encountered when using DuckDB-Wasm, together with their workarounds. If you run into a problem that is not covered here, search the duckdb-wasm issue tracker on GitHub. Network Error When Querying R
... - https://man.mtool.work/duckdb/2.0/clients/wasm/troubleshoot.html
- Pragmas 8868
- 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
...s introduced in DuckDB 2.0, replacing the custom_profiling_settings PRAGMA used in earlier versions. By default, profiling collects all metrics. To collect only a subset, use the tracked_metrics setting, which accepts a list of metric glob patterns. A me...e grouped by stage and written in group.metric form, for example query.cpu_time or operator.timing . The following example collects only the query-level metrics and every operator metric: SET tracked_metrics = ['query.*', 'operator.*']; To list all avail... - https://man.mtool.work/duckdb/2.0/configuration/pragmas.html
- Spatial Functions 8868
- Function Index Scalar Functions Function Summary DuckDB_PROJ_Compiled_Version Returns a text description of the PROJ library version that this instance of DuckDB was compiled against. DuckDB_Proj_Version Returns a text description of the PR
...olygonal geometry by attempting to “fill in” the input geometry. ST_Centroid Returns the centroid of a geometry ST_Collect Collects a list of geometries into a collection geometry. ST_CollectionExtract Extracts geometries from a GeometryCollection into a...geometry as a point geometry ST_PointOnSurface Returns a point guaranteed to lie on the surface of the geometry ST_Points Collects all the vertices in the geometry into a MULTIPOINT ST_Polygon2DFromWKB Deserialize a POLYGON_2D from a WKB encoded blob ST...2D) POINT_2D ST_Centroid (box BOX_2D) POINT_2D ST_Centroid (box BOX_2DF) Description Returns the centroid of a geometry ST_Collect Signature GEOMETRY ST_Collect (geoms GEOMETRY[]) Description Collects a list of geometries into a collection geometry. * If... - https://man.mtool.work/duckdb/2.0/core_extensions/spatial/functions.html
- Deploying Quack 8868
- This page collects deployment recipes for running a public-facing Quack server. Today there is one recipe (AWS EC2), we will introduce more over time. On AWS EC2 The fastest way to get a public-facing Quack server is the one-click AWS Cloud
... - https://man.mtool.work/duckdb/2.0/quack/setup/deployment.html
- Troubleshoot 7759
- Overview This page collects common issues encountered when using the DuckDB Go client, together with their workarounds. Because the client uses cgo to embed DuckDB, most build problems are cgo or linker problems. If you run into a problem t
... - https://man.mtool.work/duckdb/2.0/clients/go/troubleshoot.html
- Troubleshoot 7759
- Overview This page collects common issues encountered when using the DuckDB JDBC driver, together with their workarounds. If you run into a problem that is not covered here, search the driver's issue tracker on GitHub. Driver Class Not Foun
... - https://man.mtool.work/duckdb/2.0/clients/java/troubleshoot.html
DuckDB 2.0 Documentation / man.mtool.work