state_periods()

Returns the times in a given state in a timeline aggregate.


state_periods(
    state [TEXT | BIGINT],
    agg TimelineAgg
) RETURNS (TIMESTAMPTZ, TIMESTAMPTZ)

warning

Experimental features could have bugs. They might not be backwards compatible, and could be removed in future releases. Use these features at your own risk, and do not use any experimental features in production.

Required arguments

Name	Type	Description
`state`	`TEXT` or `BIGINT`	The state to get data for
`agg`	`TimelineAgg`	The aggregate to get data for

Returns

Column	Type	Description
`start_time`	`TIMESTAMPTZ`	The time the state started at (inclusive)
`end_time`	`TIMESTAMPTZ`	The time the state ended at (exclusive)

Sample usage

Getting the history of states in a timeline aggregate:


SELECT start_time, end_time FROM toolkit_experimental.state_periods(
  'OK',
  (SELECT toolkit_experimental.timeline_agg(ts, state) FROM states_test)
);

Example output:


start_time       |        end_time
------------------------+------------------------
 2020-01-01 00:00:11+00 | 2020-01-01 00:01:00+00
 2020-01-01 00:01:03+00 | 2020-01-01 00:02:00+00