Results of 1 - 10 of about 15 for Unit (0.001 sec.)
- Metrics 13131
- 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
...', 'operator.timing'] . By default, all metrics are collected ( ['*'] ). The available metrics, along with their types and units, can be listed with the duckdb_available_metrics() table function: SELECT metric_name, metric_type, unit FROM duckdb_avai...storage operator optimizer parser planner physical_planner query Metrics Metrics measured over the entire query. Name Type Unit Description query.cpu_time double seconds CPU time spent on the query query.sql string The SQL string of the query query.t...tire query system Metrics Metrics on system resources, such as memory and threads, used while running the query. Name Type Unit Description system.blocked_thread_time double seconds Time spent waiting for a thread to become available system.peak_buff... - https://man.mtool.work/duckdb/2.0/dev/metrics.html
- Interval Type 12504
- INTERVAL s represent periods of time that can be added to or subtracted from DATE , TIMESTAMP , TIMESTAMPTZ , or TIME values. Name Description INTERVAL Period of time An INTERVAL can be constructed by providing amounts together with units.
...s that aren't months , days , or microseconds are converted to equivalent amounts in the next smaller of these three basis units. SELECT INTERVAL 1 YEAR, -- single unit using YEAR keyword; stored as 12 months INTERVAL (random() * 10) YEAR, -- parenth...or variable amounts; -- stored as integer number of months INTERVAL '1 month 1 day', -- string type necessary for multiple units; stored as (1 month, 1 day) '16 months'::INTERVAL, -- string cast supported; stored as 16 months '48:00:00'::INTERVAL, --...g supported; stored as (48 * 60 * 60 * 1e6 microseconds) ; Warning Decimal values are truncated to integers when used with unit keywords (unless the unit is SECONDS or MILLISECONDS ). sql SELECT INTERVAL '1.5' YEARS; -- Returns 12 months; equivalent... - https://man.mtool.work/duckdb/2.0/sql/data_types/interval.html
- Benchmark Suite 10205
- DuckDB has an extensive benchmark suite. When making changes that have potential performance implications, it is important to run these benchmarks to detect potential performance regressions. Getting Started To build the benchmark suite, ru
...ndow function. (The FILL function linearly interpolates missing values in an ordered partition.) Benchmarks are similar to unit test files, and have the same type of header. # name: benchmark/micro/window/window_fill.benchmark # description: Measure...eys}) keys(k) ); The argument parameters are expanded in the query, similar to the way that foreach values are expanded in unit tests. Note that we can issue multiple SQL statements in the load section. Once the data is prepared, we are finally ready...to specify the query we will benchmark! This is done in the run section, and the restrictions are the same as for a unit test (e.g., no blank lines, etc.) For the FILL benchmark, we want to find all places where the interpolation fails: run SE... - https://man.mtool.work/duckdb/2.0/dev/benchmark.html
- Interval Functions 8655
- This section describes functions and operators for examining and manipulating INTERVAL values. Interval Operators The table below shows the available mathematical operators for INTERVAL types. Operator Description Example Result + Addition
...onds, as double precision floating point number, in interval. normalized_interval(interval) Normalizes an interval so that units that overflow their range are carried over into the next larger unit. to_centuries(integer) Construct a century interval....epoch(INTERVAL 5 HOUR) | | Result | 18000.0 | normalized_interval(interval) | Description | Normalizes an interval so that units that overflow their range are carried over into the next larger unit. | | Example | normalized_interval(INTERVAL '30 days... - https://man.mtool.work/duckdb/2.0/sql/functions/interval.html
- Time Types 8446
- The TIME and TIMETZ types specify the hour, minute, second, microsecond of a day. Name Aliases Description TIME TIME WITHOUT TIME ZONE Time of day TIMETZ TIME WITH TIME ZONE Time of day, with time zone offset TIME_NS Time of day, nanosecond
...'15:30:00.123456789'::TIME_NS; 15:30:00.123456789 TIME_NS values can also be read from Parquet when the type is TIME with unit NANOS . Warning The TIME type should only be used in rare cases, where the date part of the timestamp can be disregarded.... - https://man.mtool.work/duckdb/2.0/sql/data_types/time.html
- Import Data 7924
- Overview The Rust client offers two ways to get data into DuckDB in bulk: the high-performance Appender for inserting rows from Rust, and reading directly from data files such as Parquet, CSV, and JSON. Both are described below. Appender Th
...Appending Inside a Transaction For a large load, wrapping the appends in a transaction lets DuckDB commit them as a single unit. Begin a transaction with Connection::transaction() , set it to commit on drop, and create the appender from the transacti... - https://man.mtool.work/duckdb/2.0/clients/rust/data_import.html
- Profiling 7924
- 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
....*'] . This replaces the custom_profiling_settings PRAGMA used in earlier versions. The available metric names, types, and units can be listed with the duckdb_available_metrics() table function: sql SELECT metric_name, metric_type, unit FROM duckdb_a... - https://man.mtool.work/duckdb/2.0/dev/profiling.html
- sqllogictest Introduction 7924
- For testing plain SQL, we use an extended version of the SQL logic test suite, adopted from SQLite . Every test is a single self-contained file located in the test/sql directory. To run tests located outside of the default test directory, s
...that the file is in. The name and group of the test are relevant because they can be used to execute only that test in the unittest group. For example, if we wanted to execute only the above test, we would run the command unittest test/sql/projection.../test_simple_projection.test . If we wanted to run all tests in a specific directory, we would run the command unittest "[projection]" . Any tests that are placed in the test directory are automatically added to the test suite. Note that..._slow extension indicates that the test takes a while to run, and will only be run when all tests are explicitly run using unittest * . Tests with the extension .test will be included in the fast set of tests. Query Verification Many simple tests sta... - https://man.mtool.work/duckdb/2.0/dev/sqllogictest/intro.html
- I/O 7819
- Warning DuckDB ships with safe defaults. The configuration options described on this page are advanced options, so proceed with caution when changing them. Asynchronous I/O New Asynchronous I/O was introduced in DuckDB 2.0. Starting with v2
...async_threads = 48; SET http_retries = 8; SET http_retry_wait_ms = 50; SET http_retry_backoff = 2; As the row group is the unit of parallelism for Parquet scans, asynchronous I/O works best if Parquet files have at least as many row groups as the num... - https://man.mtool.work/duckdb/2.0/data/io.html
- Unit Tester Configuration 7819
- There are three ways of setting options for the unit tester: Command Line Arguments Configuration File Environment Variables Configuration Options List See the Configuration Options List for the full list of available options. Command Line
...Arguments See the Configuration Options List for all available options. # booleans unittest --checkpoint-on-shutdown unittest --no-checkpoint-on-shutdown # other types unittest --checkpoint-wal-size 100000 Comm...onment variables, prefixed with DUCKDB_TEST_ , upper-cased with underscores: Example: DUCKDB_TEST_CHECKPOINT_ON_SHUTDOWN=1 unittest Configuration Options List The following configuration options are available: Option Description --autoloading <none|a... - https://man.mtool.work/duckdb/2.0/dev/sqllogictest/test_configuration.html
DuckDB 2.0 Documentation / man.mtool.work