User-defined Metrics

AbnormalJob

Abnormal Job Monitoring Statistics

ctime

Timestamp

Collection time

virtual_cluster_id

Integer

Virtual cluster ID

query_id

String

Query ID.

statement

String

Statement executed for exception handling

block_time

Long

Block time before the statement is executed

elapsed_time

Long

Elapsed time when the statement is executed

total_cpu_time

Long

Total time used by the CPU on the DN when the statement is executed for exception handling

cpu_skew_percent

Integer

CPU usage skew on the DN when the statement is executed for exception handling

control_group

String

cgroups used for exception handling during statement execution

status

String

Status of a statement after exception handling

action

String

Exception handling action executed by the statement

abort_info

String

Reason why the statement is processed abnormally

AgentStatus

DMS Cluster Agent Status Statistics

ctime

Timestamp

Collection time

virtual_cluster_id

Integer

Virtual cluster ID

host_id

Integer

ID of the node where data is collected and reported.

is_ccn

Boolean

Whether the node is a CCN node

agent_version

String

Specifies the agent version that matches the DMS version

agent_pid_exist

Boolean

Whether the pID file exists

agent_start_time

String

Agent startup time

agent_run_time

String

Agent running time

agent_sub_thread

Integer

Agent subthread

config_plugin_count

Integer

Number of configured plugins

active_plugin_count

Integer

Number of enabled plugins

config_custom_plugin_count

Integer

Number of customized plug-ins

active_custom_plugin_count

Integer

Number of enabled customized plug-ins

agent_cpu_consume

Float

Agent CPU usage

agent_mem_consume

Float

Agentmem usage percentage

workplace_dir_time

String

Time when the workplace directory is updated

config_dir_time

String

Time when the config directory is updated

log_file_time

String

Time when the log file is updated

perflog_file_time

String

perflog file update time

timestamp_yaml_detail

String

TOPSQL timestamp

status_log_detail

String

Status record details

ClusterHostStatus

Node Status Statistics

ctime

Timestamp

Collection time

virtual_cluster_id

Integer

Virtual cluster ID

host_id

Integer

ID of the node where data is collected and reported

host_name

String

Host name

host_stat

String

Host status

ClusterInstStatus

Instances by Status

ctime

Timestamp

Collection time

virtual_cluster_id

Integer

Virtual cluster ID

host_id

Integer

ID of the node where data is collected and reported

host_name

String

Host name

inst_id

Integer

Instance ID

inst_type

String

Instance type

inst_role

String

Instance role

inst_stat

String

Instance status

inst_stat_reason

String

Instance status cause

ClusterSlowInst

Slow Instance Statistics

ctime

Timestamp

Collection time

virtual_cluster_id

Integer

Virtual cluster ID

check_time

Long

Detection time

host_id

Integer

ID of the node where data is collected and reported

host_name

String

Host name

inst_id

String

Instance ID

inst_name

String

Instance name

ClusterStatus

Cluster Status

ctime

Timestamp

Collection time

virtual_cluster_id

Integer

Virtual cluster ID

host_id

Integer

ID of the node where data is collected and reported

cluster_state

String

Cluster status

balanced

String

Whether a primary/standby switchover has been performed

redistributing

String

Whether redistribution has occurred

cluster_read_only

String

Whether the current cluster is read-only

ClusterStartTime

Startup time of each instance in the cluster

ctime

Timestamp

Collection time

virtual_cluster_id

Integer

Virtual cluster ID

host_id

Integer

ID of the node where data is collected and reported

instance

String

Name of the instance to be collected

starttime

Timestamptz

Instance start time.

CpuStat

CPU Usage

ctime

Timestamp

Collection time

virtual_cluster_id

Integer

Virtual cluster ID

host_id

String

ID of the node where data is collected and reported

cpu_name

String

The default status is ALL.

usr

Float

User-mode CPU time %

nice

Float

CPU time the process with a negative nice value (%)

sys

Float

Kernel mode time (%)

iowait

Float

I/O waiting time %

irq

Float

Hard interruption time (%)

soft

Float

Software interrupt time (%)

steal

Float

Time spent by the virtual CPU in involuntary waiting when the virtual machine manager serves another virtual processor (%)

guest

Float

Time spent running the virtual processor (%)

idle

Float

Idle time except for disk waiting operations (%)

ht_possible

Boolean

Hyper-threading capability

ht_enabled

Boolean

Whether hyper-threading is enabled

run_count

Long

Number of processes in the runnable status

blocked_count

Long

Number of processes waiting for I/O completion

DbActiveStats

Active Sessions

ctime

Timestamp

Collection time

virtual_cluster_id

Integer

Virtual cluster ID

db_name

String

Database name

inst_name

String

Instance name, which indicates the CN from which the current value is obtained.

total_sessions_count

Integer

Number of all user sessions

user_count

Integer

Distinct username

application_count

Integer

distinct application name

active_queries

Integer

Number of queries in the active or fastpathfunctioncall state.

DbSize

Disk Capacity Statistics

ctime

Timestamp

Collection time

virtual_cluster_id

Integer

Virtual cluster ID

inst_name

String

Instance name, which indicates the CN from which the current value is obtained.

db_name

String

Database name

db_size

Long

TSField

DbStats

Transaction Status.

ctime

Timestamp

Collection time

virtual_cluster_id

Integer

Virtual cluster ID

db_name

String

Database name

inst_name

String

Instance name, which indicates the CN from which the current value is obtained.

tup_returned

Long

Number of rows returned through a global database scan

tup_fetched

Long

Number of rows returned by querying indexes in the database

tup_inserted

Long

Number of rows inserted by queries in this database

tup_updated

Long

Number of rows updated by queries in this database

tup_deleted

Long

Number of rows deleted by queries in this database

xact_commit

Long

Number of transactions in this database that have been committed

xact_rollback

Long

Number of transactions in this database that have been rolled back

deadlocks

Long

Number of deadlocks detected in this database

blks_read

Long

Number of disk blocks read in this database

blks_hit

Long

Number of disk blocks that have been found in the cache. In this case, the read is unnecessary. (This includes only the postgresql buffer cache and does not include the file system cache of the operating system.)

blk_read_time

Double

Time spent reading data file blocks by backends in this database, in milliseconds

blk_write_time

Double

Time spent writing data file blocks by backends in this database, in milliseconds

conflicts

Long

Number of queries canceled due to conflicts (The conflict occurs only on the standby server.)

temp_files

Long

Number of temporary files created by queries in this database. All temporary files (such as sorting or hashing) are calculated regardless of the log_temp_files setting.

temp_bytes

Long

Total amount of data written to temporary files by queries in this database. All temporary files are calculated regardless of the log_temp_files setting.

db_size

Long

Database capacity (Unit: Byte)

delta_tup_returned

