Results of 1 - 10 of about 22 for seconds (0.002 sec.)
- Metrics 15134
- 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
...er 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.total_intermediate_rows uint64 rows Cumulat...ilable to scan query.total_rows_scanned uint64 rows Cumulative number of rows scanned by the query query.total_time double seconds Time spent executing the entire query system Metrics Metrics on system resources, such as memory and threads, used while r...unning the query. Name Type Unit Description system.blocked_thread_time double seconds Time spent waiting for a thread to become available system.peak_buffer_memory uint64 bytes Peak memory usage of the buffer... - https://man.mtool.work/duckdb/2.0/dev/metrics.html
- Date Part Functions 11026
- The date_part , date_trunc and date_diff functions can be used to extract or manipulate parts of temporal types such as TIMESTAMP , TIMESTAMPTZ , DATE and INTERVAL . The parts to be extracted or manipulated are specified by one of the strin
...orian day days , d , dayofmonth 3 decade Gregorian decade dec , decades , decs 202 hour Hours hr , hours , hrs , h 11 microseconds Sub-minute microseconds microsecond , us , usec , usecs , usecond , useconds 44123456 millennium Gregorian millennium mil..., millenniums , millennia , mils , millenium 3 milliseconds Sub-minute milliseconds millisecond , ms , msec , msecs , msecond , mseconds 44123 minute Minutes min , minutes , mins , m...59 month Gregorian month mon , months , mons 8 quarter Quarter of the year (1-4) quarters 3 second Seconds sec , seconds , secs , s 44 year Gregorian year yr , y , years , yrs 2021 Part Specifiers Only Usable as Date Part... - https://man.mtool.work/duckdb/2.0/sql/functions/datepart.html
- Interval Functions 9578
- 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
...(part, interval) Alias of date_part . extract(part FROM interval) Alias of date_part . epoch(interval) Get total number of seconds, as double precision floating point number, in interval. normalized_interval(interval) Normalizes an interval so that unit...uct a day interval. to_decades(integer) Construct a decade interval. to_hours(integer) Construct an hour interval. to_microseconds(integer) Construct a microsecond interval. to_millennia(integer) Construct a millennium interval. to_milliseconds(integer)...terval. to_months(integer) Construct a month interval. to_quarters(integer ) Construct an interval of integer quarters. to_seconds(integer) Construct a second interval. to_weeks(integer) Construct a week interval. to_years(integer) Construct a year inte... - https://man.mtool.work/duckdb/2.0/sql/functions/interval.html
- Parquet Encryption 8602
- Starting with version 0.10.0, DuckDB supports reading and writing encrypted Parquet files. DuckDB broadly follows the Parquet Modular Encryption specification with some limitations . Reading and Writing Encrypted Files Using the PRAGMA add_
.../writing the lineitem table from TPC-H at SF1, which is 6M rows and 15 columns, from/to a Parquet file takes 0.26 and 0.99 seconds, respectively. With encryption, this takes 0.64 and 2.21 seconds, both approximately 2.5× slower than the unencrypted vers... - https://man.mtool.work/duckdb/2.0/data/parquet/encryption.html
- Reference 8535
- This page lists the functions, settings, and log types exposed by the quack extension . For a tour of the protocol, start with the Overview . Function Reference Server Management Function Description quack_serve(⟨listen_uri⟩, ...) Start a s
...to the server (minimum 4 characters). HEARTBEAT_TIMEOUT UBIGINT quack_default_heartbeat_timeout Heartbeat lease timeout in seconds requested from the server. Settings All settings are regular DuckDB session / global options. Set with SET ⟨name⟩ = ⟨value...rent connections the server accepts. Beyond this, new connections are refused. quack_server_keep_alive_timeout UBIGINT 300 Seconds an idle keep-alive connection is kept open by the server. Client Identity and Reconnects Setting Type Default Description...id if the variable is not set. Set to '' to opt out. quack_default_heartbeat_timeout UBIGINT 60 Heartbeat lease timeout in seconds requested by clients when ATTACH / quack_query omit heartbeat_timeout . quack_enable_reconnects BOOLEAN false Enable recon... - https://man.mtool.work/duckdb/2.0/quack/reference.html
- Interval Type 8467
- 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.
...Units 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...st supported; stored as 16 months '48:00:00'::INTERVAL, -- HH::MM::SS string 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 MILLISECON...pond to a fixed amount of days (February has fewer days than March) and a day doesn't correspond to a fixed amount of microseconds (days can be 25 hours or 23 hours long because of daylight saving time). The division into components makes the INTERVAL c... - https://man.mtool.work/duckdb/2.0/sql/data_types/interval.html
- Limits 8215
- This page contains DuckDB's built-in limit values. To check the value of a setting on your system, use the current_setting function. Limit Values Limit Default value Configuration option Comment Array size 100000 - BLOB size 4 GB - Expressi
...e database files using 15 TB+ of disk space and they work fine. However, connecting to such a huge database may take a few seconds and checkpointing can be slower.... - https://man.mtool.work/duckdb/2.0/operations_manual/limits.html
- Information Schema 8215
- The views in the information_schema are SQL-standard views that describe the catalog entries of the database. These views can be filtered to obtain information about a specific column or table. DuckDB's implementation is based on PostgreSQL
...data_type identifies a date, time, timestamp, or interval type, this column contains the (declared or implicit) fractional seconds precision of the type for this column, that is, the number of decimal digits maintained following the decimal point in the...seconds value. No fractional seconds are currently supported in DuckDB. For all other data types, this column is NULL . INTEGER 0... - https://man.mtool.work/duckdb/2.0/sql/meta/information_schema.html
- Working with Huge Databases 8080
- This page contains information for working with huge DuckDB database files. While most DuckDB databases are well below 1 TB, in our 2024 user survey , 1% of respondents used DuckDB files of 2 TB or more (corresponding to roughly 10 TB of CS
...be slow. For example, checkpointing after adding a few rows to a table in the TPC-H SF1000 database takes approximately 5 seconds. On block-based storage, the file system has a significant effect on performance when working with large files. On Linux,... - https://man.mtool.work/duckdb/2.0/guides/performance/working_with_huge_databases...
- Profile and Monitor 8013
- Overview The JDBC driver exposes several ways to observe a running or completed query: cancelling and timing out queries, polling query progress, retrieving profiling output, and emitting memory-usage events through Java Flight Recorder . T
...ent.cancel() method, which interrupts the query executing on the statement's connection. Setting Statement.setQueryTimeout(seconds) arms an automatic cancellation after the given number of seconds. For long-running queries, DuckDBPreparedStatement.getQu...with the jdk.jfr.Recording API: try (Recording r = new Recording()) { r.enable("duckdb.MemoryUsage").withPeriod(Duration.ofSeconds(1)); r.start(); // ... application work ... r.stop(); r.dump(Path.of("app.jfr")); } The equivalent .jfc snippet: <event na... - https://man.mtool.work/duckdb/2.0/clients/java/profiling.html
DuckDB 2.0 Documentation / man.mtool.work