Performance Store

Time formats

Views will usually contain either of the two timestamp columns: sample_time or post_time.

If sample_time is present, it states that the data in the view is sample based, e.g. data in v_activity, that is retrieved every 30 seconds (default value).

If post_time is present, it states the exact time the data or event occured, e.g. data in v_audit.

Values in the sample_time and post_time columns will always be in UTC time format.

Some views contains sample_time_local or post_time_local column, which represent the values from sample_time or post_time converted to the local time.

The sample_time or post_time column will usually be the clustering key column, so filtering on this column will be significantly faster than filtering on sample_time_local or post_time_local.

Note, in the graphical dashboards, there will be no sample_time_local or post_time_local columns. There will only be sample_time and post_time, whereas these columns will reflect the chosen UTC time setting chosen in the Performance Store Control Center.

Many views contains additional columns containing date- and time information, e.g. last_request_start_time, last_request_end_time, request_time, grant_time etc. The values in these columns will reflect the chosen UTC setting from the Performance Store Control Center. E.g. when chosen to use UTC times, the values in these columns will be in UTC time. When chosing not to use UTC time, the values in these columns will be the local time.

Changing the UTC time setting in the Performance Store Control Center, will immediately be reflected in the various views without any data conversion.