Monitoring

Prev Next

Available in VPC

Monitoring supports four types of dashboards, enabling you to check various monitoring information for the performance and history of PostgreSQL. Monitoring is a service included in NAVER Cloud Platform's Cloud DB for PostgreSQL, so it can be used without additional charges. The types of dashboards provided by Monitoring are as follows:

  • DB dashboard: monitoring information related to PostgreSQL servers in operation
  • OS dashboard: monitoring information related to the OS of the PostgreSQL servers in operation
  • DB logs: records occurrence time and content of all logs that occur from PostgreSQL servers in operation
  • Query timeline: Query execution history of PostgreSQL servers in operation

You can check logs within the last year, the average value of the performance information of the PostgreSQL, and queries within the last 72 hours through these four types of dashboards. Each dashboard is configured with various graphic charts. You can utilize these charts in your business by printing specific graphic charts or downloading them to your local PC as files using various extensions.

Note

You can set the user to be notified when monitoring results show that a certain metric has exceeded its threshold or met specific conditions by having them recognized as events. For more information on the detailed usage for event and notification settings, see Event.

Since intuitive view and management for the PostgreSQL performance information is available without additional charges, if you wish to operate servers stably in an environment without a professional database manager, we recommend utilizing the monitoring metrics provided through the dashboard.

Monitoring page

The basics of using Monitoring are as follows:

clouddbforpostgresql-monitoring_01_vpc_ko

Area Description
① Menu name Name of the menu currently being viewed
② Basic features Check details for Cloud DB for PostgreSQL and refresh the Monitoring page
③ PostgreSQL service list The list of the PostgreSQL services in operation and the list of PostgreSQL servers by service
④ Dashboard DB dashboard, OS dashboard, DB logs, and query timeline of the selected server from the PostgreSQL server list

View Monitoring dashboards

Dashboards provided by Monitoring consist of multiple graphic charts. You can display and intuitively check only the information you need from the dashboard of each server. The information shown in the dashboard is collected every minute to be displayed, but it shows only the average values. To use dashboards, follow these steps:

  1. In the VPC environment of the NAVER Cloud Platform console, navigate to i_menu > Services > Database > Cloud DB for PostgreSQL.

  2. Click Monitoring menu.

  3. Click the PostgreSQL server to monitor from the list of PostgreSQL services.

  4. Click the button for the dashboard you want to check from the page on the right.

  5. Click and select all graphic charts you want to display and check on the dashboard.

  6. From the period or search time selection box, click and select the period you want to search, or enter it directly.

  7. Check the results from the dashboard.

    • To see the precise metric value of a specific point on the graphic chart, mouse over to the specific point on the graphic chart.
    • To see the detailed graph, double-click the graphic chart.
    • Print graphic chart: click clouddbforpostgresql-monitoring_ico-03, followed by Print chart
    • Download a graphic chart to your local PC as a file: click clouddbforpostgresql-monitoring_ico-03, followed by the file extension menu for the file you want to download
      • Download PNG image: image file with the .png extension
      • Download JPEG image: image file with the .jpeg extension
      • Download PDF document: document file with the .pdf extension
      • Download SVG vector image: vector image file with the .svg extension
      • Download CSV: document file with the .csv extension
Caution
  • In step 5, the default value is select all, and in step 6, the default is the last 1 hour.
  • In Step 6, the data view policy of the DB dashboard and OS dashboard follows the Cloud Insight policy, and the data view policy of the DB log follows the Cloud Log Analytics policy
Note

From the Services > Database > Cloud DB for PostgreSQL > DB server menu, click and select the server you want, and then click the [Monitoring] button to go directly to the page in Step 4.

DB Dashboard graphic charts

The following are some descriptions for the graphic charts configured in DB Dashboard:

clouddbforpostgresql-monitoring_06_vpc_ko

Graphic chart Unit Description
Sessions count Total session and active session count
Tuple Statistics rows Inserted, updated, deleted, fetched, and returned information for a tuple
Temp File bytes Temp file usage
Conflicts/Deadlocks count Number of conflicts and deadlocks occurred
Transactions count Information on transaction commits and rollbacks
Locks count Lock count information
Checkpoint Statistics sec Information on checkpoint write time and sync time
BgWriter Statstics buffers Buffer statistics information
Replication Lag sec Replication latency time
Database Size MB Size of database clusters
Slow Query count Slow query information
Buffer Hit Ratio % Buffer hit information

OS Dashboard graphic charts

The following are some descriptions for the graphic charts configured in OS Dashboard:

clouddbforpostgresql-monitoring_07_vpc_ko

Graphic chart Unit Description
CPU Usage used(%) CPU usage
Load Average - Server load
Memory Usage used(%) Memory usage
Swap Usage used(%) Swap memory volume
Disk Used GB Disk usage
Disk I/O MB / sec Disk Input/Output volume per second
Network I/O MB / sec Network Input/Output volume per second

DB Logs graphic charts

The following are the descriptions for the graphic charts configured in DB Logs:

clouddbforpostgresql-monitoring_08_vpc_ko

Field Description
Time when event occurred Time when DB Log occurred
Log content DB Log content
Note

In DB logs, you can check the slow log, error log, and general log of the PostgreSQL server in operation. However, for slow query, you need to change the value of log_min_duration_statement in DB Config to a value (ms) other than the default value (-1).

Query Timeline graphic charts

The following are the descriptions for the graphic charts configured in the Query Timeline:

clouddbforpostgresql-monitoring_09_vpc_ko

Field Description
pid Process ID
datname Name of the connected database
usename User name of the logged-in user
application_name Name of the application connected
client_addr IP address of the connected client
backend_start Start time of the process
query_start Time when the running query started, or last time a query started if stat is not active
wait_event Event that occurs depending on backend process actions
state Session process status
query Information of the query executed