Contents
LiveView system tables provide information about your LiveView Server instance. This section describes the standard set of LiveView system tables, listed in the order used by the lv-client listtables command.
All system tables have one or more internal columns whose names generally begin with
CQS. End-user developers must never change the contents of
these internal columns. Internal columns are not shown on this page, and are not shown
by default in the output of lv-client listtable
tablename. You can see the
internal columns by appending -a to an lv-client command: lv-client listtable tablename -a.
The LVSessionPublishers contains session publisher statistics information; its columns are described in the following table.
| Column Name | Data Type | Column Description |
|---|---|---|
| PID | long | Publisher ID. |
| SID | string | Session ID. |
| User | string | Name of the requesting user. |
| ClientInfo | string | Client-supplied identifying text. |
| TableName | string | Name of the table published to. |
| Publisher | string | Table publisher-supplied identifying text. |
| LastPublishedID | long | Table publisher-supplied ID. |
| TotalPublished | long | Total tuples published since server start. |
| Created | timestamp | When this publisher session started. |
| LastPublish | timestamp | When the last published tuple was sent. |
| PublishedPerSecond | double | Number of tuples per second published. |
The LVTables table contains information about all tables (system and data) in a given project.
| Column Name | Data Type | Column Description |
|---|---|---|
| Name | string | The name of the table. |
| Group | string | The full group the table belongs to. |
| ShortDescription | string | Short description of the table. |
| Description | string | Full description of the table. |
| TableSpace | string | The name of table space that the table is part of. |
| Capabilities | string | The capabilities of this table, in a comma-delimited list, including the types of queries that are supported (continuous or not, TopN, Time-windowed), and whether the table supports alert rules and deletion. |
| QueryLanguages | string | The query languages that the table supports. Possible values are LiveView and SQL. |
| isEnabled | bool | True if this row's table is enabled; false otherwise. |
| Indices | string | Comma- and semicolon-separated list of indexes in the table. The first index listed is always the primary key. |
| StatusENUM | string | Enum whose values describe the current status of this table. |
| StatusMessage | string | Message describing this table's current status. |
| IsSystemTable | bool | True if this is a system table. |
| CreateTime | timestamp | The time this table was created, which is not necessarily the time it was last started. |
The LVSessions table contains session information including remote host and recent activity. The columns are described in the following table.
| Column Name | Data Type | Column Description |
|---|---|---|
| SID | string | Session ID. |
| User | string | User name for this session. |
| Host | string | The Host IP for this session. |
| QueryCount | int | The total number of queries from this session. |
| LastRequestTime | timestamp | The last time the session communicated with the server. |
| LastRequest | string | The last request made from this session. |
| ClientInfo | string | Client-supplied identifying text. |
| Created | timestamp | The time this session was created. |
| Type | string | The protocol type for this session. |
| SessionTimeout | long | The quiescent period before this session will be closed. |
The LVSessionQueries table contains session query information, including predicate and performance information. The columns are described in the following table.
| Column Name | Data Type | Column Description |
|---|---|---|
| SID | string | Session ID. |
| User | string | User name for this session. |
| ClientInfo | string | Client-supplied identifying text. |
| QID | int | Query ID. |
| Type | string | Type of query (snapshot, continuous, or snapshot and continuous). |
| TableName | string | The table specified in the query. |
| Projection | string | The projection portion of the query. |
| PredicateExpression | string | The predicate portion of the query. |
| EndOfSnapshot | bool | Boolean indicating whether the snapshot is complete. |
| SnapshotTime | long | Number of milliseconds the snapshot took. |
| Exception | string | Last exception text, if any. |
| SnapshotAdds | int | Number of tuples added during snapshot. |
| Added | int | Number of tuples added. |
| Updated | int | Number of tuples updated. |
| Removed | int | Number of tuples removed. |
| Sent | int | Number of tuples sent. |
| Pending | int | Number of tuples waiting to be sent. |
The LVTableColumns table contains information about all table columns in a given project.
| Column Name | Data Type | Column Description |
|---|---|---|
| Table | string | The name of the table that contains this column. |
| Name | string | The name of this column. |
| Type | string | Data type of this column. |
| ShortName | string | Short name of this column that appears in the column headings. |
| Description | string | The full description of this column. |
The LVAlerts table contains information about alerts in a project.
| Column Name | Data Type | Column Description |
|---|---|---|
| AlertKey | string | A string identifier for an alert rule, generated by the server at the time that the alert actions are executed |
| AlertRuleID | long | ID number of this alert rule. |
| SourceInternalID | long | LiveView internal ID of the source table. |
| SourceTable | string | The name the LiveView data table against which the alert conditions are checked. |
| AlertRuleName | string | Name assigned to this alert. |
| Created | timestamp | When this alert was created. |
| LastModified | timestamp | When this alert was last modified. |
| Severity | int | Severity value integer, which can be 1 (Low), 3 (Medium), and 5 (High). The default value is 3 (Medium). |
| Recipient | string | The username of an intended recipient of the alert. The default is "*" to indicate "anyone". |
| Message | string | The default notification message for the alert. |
| Payload | string | A LiveQL query predicate specifying data conditions in the specified table. When the predicate evaluation changes from false to true, the alert fires. |
The LVAlertRulesStatus contains information about the current status of alert rules that have fired.
| Column Name | Data Type | Column Description |
|---|---|---|
| AlertRuleID | long | ID of the alert rule that fired. |
| Name | string | Name of the alert that fired. |
| LastFired | timestamp | The last time this alert fired. |
| AlertsPerMinute | int | Number of alerts that occurred in the last minute. |
| Enabled | bool | Whether or not this rule will fire when triggered; the default value is true. |
| Status | string | The current status of this alert. |
The LiveViewStatistics table has five columns that present diagnostic information about each table in a project, plus one column for the table's name. The columns are described in the following table.
| Column Name | Data Type | Column Description |
|---|---|---|
| TableName | string | Name of the LiveView table. |
| RecordCount | long | Number of rows in the LiveView table named in the previous field. |
| InboundTuplesPerSec | int | The rate, in tuples per second, that data is being published to the specified table. |
| TotalQueuedTuples | int | The total number of tuples waiting in queues that need to be processed. |
| MBMemoryUsed | int | Approximate number of megabytes the specified table currently consumes. |
| TotalTuplesPublished | long | The total number of tuples sent to the specified table, including updates and inserts. |