LiveView System Tables

LiveView Statistics

The LiveView Statistics (LiveViewStatistics) table has six columns that present diagnostic information about each tables in a project, plus one column for the table's name, and three internal columns. The columns are described in the following table.

Column Name	Data Type	Column Description
CQSInternalID	long	LiveView internal ID.
CQSSequenceNumber	long	LiveView internal sequence number.
CQSErrorCode	int	LiveView internal error code number, if applicable.
TableName	string	Name of the LiveView table.
RecordCount	long	Number of rows in the LiveView table.
InboundTuplesPerSec	int	The rate, in tuples per second, that data is being published to the table.
TotalQueuedTuples	int	The total number of tuples waiting in queues that need to be processed.
MBMemoryUsed	int	Approximate number of megabytes this table is consuming.
TotalTuplesPublished	long	The total number of tuples sent to a table, including updates and inserts.
LastCQSInternalID	long	The highest LiveView internal ID number in the table.

LiveView Sessions

The LiveView Sessions (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
CQSInternalID	long	LiveView internal ID.
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.

LiveView Session Queries

The LiveView Session Queries (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
CQSInternalID	long	LiveView internal ID.
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).
Query	string	Query string.
EndOfSnapshot	bool	Boolean indicating if the snapshot is complete.
SnapshotTime	long	Number of microseconds the snapshot took.
SnapTuplesPerSec	double	The rate at which snapshot tuples were added.
Exception	string	Last exception text, if any.
SnapshotAdds	int	Number of tuples added during snapshot.
Added	int	Total number of tuples added.
Updated	int	Number of tuples updated.
Removed	int	Total number of tuples removed.
Sent	int	Total tuples sent.
Pending	int	Total tuples waiting to be sent.

LiveView Session Publishers

The LiveView Session Publishers table (LVSessionPublishers) contains session publisher statistics information; its columns are described in the following table.

Column Name	Data Type	Column Description
CQSInternalID	long	LiveView internal ID.
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 from.
Publisher	string	Publishing app.
LastPublishedID	long	ID of the last published tuple.
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.

LVAlerts

The LVAlerts table contains information about alerts in a project.

Column Name	Data Type	Column Description
CQSInternalID	long	LiveView internal ID.
CQSSequenceNumber	long	LiveView internal sequence number.
CQSErrorCode	int	LiveView internal error code number, if applicable.
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.

LiveView Alert Rules Status

The LiveView Alert Rules Status table (LVAlertRulesStatus).

Column Name	Data Type	Column Description
CQSInternalID	long	LiveView internal ID.
AlertRuleID	long	ID number of the alert rule that fired.
Name	string	Name of this alert rule.
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.

LVTables

The LVTables table contains information about all tables (system and data) in a given project.

Column Name	Data Type	Column Description
CQSInternalID	long	LiveView internal ID.
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	The 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.
CQSTableSchema	string	LiveView internal schema.
CQSKeyFieldsCSV	string	LiveView internal primary key info.
CQSRequiredClientCapabilities	string	LiveView internal capabilities info.

LVTableColumns

The LVTableColumns table contains information about all table columns in a given project.

Column Name	Data Type	Column Description
CQSInternalID	long	LiveView internal ID.
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.