Long

Number of rows returned by global database scanning in a unit time

delta_tup_fetched

Long

Number of rows returned by querying indexes in the database in a unit time.

delta_tup_inserted

Long

Number of rows inserted through database query in a unit time

delta_tup_updated

Long

Number of rows updated through database query in unit time

delta_tup_deleted

Long

Number of rows deleted by querying the database in a unit time

delta_xact_commit

Long

Number of transactions that have been submitted in the database per unit time

delta_xact_rollback

Long

Number of transactions that have been rolled back in the database per unit time

delta_deadlocks

Long

Number of deadlocks retrieved in the database per unit time.

FileSystemInodeStat

File Handle

ctime

Timestamp

Collection time

virtual_cluster_id

Integer

Virtual cluster ID

host_id

Integer

ID of the node where data is collected and reported

file_system_name

String

Name of the disk file system

total

Long

Total inode capacity (KB)

used

Long

Used capacity (KB)

FileSystemStat

Node Disk Usage

ctime

Timestamp

Collection time

virtual_cluster_id

Integer

Virtual cluster ID

host_id

Integer

ID of the node where data is collected and reported

disk_fs_name

String

Name of the disk file system

total

Long

Total space (KB)

used

Long

Used capacity (KB)

available

Long

Available capacity (KB)

used_percentage

Float

Disk usage

IOStat

Node Disk I/O Statistics

ctime

Timestamp

Collection time

virtual_cluster_id

Integer

Virtual cluster ID

host_id

Integer

ID of the node where data is collected and reported

disk_name

String

Disk name (devicename)

tps

Float

Number of transmissions per second (transferpersecond). The size of each transmission is unknown.

kb_read_s

Float

Amount of data read from the device per second (KB)

kb_wrtn_s

Float

Amount of data written to the device per second (KB)

kb_read

Float

Total amount of read data (KB)

kb_wrtn

Float

Total amount of written data (KB)

rrqm_s

Float

Number of times that read requests to the device are combined per second

wrqm_s

Float

Number of times that write requests to the device are combined per second

r_s

Float

Number of completed reads per second

w_s

Float

Number of completed writes per second

rkb_s

Float

Amount of data read per second (KB)

wkb_s

Float

Amount of data written per second (KB)

avgrq_sz

Float

Average data volume of each I/O operation (unit: sector)

avgqu_sz

Float

Average request queue length

await

Float

Average waiting time of each I/O request (unit: ms)

svctm

Float

Average processing time of each I/O request (unit: ms)

util

Float

Percentage of the time when the I/O queue is not empty, calculated by I/O processing time divided by the total time in the statistical period.

InstanceMemory

Instance Memory Monitoring Statistics

ctime

Timestamp

Collection time

virtual_cluster_id

Integer

Virtual cluster ID

host_id

Integer

ID of the node where data is collected and reported

inst_name

String

Instance name

max_process_memory

Float

Memory size occupied by the instance

process_used_memory

Float

Memory size used by a process

max_dynamic_memory

Float

Maximum dynamic memory

dynamic_used_memory

Float

Used dynamic memory

dynamic_peak_memory

Float

Dynamic peak memory

dynamic_used_shrctx

Float

Maximum dynamic shared memory context

dynamic_peak_shrctx

Float

Dynamic peak value of the shared memory context

max_shared_memory

Float

Maximum shared memory

shared_used_memory

Float

Used shared memory

max_cstore_memory

Float

Maximum memory allowed by column store

cstore_used_memory

Float

Memory used in column store

max_comm_memory

Float

Maximum memory that can be used by the communication library

comm_used_memory

Float

Used memory size of the communication library

comm_peak_memory

Float

Peak memory usage of the communication library

max_topsql_memory

Float

Maximum memory that can be used by top SQLs to record historical job monitoring information

topsql_peak_memory

Float

Peak memory usage of the top SQL that records historical job monitoring information

topsql_used_memory

Float

Memory used by top SQLs to record historical job monitoring information

other_used_memory

Float

Other used memory

pooler_conn_memory

Float

Memory size occupied by pooler connections

pooler_freeconn_memory

Float

Memory size occupied by pooler idle connections

storage_compress_memory

Float

Memory size used by column-store compression and decompression

udf_reserved_memory

Float

Memory reserved for the UDFWorker process

mmap_used_memory

Float

Memory size used by mmap

InstanceResources

Instance Resource Statistics

ctime

Timestamp

Collection time

virtual_cluster_id

Integer

Virtual cluster ID

host_id

Integer

ID of the node where data is collected and reported

inst_name

String

Instance name

inst_cpu

Float

Read the value (CPU usage %) in postmaster.pID/cm_server.pID/gtm.pID/etcd.pID.

inst_mem

Float

Read the value (memory usage %) in postmaster.pID/cm_server.pID/gtm.pID/etcd.pID.

InstanceSize

Instance Disk Size Statistics

ctime

Timestamp

Collection time

virtual_cluster_id

Integer

Virtual cluster ID

host_id

Integer

ID of the node where data is collected and reported

inst_name

String

Instance name

inst_path

String

Storage location

inst_size

Long

Disk space used by all databases on the current instance

MemStat

Node Memory Statistics

ctime

Timestamp

Collection time

virtual_cluster_id

Integer

Virtual cluster ID

host_id

Integer

ID of the node where data is collected and reported

mem_total

Long

Size of all available RAMs, that is, the remaining physical memory minus the reserved bits and kernel usage (KB)

mem_free

Long

Unused memory in the system. The value is lowfree+highfree (KB).

buffers

Long

Size of the cache used for the block device (KB)

cached

Long

Size of the file buffer (KB)

swap_total

Long

Total swap space (unit: KB)

swap_free

Long

Size of the RAM memory temporarily stored in the swap file (KB)

hardware_corrupted

Long

Memory size of the virus-infected page (KB)

NetIfStat

Network Status Statistics

ctime

Timestamp

Collection time

virtual_cluster_id

Integer

Virtual cluster ID

host_id

Integer

ID of the node where data is collected and reported

interface_name

String

NIC name

up

Boolean

NIC status (up/down)

speed

Long

NIC speed (1000 Mbit/s or 100 Mbit/s)

recv_bytes

Long

Total data received by the NIC (unit: byte)

recv_packets

Long

Number of packets received by the NIC

recv_errors

Long

Total number of NIC receiving errors

recv_drop

Long

Number of received data packets that are dropped by the NIC

recv_fifo

Long

Number of FIFO buffer errors during reception

recv_frame

Long

Number of received packet frame errors

recv_compressed

Long

Number of received compressed data packets

recv_multicast

Long

Number of received multicast frames

send_bytes

Long

Total data sent by the network adapter (unit: byte)

send_packets

Long

Total number of packets sent by the NIC

