Kingbase DB監視

概要

Applications ManagerのKingbase DB監視を導入することで、Kingbase DB環境の信頼性、パフォーマンス、そしてセキュリティを確保することが可能です。

新規監視追加

Kingbase DB監視の前提条件： こちら

REST APIを使用した、Kingbase DB監視の新規作成方法： こちら

以下の手順でKingbase DB監視を作成します。

  1. ［新規監視］→［新規監視の追加］をクリック
  2. データベースサーバーカテゴリの［Kingbase DB］を選択
  3. Kingbase DBの［表示名］を指定
  4. Kingbase DBが実行されているホストの［ホスト名/IPアドレス］を入力
  5. Kingbase DBが実行されている［ポート］を入力（デフォルトは54321）
  6. 認証情報の詳細を指定
    ［ユーザー名］と［パスワード］に管理者ユーザーの資格情報を入力してください。
    または、［認証情報リストから選択］を有効にし、認証情報マネージャーに事前に登録した認証情報を選択してください。
  7. Kingbase DBでSSL認証が有効になっている場合、［SSL有効］のチェックボックスをオン
  8. ポーリング間隔を分単位で指定（デフォルトは5分）
  9. Kingbase DB監視を関連付ける監視グループを検索欄のドロップダウンから選択（任意項目）
    監視は複数のグループに関連付けることができます。
  10. ［監視の追加］をクリック
    ネットワークからKingbase DBが検出され、監視が開始されます。

監視対象パラメーター

  • ［可用性］タブ：最新24時間か30日の可用性履歴がわかります。
  • ［パフォーマンス］タブ：最新24時間か30日のステータスとイベントを確認可能です。
  • ［リストビュー］タブ：一括管理設定を実行できます。

Kingbase DB監視で対応するタブで監視できるメトリクスのリストは次のとおりです。

概要

パラメーター 説明
CONNECTION TIME
Connection Time Time interval for connecting the DB connection.
CONNECTION STATISTICS
Active Connections Number of currently active connections to the database.
Total Users The total number of users active at the time of data collection.
CONNECTIONS USED
Connections Used The total number of connections used at the time of data collection.
LOCK STATISTICS
Locks Held Number of locks held by the indicated session.
Locks Wait Number of locks waiting in the database.
BUFFER STATISTICS
Buffer Hits/min Total buffer hits (i.e., block read requests avoided by finding the block already in buffer cache) per minute.
Block Reads/Min Total disk blocks read per minute.
Cache Hit Ratio The current ratio of buffer cache hits to total requests.
DISK USAGE DETAILS
Disk Usage Size of the on-disk representation of all tables in the database in MB.
Index usage Size of the on-disk representation of all indexes in the database in MB.
INDEX SCAN DETAILS
Index scans/min Total number of index scans initiated per minute.
Index Reads/min Total number of index entries returned by index scans per minute.
Index Fetches/min Total number of live table rows fetched by simple index scans per minute.
QUERY STATISTICS
Row Inserts/min Total number of rows inserted per minute.
Row Updates/min Total number of rows updated per minute.
Row Deletes/min Total number of rows deleted per minute.
TRANSACTION DETAILS
Total Commits Total number of transactions committed.
Total Rollbacks Total number of transactions rolled back.
Commits/Min Total number of transactions committed per minute.
Rollbacks/Min Total number of transactions rolled back per minute.
TABLE LEVEL SCAN DETAILS
Sequential Scans/min Total number of sequential scans per minute.
Table Index Scans/min Total number of index scans per minute.
Sequential Scan Rows Read/min Total number of rows returned by sequential scans per minute.
Table Index Scan Rows Read/min Total numbers of rows returned by index scans per minute.

パフォーマンス

パラメーター 説明
Top 10 Queries by CPU
Database Name The database name under which the query has been executed.
Total CPU Time(ms) The cumulative total amount of CPU time that has been spent in running the query (in millisecond).
Max CPU Time(ms) The maximum amount of time that was taken by the CPU to run the query (in millisecond).
Average CPU Time(ms) The average CPU time taken to execute the query (in millisecond).
Query The SQL query which consumed the maximum CPU time.
Long Running Query Details
Process ID The identifier for the process caused by the query.
Runtime Amount of time for which the query has been running (in minutes).
User Name Name of the user executing the query.
Query The SQL query that was running.
Database Name The database name under which the query has been running.
Top 50 Table Row Details
Table Name Name of the table.
No. of Rows Number of rows available in the table.
Table Size Size of the table (in MB).
Used Size(MB) Size of the used space(in MB).
Free Size(MB) Size of the free space (in MB).
Used Size(%) Size of the used space in percentage.
Free Size(%) Size of the free space in percentage.
Top 10 Table By Dead Tuples Percentage
Schema Name The name of the schema where the table resides.
Table Name The name of the table.
Data Length(MB) The total size of the table's data (in MB).
Index Length(MB) The size of the table's indexes (in MB).
Live Tuples Number of live tuples (rows) in the table.
Dead Tuples Number of dead tuples (rows that have been marked for deletion but not yet vacuumed).
Dead Tuple Percentage(%) Percentage of Dead Tuples.
Days Since Last Vacuum Days passed since the last VACUUM operation performed on the table.
Last Vacuum Timestamp of the last VACUUM operation performed on the table.
Days Since Last Auto Vacuum Days passed since the last automatic VACUUM operation performed on the table.
Last Auto Vacuum Timestamp of the last automatic VACUUM operation performed on the table.

