Results of 1 - 8 of about 8 for period (0.004 sec.)
- Interval Type 13555
- 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.
...e days component is not split into additional units. To demonstrate this, the following query generates an INTERVAL called period by summing random amounts of the three basis units. It then extracts the aforementioned six parts from period , adds them...back together, and confirms that the result is always equal to the original period . SELECT period = list_reduce( [INTERVAL (datepart(part, period) || part) FOR part IN ['year', 'month', 'day', 'hour', 'mi...(random() * 123_456_789_123) MICROSECONDS + INTERVAL (random() * 12_345) DAYS + INTERVAL (random() * 12_345) MONTHS ) ) _(period); Warning The microseconds component is split only into hours, minutes and microseconds, rather than hours, minutes, secon... - https://man.mtool.work/duckdb/2.0/sql/data_types/interval.html
- Profile and Monitor 9579
- 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
...value. The JDBC property is only an enable and label switch. It does not control whether JFR is recording or the sampling period; those are governed by the JFR recording settings. Controlling the Period and Enabled State The sampling rate and enabled...programmatically 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 name="duckdb.MemoryUsage"> <setting name="enabled">true</setting> <setting name="period">1 s</setting> </event> When no recording enables the event, the driver does no work: the underlying duckdb_memory() query... - https://man.mtool.work/duckdb/2.0/clients/java/profiling.html
- PostgreSQL Extension Functions 8729
- postgres_clear_cache postgres_configure_pool postgres_execute postgres_hstore_get postgres_hstore_to_json postgres_query read_postgres_binary postgres_clear_cache postgres_clear_cache() -> TABLE Clears cached schema entries (like table name
...n the connection pool reaper thread is enabled ( enable_reaper_thread argument), then this number is checked in background periodically. idle_timeout_millis ( UBIGINT ): maximum number of milliseconds the connection can be kept idle in the pool. This n...hen the connection pool reaper thread is enabled ( enable_reaper_thread option), then this number is checked in background periodically. enable_reaper_thread ( BOOLEAN ): whether to enable the connection pool reaper thread, that periodically scans the...ion can be kept idle in the pool reaper_thread_running ( BOOLEAN ): whether the pool reaper thread is running; this thread periodically scans the pool to check the max_lifetime_millis and idle_timeout_millis and closes connections which exceed the spec... - https://man.mtool.work/duckdb/2.0/core_extensions/postgres/functions.html
- Command Line Client 8476
- Installation To use the DuckDB CLI client, visit the CLI installation page . The latest stable version of the DuckDB command line client is 2.0.0. Installation The DuckDB CLI (Command Line Interface) is a single, dependency-free executable.
...o SQL syntax, special dot commands may be entered into the 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...may be used to wrap that parameter. Dot commands must be entered on a single line, and no whitespace may occur before the period. No semicolon is required at the end of the line. Frequently-used configurations can be stored in the file ~/.duckdbrc , w... - https://man.mtool.work/duckdb/2.0/clients/cli/overview.html
- Dot Commands 8368
- 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
...may be used to wrap that parameter. Dot commands must be entered on a single line, and no whitespace may occur before the period. No semicolon is required at the end of the line. To see available commands, use the .help command. List of Dot Commands C... - https://man.mtool.work/duckdb/2.0/clients/cli/dot_commands.html
- Literal Types 8115
- DuckDB has special literal types for representing NULL , integer and string literals in queries. These have their own binding and conversion rules. Prior to DuckDB version 0.10.0, integer and string literals behaved identically to the INTEG
...or '0b101'::INT = 5 . Other Numeric Literals Non-integer numeric literals can be denoted with decimal notation, using the period character ( . ) to separate the integer part and the decimal part of the number. Either the integer part or the decimal pa... - https://man.mtool.work/duckdb/2.0/sql/data_types/literal_types.html
- Release Cycle 7880
- This document outlines the DuckDB and core extension release cycle framework. It is intended for developers working on DuckDB extensions to better understand the underlying processes. Overview DuckDB follows Semantic Versioning ( v<MAJOR>.<
...sued as needed for all supported versions: The latest stable version Long Term Support (LTS) versions within their support period Versions with extended support (e.g., v1.5, which is supported until March 2027) All releases and their end-of-life dates... - https://man.mtool.work/duckdb/2.0/dev/release_cycle.html
- Complete API 7519
- This page contains the reference for DuckDB's C API. The reference contains several deprecation notices. These concern methods whose long-term availability is not guaranteed as they may be removed in the future. That said, DuckDB's develope
...alternative. Therefore, they will not be removed before the alternative is available, and even then, there will be a grace period of a few minor versions before removing them. The reason that the methods are already deprecated in v1.0 is to denote that... - https://man.mtool.work/duckdb/2.0/clients/c/api.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work