Resources
EXPLAIN: Inspect Query Plans
In order to view the query plan of a query, prepend EXPLAIN to a query. EXPLAIN SELECT * FROM tbl; By default only the final physical plan is shown. In order to see the unoptimized and optimized logical plans, change the explain_output setting: SET explain_output = 'all'; Below is an example of running EXPLAIN on Q13 of the TPC-H benchmark on the scale factor 1 data set. EXPLAIN SELECT c_count, count(*) AS custdist…
ResourcesLambda Functionsduckdb.org
ResourcesLance Extensionduckdb.org
ResourcesVortex Extensionduckdb.org
ResourcesCSV Importduckdb.org
ResourcesJSON Overviewduckdb.org
ResourcesLIMIT and OFFSET Clausesduckdb.org
ResourcesLance Extensionduckdb.org
ResourcesLIMIT and OFFSET Clausesduckdb.org
ResourcesLIMIT and OFFSET Clausesduckdb.org
ResourcesLIMIT and OFFSET Clausesduckdb.org
ResourcesLIMIT and OFFSET Clausesduckdb.org
ResourcesLIMIT and OFFSET Clausesduckdb.org
ResourcesLIMIT and OFFSET Clausesduckdb.org
ResourcesLIMIT and OFFSET Clausesduckdb.org
ResourcesTroubleshootingduckdb.org
ResourcesTroubleshootingduckdb.org
ResourcesKnown Python Issuesduckdb.org
ResourcesTroubleshootingduckdb.org
ResourcesJupyter Notebooksduckdb.org
ResourcesJupyter Notebooksduckdb.org