Monitoring a CTERA Portal Database
  • 21 Jul 2022
  • 6 Minutes to read
  • Dark
    Light
  • PDF

Monitoring a CTERA Portal Database

  • Dark
    Light
  • PDF

For any instance defined in a workspace, you can monitor the following:

Note

The CTERA Portal Monitoring Service monitors the CTERA Portal databases including details that are not required by CTERA. For this reason, only a CTERA representative can fully understand whether what is being monitored is relevant to the CTERA Portal and only a CTERA representative can make changes based on the recommendations of the CTERA Portal Monitoring Service.

Access monitoring by clicking the instance you want to monitor in the Instances List screen.

  1. Click the workspace to monitor.
    The Instances for that workspace are displayed.
    image.png
  2. Click the instance you want to monitor.
    The Overview screen for the instance is displayed.
  3. Select what you want to monitor from the navigation area.

To pin the navigation area:

  • Click the pin at the bottom of the navigation area.
    image.png
    The navigation area remains open.
    image.png

To unpin the navigation area:

  • Click the pin at the bottom of the navigation area.

image.pngOverview Details

The Overview screen provides an overall picture of every facet of the CTERA Portal database that is being monitored.
Click image.png to display the Overview screen.
image.png
When the data displayed includes more than one indicator, for example with the TOP 5 TOTAL QUERY TIME tile, you can filter the display by clicking an indicator at the bottom of the tile to show or hide the indicator.

If required, scroll down to see additional details.
image.png
If one of the information tiles has more than one option to display, for example, more than one disk or network interfaces, click on a point at the bottom of the tile to switch the option being displayed.

The NOTIFICATIONS tile displays the alerts that have occurred on this instance. If you click View all messages, the Alerts page is displayed.

Warning

You should contact CTERA at the earliest opportunity if an alert is displayed, so that action can be taken to resolve the issue.

Click image.png on the right-side of an information tile to display a description of the tile and a pop-out window showing a more detailed view of the tile.
image.png

Popout View

image.png
When the data displayed includes more than one indicator, you can filter the display by clicking an indicator at the bottom of the tile to show or hide the indicator.

The default pop-out shows details of the last 30 minutes. Click image.png to change the view.
image.png

Info View

image.png

image.pngConfigurations Details

The Configuration screen shows the postgresql.conf file and suggests optimal values.
image.png
Each item in the list is color coded:
White – The default value.
Green – The item has been changed and the change has taken effect.
Yellow – The item has been changed. A reload is required for the change to take effect.
Red – The item has been changed. A restart is required for the change to take effect.

image.pngMaintenance Details

The Maintenance screen is not available for the replication database.
image.png
To populate the screen with the bloat and wraparound values, click Collect data.
image.png
After collecting data, you can refresh the displayed information by clicking Refresh data.

Clicking image.png displays options to fix in the database. If something needs fixing, contact CTERA Support.

Click the History tab to display the maintenance history for the database. You can drill-down to display more details of a maintenance that was carried out by clicking image.png and then Open.

image.pngDB Inspector Details

The DB Inspector screen displays a list with information about the database, as well as the database size.
image.png
Click Inspect for more detailed information.
image.png
The default time period is the last 12 hours. Click image.png to change the period.

To collect up-to-date information, click Collect data.
image.png
After collecting data, you can refresh the displayed information by clicking Refresh data.

Click on a table link in the collected data to display more details.
image.png
Click the Statistics tab for statistical information. The screen provides detailed statistics and the distribution of values from the last analysis on the issue related to the problem table, index or seqscan.
image.png

image.pngQuery Profiler Details

The Query Profiler screen displays statistics from the pgstatstatements extension.
image.png
The data from pgstatstatements is grouped to prevent duplication for identical requests. Only the 50 longest queries are selected for each iteration of collecting statistical information, all the others are grouped into the other block.

The graph displays the average execution time of queries and gives you the ability to change the time frame. The default time period is the last 30 minutes. Click image.png to change the period.

You can search the data based on the query hash, on the left above the list, or, on the right above the list:

  • Top returned rows
  • Top CPU time
  • Top I/O time
  • Top calls
  • Top temp blocks written

A menu with options for more detailed consideration of the query (number 5 in the figure above).

The query appears after clicking the plus sign (number 6 in the figure above).

Clicking + at the beginning of a row expands the row details.
image.png

Clicking image.png displays a Details option.

image.pngActivity Details

The Activity screen displays the aggregated session counts from the database by users or system.

The information is refreshed once every five seconds.

USERS

image.png
Click the grid button, image.png, to display more details.
image.png

SYSTEM

image.png

Click a row to display the RUNNING tab, to display all the open sessions that are connected to this database.
image.png
Click Freeze to inspect the information, as it can change as the data is refreshed every 5 seconds. You can then apply filters to the information.

Click a row to display more information about the session.
image.png

WAITING Tab

When you select the WAITING tab, you see a list of all waiting sessions to database.
image.png

Note

Since the screen is refreshed every 5 seconds so sessions can be displayed and then not displayed. Therefore, it is possible to freeze the current state.

BLOCKING Tab

When you select the BLOCKING tab, you see a list of all blocking sessions to database.

Note

Since the screen is refreshed every 5 seconds so sessions can be displayed and then not displayed. Therefore, it is possible to freeze the current state.

image.pngReplication Details

The Replication screen is only valid is a replication database server has been defined for the CTERA Portal.

The STANDBYS tab contains a list of the replicas taken from the primary server with their information and statuses:

Green – The replica is active.
Grey – The replica is inactive.

Click on the row to display more information about the replication database.

image.pngTable Spaces Details

The Table Spaces screen displays a list with information about the table spaces present in the database.

image.pngCharts Details

The Charts screen enables you to select different metrics to display charts to represent the metrics.
image.png
The default time period for the charts is the last 30 minutes. Click image.png to change the period.

Click Metrics to display the optionsץ.
image.png
The following combination of metrics already configured:

Performance

The Performance charts automatically select the following metrics:

  • Load average
  • CPU usage
  • Transactions per second
  • Sessions
    image.png

Locks

The Locks charts automatically select the following metrics:

  • Waiting locks
  • Sessions
  • Locks
    image.png

Size

The Size charts automatically select the following metrics:

  • Filesystems size
  • Tablespaces size
  • Instance size
  • WAL Files size
    image.png

image.pngMonitoring Configuration Details

The Monitoring Configuration screen displays the agent configuration and via the TRIGGERS tab, the triggers for alerts.
image.png

TRIGGERS Tab

image.png


Was this article helpful?