Function accepts the following required and optional arguments. These arguments have the same semantics as the .

    Required Arguments

    Optional Arguments

    NameDescription
    older_than(ANY) Specification of cut-off point where any full chunks older than this timestamp should be shown.
    newer_than(ANY) Specification of cut-off point where any full chunks newer than this timestamp should be shown.

    The and newer_than parameters can be specified in two ways:

    • timestamp, date, or integer type: The cut-off point is explicitly given as a TIMESTAMP / TIMESTAMPTZ / DATE or as a SMALLINT / INT / BIGINT. The choice of timestamp or integer must follow the type of the hypertable’s time column.

    When both arguments are used, the function returns the intersection of the resulting two ranges. For example, specifying and older_than => 3 months will show all full chunks that are between 3 and 4 months old. Similarly, specifying newer_than => '2017-01-01' and older_than => '2017-02-01' will show all full chunks between ‘2017-01-01’ and ‘2017-02-01’. Specifying parameters that do not result in an overlapping intersection between two ranges will result in an error.

    Sample Usage

    Get all chunks from hypertable older than 3 months:

    Get all chunks from hypertable conditions before 2017: