- Print
- PDF
Monitoring
- Print
- PDF
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 is 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.
You can set the user to be notified when monitoring results show that a certain indicator has exceeded its threshold or met specific conditions by having them recognized as events. For detailed usage methods 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 indicators provided through the dashboard.
Monitoring page
The basics of using monitoring are as follows:
Field | 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. The following describes how to use dashboards:
Click the Services > Database > Cloud DB for PostgreSQL menus from NAVER Cloud Platform console, in that order.
Click the Monitoring menu.
Click the PostgreSQL server to monitor from the list of PostgreSQL services.
Click the button for the dashboard you want to check from the page on the right.
Click and select all graphic charts you want to display and check on the dashboard.
From the Period or Search time selection box, click and select the period you want to search, or enter it directly.
Check the results from the dashboard.
- If you want to see the precise indicator value of a specific point on the graphic chart: mouse-over to the specific point on the graphic chart
- If you want to see the detailed graph: double-click on the graphic chart
- Print graphic chart: click , and then click the Print chart menu.
- Download a graphic chart to your local PC as a file: click , and then click 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
- In Step 5, the default value is Select all, and in Step 6, the default value is Recent 1H.
- 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.
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:
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 of 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:
Graphic chart | Unit | Description |
---|---|---|
CPU Usage | used(%) | CPU usage |
Load Average | - | Server load |
Memory Usage | used(%) | Memory usage |
Swap Usage | used(%) | Generated swap memory |
Disk Used | GB | Disk usage |
Disk I/O | MB / sec | Generated disk input/output per second |
Network I/O | MB / sec | Generated network input/output per second |
DB logs graphic charts
The following are the descriptions for the graphic charts configured in DB logs:
Field | Description |
---|---|
Time when event occurred | Time when DB log occurred |
Log content | DB log content |
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.
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 |