Metrics

Reference page to the Servoy Cloud Environment Database metrics

Overview

The metrics in the Database details section are displayed as charts.

Connections over time

Active

Represents the number of active database connections over a given period. Active connections are currently executing tasks within the database.

Idle

Showcases the number of idle database connections over time. Idle connections are open but not currently executing any operations.

Read stats over time

Select with index scan

Represents the frequency of data reading operations over time that use an index for faster data retrieval, optimizing the search instead of scanning the whole table.

Select with table scan

Shows the frequency of data reading operations over time that involve scanning the entire table. This method does not use an index for optimization.

Insert

Displays the frequency of data insertion operations over a given period. Each 'insert' operation adds new data to the database.

Update

Denotes the frequency of data update operations over time. Each 'update' operation modifies existing data within the database.

Delete

Shows the frequency of data deletion operations over a specific period. Each 'delete' operation removes existing data from the database.

Cache hit rate % over time

Cache hit rate % over time represents the percentage of database requests that were served from the cache over time. A high cache hit rate typically indicates efficient data retrieval, reducing the need for expensive disk I/0 operations.

Table locks over time

AccessExclusiveLock

AccessExclusiveLock is a type of table lock blocking all other access, used typically when modifying the physical structure of the table.

ExclusiveLock

The ExclusiveLock type of table block prevents concurrent modification to a table by other transactions but allows concurrent reads.