44.1. Viewing Main Metrics #

  1. In the navigation panel, go to InfrastructureInstances.

  2. Click the name of the instance.

  3. In the navigation panel, go to Metrics.

The following graphs will be displayed:

  • WAL Archiver: The number of archived WAL segments.

  • Vacuum workers: The number of vacuum operations.

  • Background Writes: Buffers: The data volume written on 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: 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 a 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.

  • WAL: Written bytes: 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.