cancel
Showing results for 
Search instead for 
Did you mean: 

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

Highlighted
08 Mountaineer

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

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 
1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Staff

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

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

View solution in original post

1 REPLY 1
Highlighted
Staff

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

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

View solution in original post

Webinar: Keep the modern workforce connected

Unified Communications has always been an important part of companies' digital transformation efforts due to its ability to enable rich virtual collaboration and communication. But with COVID-19, we've reached a break-through point.

Join Bill Haskins, Sr. Analyst & Partner, Unified Communications at Wainhouse Research, and John Ruthven, CEO at IR discuss UC challenges companies are experiencing due to the COVOID-19 crisis.

Join webinar