Resources

EXPLAIN ANALYZE: Profile Queries

duckdb.org

Prepending a query with EXPLAIN ANALYZE both pretty-prints the query plan, and executes it, providing run-time performance numbers for every operator, as well as the estimated cardinality (EC) and the actual cardinality. EXPLAIN ANALYZE SELECT * FROM tbl; Note that the cumulative wall-clock time that is spent on every operator is shown. When multiple threads are processing the query in parallel, the total processing…

Visit Site

Resources duckdb.org