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. Select 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	Select to refresh the monitoring graph

Monitoring metrics

Category	Monitoring data	Description
PostgreSQL	Connection (Count)	Number of PostgreSQL connections
PostgreSQL	Connections (Count)	Number of active PostgreSQL connections
PostgreSQL	Lock sessions (Count)	Number of PostgreSQL lock sessions
PostgreSQL	Deadlock (Count)	Number of PostgreSQL deadlocks
PostgreSQL	Active transactions (Count)	Number of active PostgreSQL transactions
PostgreSQL	Replication lag (sec)	PostgreSQL replication delay time
PostgreSQL	Buffer hit ratio (%)	PostgreSQL buffer hit ratio
PostgreSQL	Vacuum xid	PostgreSQL vacuum xid measured per database
PostgreSQL	Temporary file usage per DB (%)	PostgreSQL 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 file system usage over time
FileSystem	Total usage (Bytes)	Total file system usage over time
FileSystem	inode usage per mount (%)	inode usage per file system mount over time
Disk	Read Bytes (Bytes/sec)	Disk I/O read usage over time
Disk	Write Bytes (Bytes/sec)	Disk I/O write usage over time
Disk	Read IOPS (IO/sec)	Disk I/O read usage over time
Disk	Write IOPS (IO/sec)	Disk I/O write usage over time
Disk	Available disk capacity (Bytes)	Remaining available capacity of data and log storage
Disk	Total disk capacity (Bytes)	Total capacity of data and log storage
Disk	Available inodes on disk (Count)	Number of available inodes in data and log storage
Disk	Total reserved inodes on disk (Count)	Number of reserved inodes in data and log storage
Disk	Disk inode usage (Count)	Number of inodes in use in data and log storage
Network	RX by interface (Bytes)	Network RX usage over time
Network	TX by interface (Bytes)	Network TX usage over time
Network	RX by interface (PPS)	Network RX usage over time
Network	TX by interface (PPS)	Network TX usage over time

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. Select 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.

• If the instance status is Pending, Starting, Terminating, or Storage-Full (Instance storage error), it cannot be restarted.
• If the Primary instance is restarted, a momentary disconnection may occur.

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. Select [More options] for the instance to restart and select Restart PostgreSQL.
5. Review details in the popup and select [OK].