list_views¶

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

Syntax¶

PostgreSQLMySQL

SELECT * FROM epsio.list_views();

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.

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).

SELECT view_name, query FROM epsio.list_views();

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

CALL epsio.list_views();

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

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).

CALL epsio.list_views();