TSInstanceTable table

The TSInstanceTable table contains one row for each large time series, no matter how many times it is referenced.

Time series smaller than the threshold you specify when you create them are stored directly in a column and do not appear in the TSInstanceTable table.

Table 1. The columns in the TSInstanceTable table
Column name Data type Description
id SERIALBIGSERIAL The serial number of the time series and the primary key for this table. You can use the InstanceId function to return this number.

The instance ID is a required argument in some time series routines.

The instance ID is also used to order results if an SQL query includes an ORDER BY clause on a TimeSeries column.

cal_id INTEGER The identification of the CalendarTable row for the time series.
flags SMALLINT Stores various flags for the time series. The value 0x01 indicates that the time series is irregular.
  • 0x01 = TSFLAGS_IRR. The time series is irregular.
  • 0x10 = TSFLAGS_PACKED. The time series contains packed elements.
  • 0x20 = TSFLAGS_COMPRESSED. The time series is compressed.
  • 0x40 = TSFLAGS_HERTZ. The time series contains hertz data.
vers SMALLINT The version of the time series.
container_name VARCHAR(128,1) The name of the container of the time series. This is a reference to the primary key of the TSContainerTable table.
ref_count INTEGER The number of different references to the same time series instance.

The TSInstanceTable table is managed by the database server. Do not modify it directly. Rows in this table are automatically inserted or deleted when large time series are created or destroyed.