Kingbase is a comprehensive database management system designed to meet the needs of enterprise-level applications. Monitoring your Kingbase database is crucial for maintaining database performance, ensuring security, and preventing downtime. By implementing Applications Manager's Kingbase DB monitoring tool, you can ensure the reliability, performance, and security of your Kingbase DB environment.
Prerequisites for monitoring Kingbase database metrics: Click here
Using the REST API to add a new Kingbase database monitor: Click here
To create a Kingbase database monitor, follow the steps given below:
Click on the individual monitors listed to view the following information. Following are the list of metrics that are monitored in Kingbase database monitoring:
| Parameters | Description |
|---|---|
| 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. |
| Parameter | Description |
|---|---|
| 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. |
| Parameter | Description |
|---|---|
| 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). |
| Parameter | Description |
|---|---|
| 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 |
| Parameter | Description |
|---|---|
| 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. |
| Parameter | Available Versions | Description |
|---|---|---|
| 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:
|
| Sync State | >=9.2 | Synchronous state of this standby server. Possible values are:
|
| 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. |
| Parameter | Description |
|---|---|
| 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. |