データベース

パラメーター 説明
DATABASE DETAILS
Database Name Name of the database instance.
DB Size Size of the database instance (in MB).
Connections Number of connections for the database instance.
TableSpace Name of the tablespace.
TABLESPACE DETAILS
Name Name of the tablespace.
Owner Owner who created the tablespace.
Location Location where the tablespace is created.
Size Current size of the tablespace (in MB).

セッション

パラメーター 説明
SESSION DETAILS
Process ID Displays the process ID of the session running in the Kingbase server.
Client Address IP address of the client connected to the server.
Application Name The name of the application that has established the session.
Database Name Displays the name of the database currently being used by the process.
User The login name of the user executing the process.
State The state of the process in the Kingbase server.
Blocked Indicates whether the process is blocked or is currently waiting on lock.
Wait Event Displays the Wait Event Name and Wait Event Type that is currently waiting.
Query The SQL query that was last executed in the process.
CPU Time(ms) The cumulative CPU time taken for the process running in the Kingbase server (in millisecond).
USER PROFILE DETAILS
User ID Unique OID of the user.
User Name Username of the user.
Role Name Privilege assigned to the user.
Super User User has Super user privilege or not. Possible values: True/ False.
CreateDB Allowed User has the privilege to create the DB. Possible values: True/ False.
Replication User User has is Replication User previlege or not. Possible values: True/ False.
Expired Days Number of days until the password expiry.
Expired Time Expire time of the Password

ロック

パラメーター 説明
Locked Table Details
Process ID The unique ID of the process.
Table Name Name of the table.
Lock Type The type of lock held. Possible Values: relation/ tuple/ page/ extend/ access share/ row share/ row exclusive etc..
Page Page number within the table's data file.
Virtual Transaction Represents the identifier for the virtual transaction holding the lock.
Mode Lock mode indicates the specific type and level of lock held.
Granted Access Boolean value (true or false) indicating whether the lock has been granted (true) or is waiting (false).
Blocked Session Details
Process ID Process ID (PID) of the session that is currently blocked.
User Name Username of the session that is blocked (blocked_pid).
Blocked Session by Process ID Array of PIDs of sessions that are blocking the session identified by PID.
Blocked Query Current query being executed by the session that is blocked.

レプリケーション

パラメーター Available Versions 説明
SLAVE DETAILS
Client Address >=9.2 Address of client/standby server address.
PID >=9.2 Process ID of a WAL sender process.
application name >=9.2 Name of the application that is connected to this WAL sender.
Client Port >=9.2 TCP port number that the client is using for communication with this WAL sender.
Sender State >=9.2 Current WAL sender state. Possible values are:
  • startup: This WAL sender is starting up.
  • catchup: This WAL sender's connected standby is catching up with the primary.
  • streaming: This WAL sender is streaming changes after its connected standby server has caught up with the primary.
  • backup: This WAL sender is sending a backup. stopping: This WAL sender is stopping.
Sync State >=9.2 Synchronous state of this standby server. Possible values are:
  • async: This standby server is asynchronous.
  • potential: This standby server is now asynchronous, but can potentially become synchronous if one of the current synchronous ones fails.
  • sync: This standby server is synchronous.
  • quorum: This standby server is considered as a candidate for quorum standbys.
Sending lag(KB) >=9.2 Lag in sending the transactions to standby
Receiving lag(KB) >=9.2 Lag in receiving the transactions on standby
Replaying lag >=9.2 Lag in replaying the transactions on standby
Total delay >=9.2 Total delay sending from master to replaying transaction on standby.
Replication delay >=9.2 Total delay in replicating the transactions on standby.
REPLICATION SLOTS
slot_name >=9.6 A unique, cluster-wide identifier for the replication slot.
slot_type >=9.6 The slot type - physical or logical.
active >=9.6 True if this slot is currently actively being used.
restart_lsn >=9.6 The address (LSN) of oldest WAL which still might be required by the consumer of this slot and thus won't be automatically removed during checkpoints.
confirmed_flush_lsn >=9.6 The address (LSN) up to which the logical slot's consumer has confirmed receiving data. Data older than this is not available anymore. NULL for physical slots.

構成

パラメーター 説明
Version Version of the Kingbase Server.
Config File Location of Kingbase server configuration file.
Data Directory Location of data directory used by the Kingbase server.
External PID File Location of external PID file.
hba File Location of hba file.
ident File Location of ident file.
Maximum Connections The maximum number of connections in the Kingbase Server.