send_errors

Long

Total number of NIC sending errors

send_drop

Long

Total number of data packets discarded by the NIC during transmission

send_fifo

Long

Number of FIFO buffer errors during sending

send_collisions

Long

Number of collisions detected on the sending interface

send_carrier

Long

Number of carrier losses detected by the device driver during transmission

send_compressed

Long

Number of sent compressed data packets

multi_q_possible

Boolean

Specifies whether NIC multi-queue is supported.

multi_q_enabled

Boolean

NIC multi-queue is enabled.

multi_q_smp_affinity

String

Specifies the CPU affinity of a multi-queue NIC.

duplex

String

Indicates whether the NIC works in duplex mode.

io_rate

Double

Network speed

NodeSqlCount

Node SQL Statistics

ctime

Timestamp

Collection time

virtual_cluster_id

Integer

Virtual cluster ID

node_name

String

Node name

user_name

String

User name

select_count

Long

Number of SELECT statements

update_count

Long

Number of UPDATE statements

insert_count

Long

Number of INSERT statements

delete_count

Long

Number of DELETE statements

mergeinto_count

Long

Number of MERGEINTO statements

ddl_count

Long

Number of DDL statements

dml_count

Long

Number of DML statements

dcl_count

Long

Number of DCL statements

total_select_elapse

Long

Total response time of SELECT statements

avg_select_elapse

Long

Average response time of SELECT statements

max_select_elapse

Long

Maximum response time of SELECT statements

min_select_elapse

Long

Minimum response time of SELECT statements

total_update_elapse

Long

Total response time of UPDATE statements

avg_update_elapse

Long

Maximum response time of UPDATE statements

max_update_elapse

Long

Minimum response time of UPDATE statements

min_update_elapse

Long

Minimum response time of UPDATE statements

total_delete_elapse

Long

Total response time of DELETE statements

avg_delete_elapse

Long

Average response time of DELETE statements

max_delete_elapse

Long

Maximum response time of DELETE statements

min_delete_elapse

Long

Minimum response time of DELETE statements

total_insert_elapse

Long

Total response time of INSERT statements

avg_insert_elapse

Long

Average response time of INSERT statements

max_insert_elapse

Long

Maximum response time of INSERT statements

min_insert_elapse

Long

Minimum response time of INSERT statements

delta_select_count

Long

Difference between the numbers of SELECT statements at two time points

delta_update_count

Long

Difference between the numbers of UPDATE statements at two time points

delta_insert_count

Long

Difference between the numbers of INSERT statements at two time points

delta_delete_count

Long

Difference between the numbers of DELETE statements at two time points

delta_mergeinto_count

Long

Difference between the numbers of MERGE INTO statements at two time points

delta_ddl_count

Long

Difference between the numbers of DDL statements at two time points

delta_dml_count

Long

Difference between the numbers of DML statements at two time points

delta_dcl_count

Long

Difference between the numbers of DCL statements at two time points

delta_total_select_elapse

Long

Difference between the total SELECT response time at two time points

delta_avg_select_elapse

Long

Difference between the average SELECT response time at two time points

delta_max_select_elapse

Long

Difference between the maximum SELECT response time at two time points

delta_min_select_elapse

Long

Difference between the minimum SELECT response time at two time points

delta_total_update_elapse

Long

Difference between the total UPDATE response time at two time points

delta_avg_update_elapse

Long

Difference between the maximum UPDATE response time at two time points

delta_max_update_elapse

Long

Difference between the minimum UPDATE response time at two time points

delta_min_update_elapse

Long

Difference between the minimum UPDATE response time at two time points

delta_total_delete_elapse

Long

Difference between the total DELETE response time at two time points

delta_avg_delete_elapse

Long

Difference between the average DELETE response time at two time points

delta_max_delete_elapse

Long

Difference between the maximum DELETE response time difference at two time points

delta_min_delete_elapse

Long

Difference between the minimum DELETE response time difference at two time points

delta_total_insert_elapse

Long

Difference between the total INSERT response time at two time points

delta_avg_insert_elapse

Long

Difference between the average INSERT response time at two time points

delta_max_insert_elapse

Long

Difference between the maximum INSERT response time at two time points

delta_min_insert_elapse

Long

Difference between the minimum INSERT response time at two time points

OsStat

System Status Statistics

ctime

Timestamp

Collection time

virtual_cluster_id

Integer

Virtual cluster ID

host_id

Integer

ID of the node where data is collected and reported

tcp_resend_rate

Float

TCP protocol stack retransmission rate (%)

SchemaUsage

Schema Usage Statistics

ctime

Timestamp

Collection time

virtual_cluster_id

Integer

Virtual cluster ID

host_id

Integer

ID of the node where data is collected and reported

db_name

String

Database name

schema_name

String

Schema name

used_space

Long

Used capacity (Byte)

perm_space

Long

Total capacity (Byte)

SessionStats

Session Statistics

ctime

Timestamp

Collection time

virtual_cluster_id

Integer

Virtual cluster ID

db_name

String

Database name

inst_name

String

Instance name, which indicates the CN from which the current value is obtained.

pid

String

Thread ID (It can be used as a session ID or a connection ID.)

user_name

String

Database username

application_name

String

User application name

client_address

String

Client address

client_hostname

String

Host name of the client

client_port

String

TCP port number used by the client to communicate with the background. If the Unix socket is used, the value is -1.

backend_start

Long

Time when this process was started, that is, when the client connected to the server

elapsed_time

Long

Execution time so far

curr_xact_start

Long

Time when the current transaction was started (NULL if no transactions are active). If the current query is the first of its transaction, the value of this column is the same as that of the query_start column.

state_change

Long

Time when the status was changed in the previous time.

waiting

Boolean

Whether the backend is currently waiting on a lock. If yes, the value is true.

state

String

Current overall state of this backend

resource_pool

String

Resource pool used by the user

query_elapsed_time

Long

Actual execution duration of the statement (s).

query_id

String

ID of a query statement

query_start

Long

Time when a statement starts to be executed

control_group

String

cgroups currently used by the statement.

lock_type

String

Lock type

lock_mode

String

Lock mode

lock_granted

Boolean

Indicates whether to hold a lock when lock waiting exists. The value is true.

lock_relname

String

Resource that is waiting for the lock

stmt_type

String

Statement type

query

String

Query SQL

system_query

Boolean

Indicates whether the query is performed by the system.

query_band

String

Query plan

TableDirtyPageRate

Table Dirty Page Rate Statistics

ctime

Timestamp

Collection time

virtual_cluster_id

Integer

Virtual cluster ID

db_name

String

Database name

schema_name

String

Schema name

table_name

String

Table name (full name)

table_owner

String

Table owner

table_size

Long

Table Size (Bytes)

dirty_page_rate

Double

Dirty page rate

TableColdHotData

Statistics on hot and cold data sizes of hot and cold tables

ctime

Timestamp

Collection time

virtual_cluster_id

Integer

Virtual cluster ID

table_name

String

Table name

db_name

String

Database name

hot_data_size

String

Size of hot data

cold_data_size

String

Size of cold data

TableSkewRate

Table Skew Monitoring Statistics

ctime

Timestamp

Collection time

virtual_cluster_id

Integer

Virtual cluster ID

db_name

String

Database name

schema_name

String

Schema name

table_name

String

Table name (full name)

table_owner

String

Table owner

table_size

Long

Table size (Bytes)

skew_rate

Double

Skew rate

WorkloadQueue

Resource Pool Statistics

ctime

Timestamp

Collection time

virtual_cluster_id

Integer

Virtual cluster ID

respool_name

String

Resource pool name

cpu_quota

Integer

CPU quota of the resource pool

mem_quota

Integer

Memory quota of the resource pool

disk_quota

Long

Disk quota of the resource pool

max_simple_query

Integer

Maximum number of concurrent simple jobs allowed by the resource pool

max_complicated_query

Integer

Maximum number of concurrent queries allowed by the resource pool

cpu_usage

Double

CPU usage of the resource pool

mem_usage

Double

Memory usage of the resource pool

disk_usage

Double

Disk usage of the resource pool

simple_query

Integer

Number of concurrent simple jobs in the resource pool

complicated_query

Integer

Current number of concurrent requests in the resource pool

business_complicated_simple_sql

SQL Statements by Attributes

ctime

Timestamp

Collection time

virtual_cluster_id

Integer

Virtual cluster ID

host_id

Integer

ID of the node where data is collected and reported

attribute

String

SQL attribute

count

Integer

Number of SQL statements

business_concurrency

Service Concurrency

ctime

Timestamp

Collection time

virtual_cluster_id

Integer

Virtual cluster ID

host_id

Integer

ID of the node where data is collected and reported.

user_name

String

Username

coorname

String

CN name

state

String

Status

count

Integer

Quantity

business_DN_thread_wait

DN Waiting Status

ctime

Timestamp

Collection time

virtual_cluster_id

Integer

Virtual cluster ID

host_id

Integer

ID of the node where data is collected and reported

node_name

String

Node name

count

Integer

Quantity

business_enqueue

Service Queuing Status

ctime

Timestamp

Collection time

virtual_cluster_id

Integer

Virtual cluster ID

host_id

Integer

ID of the node where data is collected and reported

user_name

String

Username

respool

String

Resource pool name

queue

String

Queue name

count

Integer

Quantity

business_hudi_sync_state

Time when the hudi synchronization task is submitted.

ctime

Timestamp

Collection time

virtual_cluster_id

Integer

Virtual cluster ID

host_id

Integer

ID of the node where data is collected and reported

task_id

String

Task ID

latest_sync_end

Timestamp

Last synchronized data

latest_commit

String

Last submitted information

latest_sync_count

Long

Number of last synchronized records

business_hudi_sync_state_log

Hudi synchronization task submission log

ctime

Timestamp

Collection time

virtual_cluster_id

Integer

Virtual cluster ID

host_id

Integer

ID of the node where data is collected and reported

task_id

String

Task ID

last_log

String

Last task log

business_obs_latency

OBS bucket access latency

ctime

Timestamp

Collection time

virtual_cluster_id

Integer

Virtual cluster ID

host_id

Integer

ID of the node where data is collected and reported

node_name

String

Node name

latency_ms

Float

Average delay of OBS during the 10 minutes before logtime. The unit is ms.

req_count

Long

Number of OBS requests during the 10 minutes before logtime.

log_time

Timestamp

Time when the delay information is recorded.

business_obs_read_traffic

OBS bucket read traffic

ctime

Timestamp

Collection time

virtual_cluster_id

Integer

Virtual cluster ID

host_id

Integer

ID of the node where data is collected and reported

node_name

String

Node name

traffic_mb

Float

OBS read traffic statistics during the 10 minutes before logtime

bandwidth_mb_per_s

Float

Average bandwidth (MB/s)

req_count

Long

Number of OBS reads during the 10 minutes before logtime

log_time

Timestamp

Time when statistics are recorded

business_obs_write_traffic

OBS bucket write traffic

ctime

Timestamp

Collection time

virtual_cluster_id

Integer

Virtual cluster ID

host_id

Integer

ID of the node where data is collected and reported

node_name

String

Node name

traffic_mb

Float

OBS write traffic statistics during the 10 minutes before logtime

bandwidth_mb_per_s

Float

Average bandwidth (MB/s)

req_count

Long

Number of OBS writes during the 10 minutes before logtime

log_time

Timestamp

Time when statistics are recorded

business_query_monitor

Real-Time Service Statements

ctime

Timestamp

Collection time

virtual_cluster_id

Integer

Virtual cluster ID

host_id

Integer

ID of the node where data is collected and reported

db_name

String

Database name

coorname

String

CN name

pid

Long

Thread ID

query_id

Long

Query ID

query_band

String

Query job type

user_name

String

Username

application_name

String

Application name

client_address

String

Client IP address

client_hostname

String

Host name of the client

client_port

Integer

TCP port number used by a client to communicate with the backend

waiting

String

If backend is currently waiting for a lock, the value is true.

q_running

Long

Execution duration

wlm_start

Long

Time when a statement starts to be executed

block_time

Long

Block time before the statement is executed (ms).

duration

Long

Duration that a statement has been executed (ms)

enqueue

String

Resource status in workload management

resource_pool

String

Resource pool used by the user

control_group

String

Cgroup used by the statement

max_peak_memory

Integer

Maximum memory peak of a statement across all DNs (MB).

average_peak_memory

Integer

Average memory usage during statement execution (MB).

memory_skew_percent

Integer

Memory usage skew of a statement among DNs.

estimate_memory

Integer

Estimated memory used by the statement (MB).

spill_info

String

Statement spill information on all DNs

max_spill_size

Integer

Maximum spilled data among all DNs when a spill occurs. The unit is MB. The default value is 0.

average_spill_size

Integer

Average spilled data among all DNs when a spill occurs. The unit is MB. The default value is 0.

spill_skew_percent

Integer

DN spill skew when a spill occurs

max_dn_time

Long

Maximum execution time of a statement across all DNs (ms).

average_dn_time

Long

Average execution time of a statement across all DNs (ms).

dntime_skew_percent

Integer

Execution time skew of a statement among DNs.

max_cpu_time

Long

Maximum CPU time of a statement across all DNs (ms).

total_cpu_time

Long

Total CPU time of a statement across all DNs (ms).

cpu_skew_percent

Integer

CPU time skew of a statement among DNs

warning

String

Alarms related to SQL self-diagnosis and optimization

max_peak_iops

Integer

Maximum IOPS of a statement across all DNs. It is counted by ones in a column-store table and by ten thousands in a row-store table.

average_peak_iops

Integer

Average IOPS peak of a statement across all DNs. It is counted by ones in a column-store table and by ten thousands in a row-store table.

iops_skew_percent

Integer

I/O skew of a statement among DNs

query

String

Statement that is being executed

node_group

String

Logical cluster of the user running the statement

query_status

String

Overall state of the backend

wlm_status

String

Current status of the statement

wlm_attrib

String

Statement attributes

lane

String

Fast or slow lane of a statement or query

priority

Long

Priority of Cgroup where the statement is located

stream_cnt

Long

Number of DNs on which the level of the streaming thread is greater than 0.

dn_cnt

Long

Number of DNs whose level of the streaming thread is 0.

cn_cnt

Long

Number of CNs

business_table_analyze

Service Table Statistics Status

ctime

Timestamp

Collection time

virtual_cluster_id

Integer

Virtual cluster ID

host_id

Integer

ID of the node where data is collected and reported

dbname

String

Database name

schema_name

String

Schema name

table_name

String

Table name

total_size

Long

Table size

last_analyze_time

Timestamp

Last analyze time of the table

business_table_skew_rate

Skew rate

ctime

Timestamp

Collection time

virtual_cluster_id

Integer

Virtual cluster ID

host_id

Integer

ID of the node where data is collected and reported

db_name

String

Database name

schema_name

String

Schema name

table_name

String

Table name

table_size

Long

Table size

skew_rate

Float

Skew rate

business_thread_wait

Service Waiting Events

ctime

Timestamp

Collection time

virtual_cluster_id

Integer

Virtual cluster ID

host_id

Integer

ID of the node where data is collected and reported

wait_status

String

Waiting status

wait_event

String

Wait event

count

Integer

Quantity

business_active_ratio_warn

Concurrent Service Usage

ctime

Timestamp

Collection time

virtual_cluster_id

Integer

Virtual cluster ID

host_id

Integer

ID of the node where data is collected and reported

nodename

String

Node name

active

Integer

Number of active services

used_ratio

Float

Percentage of space used

business_conflict_lock

Conflicting Lock Information

ctime

Timestamp

Collection time

virtual_cluster_id

Integer

Virtual cluster ID

host_id

Integer

ID of the node where data is collected and reported

locktype

String

Type of the locked object

nodename

String

Name of the node where the locked object resides

dbname

String

Name of the database where the locked object resides.

nspname

String

Name of the namespace of the locked object

relname

String

Name of the relation of the locked object

partname

String

Name of the partition of the locked object

page

Long

Number of the page of the locked object

tuple

Long

Number of the tuple of the locked object

transactionid

String

ID of the transaction of the locked object

username

String

Name of the user who applies for the lock

gxid

String

ID of the transaction that applies for the lock

xactstart

Timestamp

Start time of the transaction that applies for the lock

queryid

Long

Latest query ID of the thread that applies for the lock

query

String

Latest query statement of the thread that applies for the lock

pid

Long

ID of the thread that applies for the lock

mode

String

Lock mode

granted

Boolean

Indicates whether a lock is held.

business_connection_ratio

Service Session Usage

ctime

Timestamp

Collection time

virtual_cluster_id

Integer

Virtual cluster ID

host_id

Integer

ID of the node where data is collected and reported

coorname

String

CN node name

active

Integer

Number of active links

setting

Integer

Maximum number of links

used_ratio

Float

Percentage of used links

business_respool_info

Resource pool job running information and resource usage information

ctime

Timestamp

Collection time

virtual_cluster_id

Integer

Virtual cluster ID

host_id

Integer

ID of the node where data is collected and reported

rpname

String

Name of the resource pool associated with the query

nodegroup

String

Name of the cluster where the query is performed

cn_count

Long

Number of CNs in a cluster

short_acc

Boolean

Whether to enable short query acceleration for a resource pool

session_count

Long

Number of sessions associated with the resource pool

active_count

Long

Number of active sessions associated with the resource pool

global_wait

Long

Number of jobs associated with the resource pool that are queued because the number of concurrent jobs on a single CN exceeds the value of max_active_statements.

fast_run

Long

Number of jobs associated with the resource pool that are running on the fast lane.

fast_wait

Long

Number of jobs associated with the resource pool that are queued on the fast lane.

fast_limit

Long

Maximum number of concurrent jobs on the fast lane in a resource pool.

slow_run

Long

Number of jobs associated with the resource pool that are running on the slow lane.

slow_wait

Long

Number of jobs associated with the resource pool that are queued on the slow lane.

slow_limit

Long

Maximum number of concurrent jobs on the slow lane in a resource pool.

used_mem

Float

Average memory usage of a resource pool on all DNs.

estimate_mem

Long

Total estimated memory of running jobs in the resource pool.

mem_limit

Float

Upper limit of available memory in the resource pool.

query_mem_limit

String

Maximum memory that can be used by a single query in a resource pool.

used_cpu

Float

Average number of CPU cores occupied by a resource pool on all DNs.

cpu_limit

Long

Average upper limit of available CPUs on all nodes in a resource pool.

read_speed

Float

Average logical I/O read rate of a resource pool on all DNs.

write_speed

Float

Average logical I/O write rate of a resource pool on all DNs.

business_respool_user_info

Job Running Information and Resource Usage Information

ctime

Timestamp

Collection time

virtual_cluster_id

Integer

Virtual cluster ID

host_id

Integer

ID of the node where data is collected and reported

username

String

Username

rpname

String

Name of the resource pool associated with the user

nodegroup

String

Name of the logical cluster to which the resource pool belongs

session_count

Long

Number of sessions initiated by the user.

active_count

Long

Number of sessions initiated by the user

global_wait

Long

Number of jobs that are queued because the number of concurrent jobs on a single CN exceeds the value of max_active_statements.

fast_run

Long

Number of jobs that are running on the fast lane of the resource pool among all jobs executed by the user.

fast_wait

Long

Number of jobs queued in the fast lane of the resource pool among all jobs executed by the user.

slow_run

Long

Number of jobs that are running on the slow lane of the resource pool among all jobs executed by the user.

slow_wait

Long

Number of jobs queued in the slow lane of the resource pool among all jobs executed by the user.

used_mem

Float

Average memory used by a user on all DNs (MB).

estimate_mem

Long

Total estimated memory used by running jobs (MB).

used_cpu

Float

Average number of CPU cores used by a user on all DNs.

read_speed

Long

Average logical I/O read rate of a user on all DNs (KB/s).

write_speed

Long

Average logical I/O write rate of a user on all DNs (KB/s).

used_space

Long

Used space of user permanent tables (KB).

space_limit

Long

Maximum space that can be used by user permanent tables (KB).

used_temp_space

Long

Used space of user temporary tables (KB).

temp_space_limit

Long

Maximum space that can be used by user temporary tables (KB).

used_spill_space

Long

Used space for flushing intermediate result sets (KB).

spill_space_limit

Long

Maximum space that can be used for flushing intermediate result sets (KB).

cluster_snapshot_status

Transaction Information on the Current GTM

ctime

Timestamp

Collection time

virtual_cluster_id

Integer

Virtual cluster ID

host_id

Integer

ID of the node where data is collected and reported.

xact_min

String

Minimum ID of the running transactions.

xact_max

String

ID of the transaction next to the executed transaction with the maximum ID.

xact_csn

String

Specifies the sequence number of the transaction to be committed.

xact_oldestxmin

String

Minimum ID of the executed transactions.

xact_cnt

String

Number of the running transactions.

xact_running_xids

String

IDs of the running transactions.

cluster_top_sql_size

TopSql Size

ctime

Timestamp

Collection time.

virtual_cluster_id

Integer

Virtual cluster ID.

host_id

Integer

ID of the node where data is collected and reported.

size

Long

TopSql Size

command_cpu_usage

Process CPU usage statistics

ctime

Timestamp

Collection time

virtual_cluster_id

Integer

Virtual cluster ID

host_id

Integer

ID of the node where data is collected and reported

pid

String

Parent process ID

username

String

Username

state

String

Process status

command

String

Process command

args

String

Process command parameters

cpu_rate

Double

CPU usage

cpu_io_diagnose_detail

CPU and I/O diagnosis details

ctime

Timestamp

Collection time

virtual_cluster_id

Integer

Virtual cluster ID

host_id

Integer

ID of the node where data is collected and reported

inst_name

String

Instance name

lwtid

String

Lightweight thread ID

datname

String

Database name

username

String

Username

application_name

String

Application name

state

String

Thread status

query

String

Query SQL

comm

String

Thread command

cpu_rate

Double

CPU usage

io_write

Double

I/O write rate

io_read

Double

I/O read rate

pid

String

Backend thread ID

query_id

String

Query ID

count

Bigint

Number of subqueries

database_cu_check

Column-store Small CU Information

ctime

Timestamp

Collection time

virtual_cluster_id

Integer

Virtual cluster ID.

host_id

Integer

ID of the node where data is collected and reported.

database

String

Database name.

schema

String

Schema name

tablename

String

Table name.

tablesize

Long

Table size.

rows_per_cu

Long

Number of column-store small CUs

database_dbmonitor_probe

Statement Execution Status

ctime

Timestamp

Collection time

virtual_cluster_id

Integer

Virtual cluster ID

host_id

Integer

ID of the node where data is collected and reported

create_cost

Float

Time required for creating a table

insert_cost

Float

Duration of the insert operation

select_cost

Float

Duration of the select operation

drop_cost

Float

Duration of deleting a table

commit_cost

Float

Duration of submitting a transaction

create_detail

String

Execution plan for creating a table

insert_detail

String

Execution plan for the insert operation

select_detail

String

Execution plan for the select operation

drop_detail

String

Execution plan for deleting a table

database_replication_slots

Replication Node Information

ctime

Timestamp

Collection time

virtual_cluster_id

Integer

Virtual cluster ID

host_id

Integer

ID of the node where data is collected and reported

slot_name

String

Name of a replication node

slot_type

String

Type of a replication node

active

Boolean

Whether the replication node is active

restart_lsn

String

Xlog file information on the replication node

database_system_tables_size

Database Table Information

ctime

Timestamp

Collection time

virtual_cluster_id

Integer

Virtual cluster ID

host_id

Integer

ID of the node where data is collected and reported

table_name

String

Table name

table_size

Integer

Table size

database_user_partitions_count

Total number of user table partitions in the database

ctime

Timestamp

Collection time

virtual_cluster_id

Integer

Virtual cluster ID

host_id

Integer

ID of the node where data is collected and reported

database

String

Database name

partitions_count

Integer

Number of partitions

database_user_tables_count

User Table Statistics

ctime

Timestamp

Collection time

virtual_cluster_id

Integer

Virtual cluster ID

host_id

Integer

ID of the node where data is collected and reported

database

String

Database name

column_store_table_count

Integer

Number of column-store tables

row_store_table_count

Integer

Number of row-store tables

hstore_table_count

Integer

Number of hstore tables

ts_table_count

Integer

Number of TS tables

foreign_table_count

Integer

Number of foreign tables

view_count

Integer

Number of hash tables

index_count

Integer

Number of replication tables

sequence_count

Integer

Number of polling tables

hash_table_count

Integer

Number of schemas

replication_table_count

Integer

Number of views

polling_table_count

Integer

Number of procs

schema_count

Integer

Number of indexes

proc_count

Integer

Number of sequences

database_wal_sender

Statistics About Replication Sending Threads on All WALs on the Current DN

ctime

Timestamp

Collection time

virtual_cluster_id

Integer

Virtual cluster ID

host_id

Integer

ID of the node where data is collected and reported

nodename

String

Node name

sender_pid

Long

pID of the current sender

local_role

String

Local role

peer_role

String

Peer role

peer_state

String

Peer status

state

String

Replication status of the current sender

sender_sent_location

String

Location where the sender sends LSNs

sender_write_location

String

Location where the sender writes LSNs

sender_flush_location

String

Location where the sender flushes LSNs

sender_replay_location

String

Location where the sender replays LSNs

receiver_received_location

String

Location where the receiver receives LSNs

receiver_write_location

String

Location where the receiver writes LSNs

receiver_flush_location

String

Location where the receiver flushes LSNs

receiver_replay_location

String

Location where the receiver replays LSNs

inst_tmp_count

Temporary File Spill Information

ctime

Timestamp

Collection time

virtual_cluster_id

Integer

Virtual cluster ID

host_id

Integer

ID of the node where data is collected and reported

instid

Integer

Instance ID

query_id

Long

query_ID of the SQL statement that causes data spilling to disks

query

String

SQL statement that causes data spilling to disks

files_count

Long

Number of files spilling to disks

instance_checkpoint

Instance Checkpoint Information

ctime

Timestamp

Collection time

virtual_cluster_id

Integer

Virtual cluster ID

host_id

Integer

ID of the node where data is collected and reported

instid

Integer

Instance ID

label

String

Information attribute

value

String

Information value

instance_mem_warn

Instance Memory Usage

ctime

Timestamp

Collection time

virtual_cluster_id

Integer

Virtual cluster ID

host_id

Integer

ID of the node where data is collected and reported

nodename

String

Node name

process_used_memory

Long

Memory used by a process

