Monitoring User Sessions

The User Sessions charts provide information about Vertica user activities for all user connections open to MC.

Choose User Sessions from the menu at the top of your database's Activity page to view these charts.

View Open Sessions

The Open Sessions tab displays a table of currently open sessions for each user. You can close a session or cancel a query on this tab by selecting that option from the Actions column.

Click any row to open a Session Details dialog that shows more extensive information about that session.

To configure the Open Sessions page display:

View All User Sessions

The All Sessions tab displays a history of all user sessions in a swim lane chart.

What Chart Colors Mean

Bars outlined with a dotted line are currently running sessions.

Sessions are divided into two colors, yellow and blue.

Filter Chart Results

Extremely busy systems will show a lot of activity on the interface, perhaps more than you can interpret at a glance. You can filter chart results in several ways: