Manage instance

This guide explains how to manage running PostgreSQL instances in the service.

View instance list

You can view the list of instances included in an active PostgreSQL instance group. For more about the relationship between instance groups and instances, see Key Concepts.

1. Go to the KakaoCloud Console > Data Store > PostgreSQL.

2. Select the instance group whose instance list you want to view.

3. Navigate to the Instance tab.

   Item	Description
   Instance name	The name specified when the PostgreSQL instance was created
   AZ	The availability zone where the instance was created
   Status	Instance status - See Lifecycle and status values
   Availability status	Indicates replication state between instances (HA only) - See Instance availability status
   Role	Role of the instance - See Availability and roles
   Instance type	The type selected at creation
   Storage size	Base and log storage size configured at creation
   Uptime	Time elapsed since last update (create/restart/failover)
   Created at	Instance creation date and time

Monitor instances

You can view monitoring results for PostgreSQL instance groups in the Monitoring tab.

1. Go to the KakaoCloud Console > Data Store > PostgreSQL.

2. Select the PostgreSQL instance group to monitor.

3. Click the Monitoring tab.

   Item	Description
   Monitored instance	Select instance to monitor
   Metric items	Choose metrics to display - Options: PostgreSQL, CPU, Memory, Filesystem, Disk, Network - Default view shows all - Multiple selections allowed
   Data period	Period shown in monitoring graph - Options: 1 hour (default), 3 hours, 12 hours, 1 day, 7 days
   View mode	Graph layout mode: single, two-column, or three-column views
   Auto-refresh interval	Options: Off (default), 10 sec, 30 sec, 1 min, 5 min
   Manual refresh	Click to refresh the monitoring graph

Monitoring metrics

Category	Metric	Description
PostgreSQL	Connection (count)	Number of total PostgreSQL connections
PostgreSQL	Connections (count)	Number of active PostgreSQL connections
PostgreSQL	Lock sessions (count)	Number of PostgreSQL lock sessions
PostgreSQL	Deadlocks (count)	Number of deadlocks in PostgreSQL
PostgreSQL	Active transactions (count)	Number of active transactions
PostgreSQL	Replication lag (sec)	Replication delay time
PostgreSQL	Buffer hit ratio (%)	Buffer cache hit ratio
PostgreSQL	Vacuum XID	Measured vacuum XID per DB
PostgreSQL	Temp file usage per DB (%)	Temp file usage by DB
CPU	Total usage (%)	Total CPU usage over time
Memory	Total usage (%)	Total memory usage over time
Memory	Usage by type (Bytes)	Memory usage per type over time
Filesystem	Total usage (%)	Total filesystem usage over time
Filesystem	Total usage (Bytes)	Total filesystem usage in bytes over time
Filesystem	Inode usage by mount (%)	Inode usage per mount over time
Disk	Read Bytes (Bytes/sec)	Disk IO read over time
Disk	Write Bytes (Bytes/sec)	Disk IO write over time
Disk	Read IOPS (IO/sec)	Read operations per second
Disk	Write IOPS (IO/sec)	Write operations per second
Network	RX by interface (Bytes)	Received bytes per network interface
Network	TX by interface (Bytes)	Transmitted bytes per network interface
Network	RX by interface (PPS)	Packets per second received
Network	TX by interface (PPS)	Packets per second transmitted

View instance logs

PostgreSQL logs can be viewed through the Log Explorer in KakaoCloud’s monitoring service.

1. Go to the KakaoCloud Console > Monitoring.
2. Click the Explorer tab and select PostgreSQL from the Log Explorer.
3. Check the query period and enter your log filter. File path filtering is not supported.
4. After setting search criteria, logs and charts will display results.

info

For more on log explorer, see Log Explorer.

Restart PostgreSQL

You can restart PostgreSQL for a running instance.

• You cannot restart PostgreSQL if the instance status is Pending, Starting, or Terminating.
• Restarting the primary may cause a brief downtime.

1. Go to the KakaoCloud Console > Data Store > PostgreSQL.
2. Select the instance group of the PostgreSQL instance to restart.
3. Go to the Instance tab.
4. Click [More options] for the instance to restart and select Restart PostgreSQL.
5. Review details in the popup and click [Confirm].