max_process_memory

Long

Maximum memory of a process

used_ratio

Long

Memory usage

instance_process_stat

Instance Process proc/stat Information

ctime

Timestamp

Collection time

virtual_cluster_id

Integer

Virtual cluster ID

host_id

Integer

ID of the node where data is collected and reported

instid

Integer

Instance ID

insttype

String

Instance type

pid

Long

Process pid

command

String

Process name of the task_struct structure

state

String

Process status. The value is S.

ppid

Long

ID of the parent process. (The parent process is in fork mode, and the clone process is not the parent process.)

pgrp

Long

Process group ID

session

Long

Session group ID of a process

tty_nr

Long

TTY end device ID of the current process

tpgid

Long

Foreground process ID of the control process terminal

flags

Long

Process flag, which is defined by PF_* in include/linux/sched.h.

minflt

Long

Number of minor page faults, which happen when there is no need to load memory pages, such as COW and anonymous pages, from disk.

cminflt

Long

minflt when the current process waits for the child process.

majflt

Long

Number of major page faults, which happen when memory pages, such as map files, need to be loaded from disks.

majflt_cow

Long

majflt when the current process waits for the child process.

utime

Long

Time when the process is in user mode

stime

Long

Time when the process is in kernel mode

cutime

Long

utime when the current process waits for the child process

cstime

Long

utime when the current process waits for the child process

priority

Long

Process priority

nice

Long

Nice value. The value range is [-20,19].

num_threads

Long

Number of threads

itrealvalue

Long

This field has been discarded and is always 0.

starttime

Long

Process creation time after the system is started

vsize

Long

Virtual memory size of a process

rss

Long

Memory exclusively occupied by a process + Shared library (pages).

rsslim

String

rss size upper limit

instance_space

Instance Internal Data Space Statistics

ctime

Timestamp

Collection time

virtual_cluster_id

Integer

Virtual cluster ID

host_id

Integer

ID of the node where data is collected and reported

instid

Integer

Instance ID

pg_xlog

Long

Xlog file size of a single instance

pg_cbm

Long

Size of the CBM file in a single instance

pg_rewind_bak

Long

Size of the pg_rewind_bak file in a single instance

pgsql_tmp

Long

Number of files spilling to disks in a single instance

core

Long

Core file size of a single instance

coreowner

String

Owner of the core file

memory_diagnose_detail

Memory diagnosis details

ctime

Timestamp

Collection time

virtual_cluster_id

Integer

Virtual cluster ID

host_id

Integer

ID of the node where data is collected and reported

inst_name

String

Instance name

data_type

String

Collection type

state

String

Thread status

username

String

Username

query_id

String

Query ID

query

String

Query SQL

pid

String

Backend thread ID

sess_id

String

Thread start time and thread ID

sess_type

String

Thread name

context_name

String

Memory context name

level

Integer

Level of the current context in the overall memory context

parent

String

Name of the parent memory context

count

Bigint

Number of queries

total_size

Bigint

Total dynamic memory

free_size

Bigint

Free dynamic memory

used_size

Bigint

Used dynamic memory

datname

String

Database name

application_name

String

Application name

node_agent_stat

dmsagent Process Information

ctime

Timestamp

Collection time

virtual_cluster_id

Integer

Virtual cluster ID

host_id

Integer

ID of the node where data is collected and reported

instid

Integer

Instance ID

insttype

String

Instance type (CN/DN/GTM/CMA)

pid

Long

Process pid

command

String

Process name of the task_struct structure

state

String

Process status. The value is S.

ppid

Long

ID of the parent process. (The parent process is in fork mode, and the clone process is not the parent process.)

pgrp

Long

Process group ID

session

Long

Session group ID of a process

tty_nr

Long

TTY end device ID of the current process

tpgid

Long

Foreground process ID of the control process terminal

flags

Long

Process flag, which is defined by PF_* in include/linux/sched.h.

minflt

Long

Number of minor page faults, which happen when there is no need to load memory pages, such as COW and anonymous pages, from disk.

cminflt

Long

minflt when the current process waits for the child process.

majflt

Long

Number of major page faults, which happen when memory pages, such as map files, need to be loaded from disks.

majflt_cow

Long

majflt when the current process waits for the child process.

utime

Long

Time when the process is in user mode

stime

Long

Time when the process is in kernel mode

cutime

Long

utime when the current process waits for the child process

cstime

Long

utime when the current process waits for the child process

priority

Long

Process priority

nice

Long

Nice value. The value range is [-20,19].

num_threads

Long

Number of threads

itrealvalue

Long

This field has been discarded and is always 0.

starttime

Long

Process creation time after the system is started

vsize

Long

Virtual memory size of a process

rss

Long

Memory exclusively occupied by a process + Shared library (pages).

rsslim

String

rss size upper limit

node_fd_total_count

Total number of file descriptors on a node

ctime

Timestamp

Collection time

virtual_cluster_id

Integer

Virtual cluster ID

host_id

Integer

ID of the node where data is collected and reported

alloc_count

Long

Number of allocated file handles.

alloc_unuse_count

Long

Number of allocated and unused file handles

total_count

Long

Maximum number of file handles

node_fs_size

File System Size

ctime

Timestamp

Collection time

virtual_cluster_id

Integer

Virtual cluster ID

host_id

Integer

ID of the node where data is collected and reported

filesystem

String

Device symbol

total

Long

Total size

used

Long

Used size

available

Long

Available size

usage_percent

Integer

Usage (%)

mounted_on

String

Path

node_meminfo

Node /proc/meminfo Information

ctime

Timestamp

Collection time

virtual_cluster_id

Integer

Virtual cluster ID

host_id

Integer

ID of the node where data is collected and reported

mem_type

String

Information in the first column in /proc/meminfo

value_in_kb

String

Memory value of a specific type in /proc/meminfo

node_memory_page

Node Memory Activity

ctime

Timestamp

Collection time

virtual_cluster_id

Integer

Virtual cluster ID

host_id

Integer

ID of the node where data is collected and reported

pagein_rate

Float

Disk page-in rate per second

pageout_rate

Float

Disk pageout rate per second

pagefault_rate

Float

System pagefault rate per second

majfault_rate

Float

System majorpagefault rate per second

pagefree_rate

Float

Idle pages cleared by the system per second

pagescank_rate

Float

kswapd tasks scanned per second

pgscand_rate

Float

System scanning size per second

pagesteal_rate

Float

System pagecache reclamation rate

vmeff_ratio

Float

memory calculated by pgsteal/pgscan

node_memory_swap

Node Memory Swap Status

ctime

Timestamp

Collection time

virtual_cluster_id

Integer

Virtual cluster ID

host_id

Integer

ID of the node where data is collected and reported

kbmemfree

Long

Free memory (KB)

