Q: Units in add_retention_policy() with integer-based timestamps

Andre_Mazayev · December 21, 2023, 6:09pm

Hi

What are the units when setting the retention with integer-based timestamps?

The only example provided in there (link to docs: Timescale Docs )

SELECT add_retention_policy('conditions', BIGINT '600000');

What is 600000? Seconds, minutes, hours?

Checked the source code but did not find anything about the units:

github.com

timescale/timescaledb/blob/8ecce0d96bd1f1153d55a7af0403edb62af38e7a/sql/updates/2.13.0--2.12.2.sql#L201-L210


      
          CREATE FUNCTION @[email protected]_retention_policy(
                 relation REGCLASS,
                 drop_after "any",
                 if_not_exists BOOL = false,
                 schedule_interval INTERVAL = NULL,
                 initial_start TIMESTAMPTZ = NULL,
                 timezone TEXT = NULL
          )
          RETURNS INTEGER AS '@MODULE_PATHNAME@', 'ts_policy_retention_add'
          LANGUAGE C VOLATILE;