Skip to content

list_views

The list_views function/procedure returns information about all active epsio views in the system.

Syntax

SELECT * FROM epsio.list_views(); 

Output

Column Information
id The ID of the view.
view_name A unique name for the view.
status The current status of the view. See #view-status for more details.
message An optional message regarding the view. For example: an error message.
query The full SQL query that was used to create the view.
use_existing_table Is the defined view supposed to use an existing underlying table (and not create it).
received_diffs Amount of diffs view received from CDC / population since it's creation.
fully_processed_diffs Amount of diffs the view has finished processing.
last_updated Datetime of the last status update.
latency Latency in seconds from commit on source database until result table gets updated

Details

View Status

The status of a view could be one of the following:

Status Information
running The view has been created, and the initial population has been completed. It is now being constantly updated as data changes.
populating The view is currently processing the data that was resident in the tables before the view was created. Thus, it is not yet ready to be queried.
pending The view is waiting for another view to finish populating before starting the population process.
stopped The view is temporarily stopped by Epsio (usually happens during upgrades).
error An error has occurred while creating the view or while processing data. More information might be available in the message column.
killed The view has been terminated by Epsio (usually occurs when the core engine fails or runs out of memory).
sink error The view received an error while updating the result table. Once error is resolved, view will automatically resume.

Examples

SELECT view_name, query FROM epsio.list_views();
SELECT * FROM epsio.list_views() WHERE view_name = 'population_sum'; 
CALL epsio.list_views(); 

Output

Column Information
id The ID of the view.
view_name A unique name for the view.
status The current status of the view. See #view-status for more details.
message An optional message regarding the view. For example: an error message.
query The full SQL query that was used to create the view.
received_diffs Amount of diffs view received from CDC / population since it's creation.
fully_processed_diffs Amount of diffs the view has finished processing.
last_updated Datetime of the last status update.
latency Latency in seconds from commit on source database until result table gets updated

Details

View Status

The status of a view could be one of the following:

Status Information
running The view has been created, and the initial population has been completed. It is now being constantly updated as data changes.
populating The view is currently processing the data that was resident in the tables before the view was created. Thus, it is not yet ready to be queried.
pending The view is waiting for another view to finish populating before starting the population process.
stopped The view is temporarily stopped by Epsio (usually happens during upgrades).
error An error has occurred while creating the view or while processing data. More information might be available in the message column.
killed The view has been terminated by Epsio (usually occurs when the core engine fails or runs out of memory).

Examples

CALL epsio.list_views();