Manage instances
This guide explains how to manage running instances in the PostgreSQL service.
View instance list
You can check the list of instances included in a running PostgreSQL instance group. For details on the relationship between instance groups and instances, refer to Key Concepts.
-
Navigate to the KakaoCloud Console > Data Store > PostgreSQL menu.
-
Select the PostgreSQL instance group whose instance list you want to view in the Instance Group menu.
-
Go to the Instance menu.
Field Description Instance name Name of the PostgreSQL instance entered during creation AZ Availability zone information where the instance is created Status Current status of the PostgreSQL instance
- See Instance lifecycle and status values for detailsAvailability state Data replication status among PostgreSQL instances (applies only to high availability)
- See Instance availability state for detailsRole Role of the instance
- See Instance availability configuration and roles for detailsInstance type PostgreSQL instance type selected during creation Storage size Base/log storage size specified during creation Uptime Time elapsed since the instance was last updated (e.g., due to creation, restart, or failover) Creation date Date and time when the instance was created
Monitor instances
The Monitoring tab allows you to view monitoring results for PostgreSQL instance groups.
-
Navigate to the KakaoCloud Console > Data Store > PostgreSQL menu.
-
Select the PostgreSQL instance group you want to monitor in the Instance Group menu.
-
Go to the Monitoring tab.
Field Description Monitored instance Select the instance to monitor Metrics Select the metrics to view.
- Options: PostgreSQL, CPU, Memory, Filesystem, Disk, Network
- All metrics are displayed by default.
- Multiple selections are allowed.Data duration Period of data displayed in the monitoring graph.
- Options: 1 hour (default), 3 hours, 12 hours, 1 day, 7 daysView mode Set the layout of the monitoring graph view.
- Options: Single column, two columns, three columnsAuto-refresh interval Set the interval for auto-refreshing the monitoring graph.
- Options: No auto-refresh (default), 10 seconds, 30 seconds, 1 minute, 5 minutesManual refresh Click to refresh the monitoring results manually
Monitoring metrics
| Category | Metric | Description |
|---|---|---|
| PostgreSQL | Connections (count) | Number of PostgreSQL connections |
| PostgreSQL | Active connections (count) | Number of active PostgreSQL connections |
| PostgreSQL | Lock sessions (count) | Number of PostgreSQL lock sessions |
| PostgreSQL | Deadlocks (count) | Number of PostgreSQL deadlocks |
| PostgreSQL | Active transactions (count) | Number of active PostgreSQL transactions |
| PostgreSQL | Replication lag (seconds) | Replication lag time in seconds |
| PostgreSQL | Buffer hit ratio (%) | PostgreSQL buffer hit ratio |
| PostgreSQL | Vacuum XID | PostgreSQL vacuum XID measured per database |
| PostgreSQL | Temporary file usage (%) | Temporary file usage measured per database |
| CPU | Total usage (%) | Total CPU usage over time |
| Memory | Total usage (%) | Total memory usage over time |
| Memory | Usage by type (bytes) | Memory usage by type over time |
| Filesystem | Total usage (%) | Total filesystem usage over time |
| Filesystem | Total usage (bytes) | Filesystem usage in bytes over time |
| Filesystem | Inode usage by mount (%) | Filesystem inode usage by mount over time |
| Disk | Read bytes (bytes/sec) | Disk IO read usage over time |
| Disk | Write bytes (bytes/sec) | Disk IO write usage over time |
| Disk | Read IOPS (IO/sec) | Disk IO read operations per second |
| Disk | Write IOPS (IO/sec) | Disk IO write operations per second |
| Network | RX per interface (bytes) | Network RX usage per interface over time |
| Network | TX per interface (bytes) | Network TX usage per interface over time |
| Network | RX per interface (PPS) | Network RX packets per second per interface |
| Network | TX per interface (PPS) | Network TX packets per second per interface |
View instance logs
You can view PostgreSQL logs in the console using the Log Explorer provided by the KakaoCloud Monitoring service.
- Navigate to the Monitoring menu in the KakaoCloud Console.
- Click the Explorer tab, then select PostgreSQL in the Log Explorer.
- Check the query period and input the content to filter logs in Log Filter. File path filters are not currently supported.
- Once the search conditions are set, view the search results as charts and log lists.
info
For more details on using the Log Explorer, refer to the Log Explorer documentation.
Restart PostgreSQL
You can restart PostgreSQL for running instances.
- Restart is not available for instances with the status
Pending,Starting, orTerminating. - Restarting a primary instance may cause brief service disruptions.
- Navigate to the KakaoCloud Console > Data Store > PostgreSQL menu.
- Select the PostgreSQL instance group you want to restart from the Instance Group menu.
- Go to the Instance tab.
- Click the [More] icon for the instance to be restarted, then click Restart PostgreSQL.
- In the Restart PostgreSQL popup, review the details and click the [OK] button.