Results of 1 - 5 of about 5 for planner (0.001 sec.)
- Metrics 12685
- 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
...rics(); All Metrics The metrics are organized into the following groups: query system io storage operator optimizer parser planner physical_planner query Metrics Metrics measured over the entire query. Name Type Unit Description query.cpu_time double se...ics on parsing the SQL query. Name Type Unit Description parser.total_time double seconds Time spent parsing the SQL query planner Metrics Metrics on generating the logical plan. Name Type Unit Description planner.binding_time double seconds Time spent...binding the logical plan planner.total_time double seconds Time spent generating the logical plan physical_planner Metrics Metrics on generating the physic... - https://man.mtool.work/duckdb/2.0/dev/metrics.html
- Overview of DuckDB Internals 9413
- Tip For a detailed explanation of DuckDB internals, see the Design and Implementation of DuckDB Internals ("DiDi") library entry. On this page is a brief description of the internals of the DuckDB engine. Parser The parser converts a query
...: SQLStatement → BoundStatement QueryNode → BoundQueryNode TableRef → BoundStatement ParsedExpression → Expression Logical Planner The logical planner creates LogicalOperator nodes from the bound statements. In this phase, the actual logical query tree...is created. Optimizer After the logical planner has created the logical query tree, the optimizers are run over that query tree to create an optimized query plan. The fol... - https://man.mtool.work/duckdb/2.0/internals/overview.html
- Profiling 8052
- 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
...ted In DuckDB 2.0, the profiling_mode setting is deprecated and has no effect: detailed profiling information, such as the planner and optimizer metrics, is always collected. To restrict the collected metrics, use the tracked_metrics setting. Query Grap... - https://man.mtool.work/duckdb/2.0/dev/profiling.html
- R-Tree Indexes 7923
- 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
...unction must be a "constant" (i.e., an expression whose result is known at query planning time). This is because the query planner needs to know the bounding box of the query region before the query itself is executed to use the R-tree index scan. In th... - https://man.mtool.work/duckdb/2.0/core_extensions/spatial/r-tree_indexes.html
- Pragmas 7850
- 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
...Database Systems Research Group at the University of Tübingen . To return the physical query plan, including optimizer and planner metrics: SET enable_profiling = 'query_tree_optimizer'; Database drivers and other applications can also access profiling... - https://man.mtool.work/duckdb/2.0/configuration/pragmas.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work