Results of 1 - 8 of about 8 for renders (0.001 sec.)
- Agent Mode 13573
- New Agent mode was introduced in DuckDB 2.0. Agent mode renders the CLI's output for consumption by an AI coding agent rather than a human at a terminal. It produces compact Markdown tables with explicit result limits, machine-readable erro
...-c "SELECT 42 AS answer;" To force it off: duckdb -no-agent -c "SELECT 42 AS answer;" Output Format In agent mode, DuckDB: Renders results as compact Markdown tables. Prints a footer with the row count and, when the whole result was read, an order-indep...endent hash of the result. Emits errors as JSON on stderr . Renders compact query plans and cost estimates. Prints an estimate line and progress on stderr for a query that reads more than 1,... - https://man.mtool.work/duckdb/2.0/clients/cli/agent_mode.html
- Profiling Queries 9687
- DuckDB supports profiling queries via the EXPLAIN and EXPLAIN ANALYZE statements. EXPLAIN To see the query plan of a query without executing it, run: EXPLAIN ⟨query⟩; The output of EXPLAIN contains the estimated cardinalities for each opera
...tor. EXPLAIN (SQL) New As of DuckDB 2.0, EXPLAIN (SQL) renders the optimized logical plan back as an executable DuckDB SQL string instead of as a plan tree: sql EXPLAIN (SQL) SELECT 1 +... - https://man.mtool.work/duckdb/2.0/sql/statements/profiling.html
- Importing Duckbox Tables 8476
- The scripts provided in this page work on Linux, macOS, and WSL. By default, the DuckDB CLI client renders query results in the duckbox format , which uses rich, ASCII-art inspired tables to show data. These tables are often shared verbatim
... - https://man.mtool.work/duckdb/2.0/guides/snippets/importing_duckbox_tables.html
- Output Formats 8241
- The .mode dot command may be used to change the appearance of the tables returned in the terminal output. In addition to customizing the appearance, these modes have additional benefits. This can be useful for presenting DuckDB output elsew
...pager command can also be configured via the DUCKDB_PAGER or PAGER environment variables. duckbox Mode By default, DuckDB renders query results in duckbox mode, which is a feature-rich ASCII-art style output format. The duckbox mode supports the large_... - https://man.mtool.work/duckdb/2.0/clients/cli/output_formats.html
- C++ API 8241
- Installation To use the DuckDB C++ API, download the libduckdb archive for your platform. The latest stable version of the DuckDB C++ API is 2.0.0. Warning DuckDB's C++ API is internal. It is not guaranteed to be stable and can change witho
...x++) { for (idx_t col_idx = 0; col_idx < result->ColumnCount(); col_idx++) { // GetValue returns a duckdb::Value; ToString renders it (NULL values become "NULL") cout << result->Collection().GetValue(col_idx, row_idx).ToString(); cout << (col_idx + 1 <... - https://man.mtool.work/duckdb/2.0/clients/cpp.html
- Troubleshooting 8241
- Troubleshooting Running EXPLAIN Renders Newlines In Python, the output of the EXPLAIN statement contains hard line breaks ( \n ): In [1]: import duckdb ...: duckdb.sql("EXPLAIN SELECT 42 AS x") Out[1]: ┌───────────────┬─────────────────────
... - https://man.mtool.work/duckdb/2.0/clients/python/known_issues.html
- Profiling 8241
- 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
...ELECT 42 AS x; New As of DuckDB 2.0, the web format is available in the command line client . EXPLAIN ANALYZE (FORMAT WEB) renders the query graph and opens it in a web browser, and the .web dot command does the same for the previous query. Both are dis... - https://man.mtool.work/duckdb/2.0/dev/profiling.html
- Dot Commands 7519
- Dot commands are available in the DuckDB CLI client. To use one of these commands, begin the line with a period ( . ) immediately followed by the name of the command you wish to execute. Additional arguments to the command are entered, spac
...t option (alias --format ) forces pretty-printing, which is the default. Dumping Database Content as SQL The .dump command renders the database content as SQL statements, including both schema definitions and data. This is useful for creating backups or... - https://man.mtool.work/duckdb/2.0/clients/cli/dot_commands.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work