kbmemused

Long

Used memory (KB)

memused_ratio

Float

Memory usage

kbbuffers

Long

Buffer memory (KB)

kbcached

Long

Cached memory (KB)

kbcommit

Long

Workload memory (KBRAM/SWAP)

commit_ratio

Float

Workload memory ratio

kbactive

Long

Active memory (KB)

kbinact

Long

Inactive memory (KB)

kbdirty

Long

Dirty pages to be written back by the pagecache (KB)

node_net_stat

Node Network Information

ctime

Timestamp

Collection time

virtual_cluster_id

Integer

Virtual cluster ID

host_id

Integer

ID of the node where data is collected and reported

interface

String

Network port

rxpps

Float

Number of received packets per second

txpps

Float

Number of sent packets per second

rxkbps

Float

Number of received bytes per second

txkbps

Float

Number of sent bytes/s

rxcmpps

Float

Number of received compressed packets per second

txcmpps

Float

Number of compressed packets sent per second

rxmcstps

Float

Number of received multicast packets per second

ifutil

Float

Utilization

rxerrps

Float

Number of received error packets per second

txerrps

Float

Number of error packets sent per second

collps

Float

Number of bad packets sent per second

rxdropps

Float

Lost packets on the receive side per second

txdropps

Float

Lost packets on the transmit side per second

txcarrps

Float

CE packets on the transmit side per second

rxframps

Float

Bad rrames on the receive side per second

rxfifops

Float

FIFO queue overflow on the receive side per second

txfifops

Float

FIFO queue overflow on the transmit side per second

tc_delay

Integer

TC delay configuration

tc_loss

Float

TC packet loss rate configuration

tc_drop

Long

Number of lost TC packets

node_process_count

Node Process Status

ctime

Timestamp

Collection time

virtual_cluster_id

Integer

Virtual cluster ID

host_id

Integer

ID of the node where data is collected and reported

d_thread_count

Integer

Number of d threads

z_thread_count

Integer

Number of z threads

total_process_count

Integer

Total number of processes in the system

node_process_CPU_top20

Top 20 CPU Processes on a Node

ctime

Timestamp

Collection time

virtual_cluster_id

Integer

Virtual cluster ID

host_id

Integer

ID of the node where data is collected and reported

username

String

Username

processid

Long

pID

cpu_percent

Float

CPU usage

mem_percent

Float

Memory usage

vir_mem_size

String

Virtual memory

res_mem_size

String

Memory used

stat

String

Status

start

String

Start time

duration

String

Running time

command

String

Execution cmd

node_process_mem_top20

Top 20 Memory Processes on a Node

ctime

Timestamp

Collection time

virtual_cluster_id

Integer

Virtual cluster ID

host_id

Integer

ID of the node where data is collected and reported

username

String

Username

processid

Long

pID

cpu_percent

Float

CPU usage

mem_percent

Float

Memory usage

vir_mem_size

String

Virtual memory

res_mem_size

String

Memory used

stat

String

Status

start

String

Start time

duration

String

Running time

command

String

Execution cmd

node_task_loadavg

Node Load Information

ctime

Timestamp

Collection time

virtual_cluster_id

Integer

Virtual cluster ID

host_id

Integer

ID of the node where data is collected and reported

runq_size

Integer

Task queue

total_task_count

Integer

Total number of tasks in the system

loadavg1

Float

1 min load

loadavg5

Float

5 min load

loadavg15

Float

15 min load

blocked

Integer

Number of blocked I/Os

node_tcp_snmp

Node /proc/net/snmp information

ctime

Timestamp

Collection time

virtual_cluster_id

Integer

Virtual cluster ID

host_id

Integer

ID of the node where data is collected and reported

rtoalgorithm

Long

No meaning

rtomin

Long

No meaning

rtomax

Long

No meaning

maxconn

Long

Maximum number of connections

activeopens

Long

Number of TCP connection requests initiated by the server

passiveopens

Long

Number of TCP requests received by the server

attemptfails

Long

Number of TCP connection failures (AttemptFails)

estabresets

Long

No meaning

currestab

Long

Number of currently established TCP connections

insegs

Long

Total number of received fragments

outsegs

Long

Total number of sent fragments

retranssegs

Long

Retransmitted packets

inerrs

Long

Number of received error packets

outrsts

Long

Number of sent error packets

incsumerrors

Long

No meaning

node_tcp_state_count

Node TCP Connection Status Statistics

ctime

Timestamp

Collection time

virtual_cluster_id

Integer

Virtual cluster ID

host_id

Integer

ID of the node where data is collected and reported

established

Integer

Number of established connections.

synsent

Integer

The current status is sync_sent.

synrecv

Integer

The current status is sync_recv.

finwait1

Integer

The current status is finwait1.

finwait2

Integer

The current status is finwait2

timewait

Integer

The current status is timewait

closed

Integer

The current status is closed

closewait

Integer

The current status is closewait

lastack

Integer

The current status is lastack

listening

Integer

The current status is listening

closing

Integer

The current status is closing

warn_conflict_lock_duration

Conflicting Lock Information

ctime

Timestamp

Collection time

virtual_cluster_id

Integer

Virtual cluster ID

host_id

Integer

ID of the node where data is collected and reported

locktype

String

Type of the locked object

nodename

String

Name of the node where the locked object resides

dbname

String

Name of the database where the locked object resides

nspname

String

Name of the namespace where the locked object resides

relname

String

Name of the relation of the locked object

partname

String

Name of the partition where the locked object resides

page

Long

Number of the page where the locked object resides

tuple

Long

Number of the tuple of the locked object

transactionid

String

ID of the transaction of the locked object

username

String

Name of the user who applies for the lock

gxid

String

ID of the transaction that applies for the lock

xactstart

Timestamp

Start time of the transaction that applies for the lock

queryid

Long

Latest query ID of the thread that applies for the lock

query

String

Latest query statement of the thread that applies for the lock

pid

Long

ID of the thread that applies for the lock

mode

String

Lock mode

duration

Long

Indicates whether a lock is held.

warn_instance_checkpoint

Instance Checkpoint Time

ctime

Timestamp

Collection time

virtual_cluster_id

Integer

Virtual cluster ID

host_id

Integer

ID of the node where data is collected and reported

instid

Integer

Instance ID

last_cp_time

Long

Latest checkpoint time

since_last_cp

Long

Difference between the current system time and last_cp_time

warn_node_memory

System memory overhead of non-DWS tasks

ctime

Timestamp

Collection time

virtual_cluster_id

Integer

Virtual cluster ID

host_id

Integer

ID of the node where data is collected and reported

total_mem

Long

Total memory of a node

total_use

Long

Used memory of a node

instance_use

Long

Used memory of the instance

os_ratio

Long

Memory usage of non-GaussDB components