Persistent view commands (List, Status Started/Stopped, Details)

[Jerry]

What are the commands to see the following information of the Persistent Views:

• All define views
• Which views are started and which are not
• How much memory and CPU resources are currently being used by each active view 

[LouisZ · Accepted solution]

Hi Jerry,

Since Prognosis 11.3, you can find information about the persistent views in postgres. Information about all defined views can be found in the sysviews.existingviews table, and information about which views are running can be found in the sysviews.runningviews table. Unfortunately, we don't have information about CPU/memory for each active view.

You can run this command from the command line to get information about the persistent views. Please modify the command with an appropriate username.

psql -U <username> -d prognosis -c "select * from sysviews.existingviews"

Note: this will prompt for the password for the above user. You can append "> output.txt" to save the information into a text file for easier viewing.

Thanks,

Louis