51.1. Viewing Main Metrics #
To view charts associated with metrics:
In the navigation panel, go to Infrastructure → Instances.
Click the name of the instance.
In the navigation panel, go to Metrics.
Select the charts to be displayed on the page:
In the top-left corner of the page, select one of the following values from the Preset drop-down list:
Background Recording
Instance Overview
Instance Activity
Resource Usage
Streaming Replication
Database Usage
For this value, select the database from the Database drop-down list.
I/O Usage
For this value, select the backend type from the Backend Type drop-down list.
Not selected
Default value: Instance Overview.
Manually:
In the top-left corner of the page, select charts to display from the Charts drop-down list.
When selected, the default Instance Overview preset changes to Not selected.
Click Save.
(Optional) From the Period drop-down list, select the time period.
Default value: Last 3 hours.
You can set the custom time period. To do this, click Custom period, select the dates and time, and click Apply.
(Optional) In the top-right corner of the page, enable or disable the Simultaneous scaling toggle.
The toggle controls whether to maintain a single scale factor for all displayed charts.
Default value: Enabled — the displayed charts are scaled simultaneously.
The selected charts will be displayed. To manage an individual chart:
In the top-right corner of the chart, click Select interval or Reset to change the displayed interval or to reset it, respectively.
In the top-right corner of the chart, click Download .png or Download .svg to download the chart contents as PNG or SVG, respectively.
In the bottom of the chart, click the legend checkboxes to show or hide the data on the chart.
51.1.1. Chart List #
WAL Archiver: The number of archived WAL segments.
Vacuum Workers: The number of vacuum operations.
Background Writes: Buffers: The data volume written in the background from shared cache to disk.
Background Writes: Maxwritten/Fsync:
maxwritten: The number of times the background writer had to stop writing because the limit was reached.
fsync: The number of forced fsync calls.
Background Writes: Checkpoints: The number of checkpoints.
Background Writes: Checkpoints Write/Sync time: The time spent writing and synchronizing blocks during execution of checkpoints.
Instance: Connections: Connections established with the DBMS instance and their state.
Instance: Blocks rate: The number of cache hits and misses that resulted in the need to read data from disk.
Instance: Transactions rate: Transactional activity in the DBMS instance.
Instance: Events: Deadlocks, replication conflicts, and checksum validation errors in the DBMS instance.
Instance: Tuples: The number of rows read, inserted, updated, and deleted.
Instance: Cache hit ratio: The proportion of cache hits relative to all shared cache accesses.
Instance: Temp Bytes Written: The amount of data written to temporary files.
Instance: Temp Files: The number of temporary files written by the DBMS instance.
Instance: Locks: Lock dynamics.
Instance: Wait Events Types: The count of wait events, grouped by type.
The
ClientReadandExtensionwait events, as well as the wait events ofActivityandTimeouttypes, are not displayed in this graph.Instance: Wait Events: The count of wait events.
The
ClientReadandExtensionwait events, as well as the wait events ofActivityandTimeouttypes, are not displayed in this graph.WAL: Written bytes: The number of bytes written to WAL.
System: Load Average: Average server load.
System: Memory Usage: Usage of server memory.
System: Swap Usage: Usage of swap space in the system.
System: Processes: Usage of processes in the system.
System: CPU Usage: Usage of CPU in the system.
Streaming Replication: Lag, bytes: Streaming replication lag, in bytes.
Streaming Replication: Lag, time: Streaming replication lag, in milliseconds.
Instance: Wait Events Types: The count of wait events, grouped by type.
The
ClientReadandExtensionwait events, as well as the wait events ofActivityandTimeouttypes, are not displayed in this chart.Instance: Wait Events: The count of wait events.
The
ClientReadandExtensionwait events, as well as the wait events ofActivityandTimeouttypes, are not displayed in this chart.