Contents
LiveView system tables provide information about your LiveView Server instance. This section describes the standard set of LiveView System Tables. Four of these system tables are displayed on the LiveView Monitor page of the LiveView Web UI.
The LiveView Statistics table has six columns that present diagnostic information about all tables in a project. The columns are described in the following table.
| Column Name | Column Description |
|---|---|
| TableName | Name of the LiveView table. |
| RecordCount | Number of rows in the LiveView table. |
| InboundTuplesPerSec | The rate, in tuples per second, that data is being published to the table. |
| TotalQueuedTuples | The total number of tuples that are waiting in queues that need to be processed. |
| MBMemoryUsed | Approximate number of megabytes this table is consuming. |
| TotalTuplesPublished | The total number of tuples sent to a table, includes updates and inserts. |
| LastCQSInternalID | The highest LiveView internal ID number in the table. |
The LiveView Sessions table contains session information including remote host and recent activity. The columns are described in the following table.
| Column Name | Column Description |
|---|---|
| ClientInfo | Client-supplied identifying text. |
| CQSInternalID | LiveView internal ID. |
| Created | The time this session was created. |
| Host | The Host IP for this session. |
| SID | Session ID. |
| User | User name for this session. |
| QueryCount | The total number of queries from this session. |
| LastRequestTime | The last time the session communicated with the server. |
| LastRequest | The last request made from this session. |
| Type | The protocol type for this session. |
| Timeout | The quiescent period before this session will be closed. |
The LiveView Session Queries table contains session query information including predicate and performance information. The columns are described in the following table.
| Column Name | Column Description |
|---|---|
| Added | Total number of tuples added. |
| ClientInfo | Client-supplied identifying text. |
| CQSInternalID | LiveView internal ID. |
| EndOfSnapshot | Boolean indicating if the snapshot is complete. |
| Exception | Last exception text, if any. |
| Pending | Total tuples waiting to be sent. |
| QID | Query ID. |
| Query | Query string. |
| Removed | Total number of tuples removed. |
| Sent | Total tuples sent. |
| SID | Session ID. |
| SnapshotAdds | Number of tuples added during snapshot. |
| SnapshotTime | Number of microseconds the snapshot took. |
| SnapTuplesPerSec | The rate at which snapshot tuples were added. |
| Type | Type of query (snapshot, continuous, or snapshot and continuous). |
| Updated | Number of tuples updated. |
| User | User name for this session. |
The LiveView Alert Rules Status table.
| Column Name | Column Description |
|---|---|
| AlertRuleID | The Alert Rule ID that fired. |
| AlertsPerMinute | Number of alerts that occurred in the last minute. |
| CQSInternalID | LiveView internal ID. |
| Enabled | LiveView internal ID. |
| LastFired | The last time this alert fired. |
| Name | The last time this alert fired. |
| Status | The current status of this alert. |
The LVTables table contains information about all tables (system and data) in a given project.
| Column Name | Column Description |
|---|---|
| Capabilities | 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 the whether the Table supports alert rules and deletion. |
| CQSInternalID | The LiveView internal ID |
| Description | The full description of the table |
| Group | The full group the table belongs to |
| Name | The name of the table |
| QueryLanguages | The query languages that the table supports. Possible values are LiveView and SQL. |
| ShortDescription | Short description of the table. |
| TableSpace | The name of table space that the table is part of. |