User-defined Counter List

AbnormalJob

Abnormal Job Monitoring Statistics

ctime

Timestamp

Collection time

virtual_cluster_id

Integer

Virtual cluster ID

query_id

String

Specifies the 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

Percentage of consumed agentmem

workplace_dir_time

String

Time when the workpalce 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

HostName

host_stat

String

Specifies the VM 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

HostName

inst_id

Integer

Instance ID

inst_type

String

Instance Type

inst_role

String

Instance Role

inst_stat

String

Specifies the 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

Detected

host_id

Integer

ID of the node where data is collected and reported.

host_name

String

HostName

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 an active/standby switchover has occurred

redistributing

String

Indicates whether redistribution occurs.

cluster_read_only

String

Whether the current cluster is read-only

CpuStat

CPU status

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 value is all.

usr

Float

User-Mode CPU Time (%)

nice

Float

The nice value is the CPU time % of the negative process.

sys

Float

% of time in kernel mode

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

Hyper-threading Enabled (Yes/No)

run_count

Long

Number of processes in the runable state

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','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 reading 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 are counted, regardless of why the temporary file was created (for example, sorting or hashing), and 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 counted, regardless of why the temporary file was created, and 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

Disk File System Name

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

Disk File System Name

total

Long

Total Capacity (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 (unit: KB)

kb_wrtn_s

Float

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

kb_read

Float

Total read data volume (unit: KB)

kb_wrtn

Float

Total amount of written data (unit: 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 (unit: KB)

wkb_s

Float

Write Data Volume 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 to the total I/O processing 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 Path

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 (unit: KB)

mem_free

Long

Memory that is not used in the system. The value is lowfree+highfree (unit: KB).

buffers

Long

Size of the cache for the block device, in KB.

cached

Long

Size of the file buffer (unit: KB)

swap_total

Long

Total swap space (unit: KB)

swap_free

Long

Size of the RAM temporarily stored in the swap (unit: KB)

hardware_corrupted

Long

Memory size of the virus-infected page (unit: 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

Network Adapter Speed (Gigabit/100 Mbit/s)

recv_bytes

Long

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

recv_packets

Long

Total Number of Packets Received by the Network Adapter

recv_errors

Long

Total Number of NIC Receiving Errors

recv_drop

Long

Total Number of Data Packets Discarded by the NIC During Receiving

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

Enabling NIC Multi-Queue

multi_q_smp_affinity

String

CPU Affinity of Multi-Queue NICs

duplex

String

Whether the network adapter works in duplex mode

io_rate

Double

Network Rate

NodeSqlCount

Node SQL Statistics

ctime

Timestamp

Collection time

virtual_cluster_id

Integer

Virtual cluster ID

node_name

String

Node name

user_name

String

User

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 MERGEINTOs

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

SELECT quantity difference per unit time

delta_update_count

Long

Difference in the number of UPDATEs per unit time

delta_insert_count

Long

INSERT quantity difference per unit time

delta_delete_count

Long

DELETE quantity difference per unit time

delta_mergeinto_count

Long

MERGEINTO quantity difference per unit time

delta_ddl_count

Long

DDL Quantity Difference per Unit Time

delta_dml_count

Long

DML quantity difference per unit time

delta_dcl_count

Long

DCL Quantity Difference per Unit Time

delta_total_select_elapse

Long

Total SELECT Response Time Difference in Unit Time

delta_avg_select_elapse

Long

Average SELECT Response Time Difference per Unit Time

delta_max_select_elapse

Long

Maximum SELECT Response Time Difference per Unit Time

delta_min_select_elapse

Long

Minimum SELECT response time difference per unit time

delta_total_update_elapse

Long

Total UPDATE Response Time Difference in Unit Time

delta_avg_update_elapse

Long

Maximum UPDATE Response Time Difference in Unit Time

delta_max_update_elapse

Long

Minimum UPDATE Response Time Difference in Unit Time

delta_min_update_elapse

Long

Minimum UPDATE Response Time Difference in Unit Time

delta_total_delete_elapse

Long

Total DELETE Response Time Difference in Unit Time

delta_avg_delete_elapse

Long

Average DELETE Response Time Difference in Unit Time

delta_max_delete_elapse

Long

Maximum DELETE Response Time Difference in Unit Time

delta_min_delete_elapse

Long

Minimum DELETE Response Time Difference in Unit Time

delta_total_insert_elapse

Long

Total INSERT Response Time Difference in Unit Time

delta_avg_insert_elapse

Long

Average INSERT Response Time Difference in Unit Time

delta_max_insert_elapse

Long

Maximum INSERT Response Time Difference in Unit Time

delta_min_insert_elapse

Long

Minimum INSERT Response Time Difference in Unit Time

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

Indicates the 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, in seconds.

query_id

String

ID of a query

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

Lock Waiting Resource

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 aaa

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

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

Obtaining Resource Pool Statistics

ctime

Timestamp

Collection time

virtual_cluster_id

Integer

Virtual cluster ID

respool_name

String

Load resource pool

cpu_quota

Integer

Specifies the CPU quota of the resource pool.

mem_quota

Integer

Specifies the memory quota of the resource pool.

disk_quota

Long

Resource Pool Disk Quota

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

Resource Pool Disk Usage

simple_query

Integer

Number of concurrent simple jobs in the resource pool

complicated_query

Integer

Number of concurrent requests in the resource pool

business_complicated_simple_sql

Collects statistics on the number of SQL statements based on SQL 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 Properties

count

Integer

Number of SQL Statements

business_concurrency

Service Concurrency Test

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

Running status

count

Integer

Quantity

business_dn_thread_wait

Number of service DN waiting states

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

User Name

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

Hiudi 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

Job 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

Peer 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, in 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

The node name.

traffic_mb

Float

OBS write traffic statistics during the 10 minutes before logtime

bandwidth_mb_per_s

Float

Average bandwidth, in 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

Querying the Job Type

user_name

String

User Name

application_name

String

Application name

client_address

String

Client IP Address

client_hostname

String

Indicates the 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. The unit is ms.

duration

Long

For how long a statement has been executing. The unit is 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. The unit is MB.

average_peak_memory

Integer

Average memory usage during statement execution. The unit is MB.

memory_skew_percent

Integer

Memory usage skew of a statement among DNs.

estimate_memory

Integer

Estimated memory used by the statement. The unit is MB.

spill_info

String

Information about statement flushing into disks on 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. The unit is ms.

average_dn_time

Long

Average execution time of a statement across all DNs. The unit is 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. The unit is ms.

total_cpu_time

Long

Total CPU time of a statement across all DNs. The unit is 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 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.

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 across 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 for statement queries.

priority

Long

Priority of Cgroup where the statement is located

stream_cnt

Long

Number of DNs Whose Streaming Thread Level Is Greater Than 0

dn_cnt

Long

Number of DNs Whose Streaming Thread Level Is 0

cn_cnt

Long

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 Event

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

wait_event

String

Wait Event

count

Integer

Quantity

bussiness_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

The node name.

active

Integer

Active Quantity

used_ratio

Float

Percentage of space used

bussiness_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 targeted by the lock.

partname

String

Name of the partition targeted by the lock.

page

Long

Number of the page targeted by the lock.

tuple

Long

Number of the tuple targeted by the lock.

transactionid

String

ID of the transaction targeted by the lock.

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

Locked or Not

bussiness_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

bussiness_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

Specifies the 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

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

usename

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, in MB.

estimate_mem

Long

Total estimated memory used by running jobs, in 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, in KB/s.

write_speed

Long

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

used_space

Long

Used space of user permanent tables, in KB.

space_limit

Long

Maximum space that can be used by user permanent tables, in KB.

used_temp_space

Long

Used space of user temporary tables, in KB.

temp_space_limit

Long

Maximum space that can be used by user temporary tables, in KB.

used_spill_space

Long

Used space for flushing intermediate result sets, in KB.

spill_space_limit

Long

Maximum space that can be used for flushing intermediate result sets, in 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

database_cu_check

Column-store small CU

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

shcema name

tablename

String

Table name

tablesize

Long

Table size

rows_per_cu

Long

Column-store small CU

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

Insertion Duration

select_cost

Float

Time Required for Select

drop_cost

Float

Time required for deleting a table

commit_cost

Float

Transaction Submission Duration

create_detail

String

Execution Plan for Table Creation

insert_detail

String

Inserted Execution Plan

select_detail

String

Execution plan of select

drop_detail

String

Execution plan for deleting a table

database_replication_slots

Information about the replication 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.

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

databaseName

partitions_count

Integer

Number of Partitions

database_user_tables_count

Total number of user tables

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

databaseName

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

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 all WAL replication sending threads on a 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

Peer 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

Current sender's replication status

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

Information about flushing temporary instance files to disks

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 flushing to disks.

query

String

SQL statement that causes data to be written to disks

files_count

Long

Number of Files Flushed 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 Processes

max_process_memory

Long

Maximum memory of a process

used_ratio

Long

Memory usage

instance_process_stat

proc/stat information of the instance process

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

Process Session Group ID

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 in PF_* in include/linux/sched.h,

minflt

Long

Number of minor page fault interrupts, that is, there is no need to load memory pages from disk. For example, COW and anonymous pages.

cminflt

Long

The current process waits for the minflt of the child process.

majflt

Long

Number of major page fault interrupts. Memory pages need to be loaded from disks, such as map files.

majflt_cow

Long

The current process waits for the majflt of 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

The migration process priority.

nice

Long

Nice value. The value ranges from 19 to 20.

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, in 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 flushed to disks in a single instance

core

Long

Core file size of a single instance

coreowner

String

Owner of the core file

node_agent_stat

Information about the dmsagent process on the 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.

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

Process Session Group ID

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 in PF_* in include/linux/sched.h,

minflt

Long

Number of minor page fault interrupts, that is, there is no need to load memory pages from disk. For example, COW and anonymous pages.

cminflt

Long

The current process waits for the minflt of the child process.

majflt

Long

Number of major page fault interrupts. Memory pages need to be loaded from disks, such as map files.

majflt_cow

Long

The current process waits for the majflt of 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

The migration process priority.

nice

Long

Nice value. The value ranges from 19 to 20.

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, in 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

Size

used

Long

The used space.

available

Long

Available Size

usage_percent

Integer

Utilization

mounted_on

String

Path

node_meminfo

/proc/meminfo information of the 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.

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

The system clears idle pages per second.

pagescank_rate

Float

kswapd Task Scanning Volume per Second

pgscand_rate

Float

System Scanning Volume per Second

pagesteal_rate

Float

System pagecache reclamation rate

vmeff_ratio

Float

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

Available 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

KB of dirty pages to be written back by the pagecache.

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/s

txkbps

Float

Number of Sent Bytes/s

rxcmpps

Float

Number of received compressed packets per second

txcmpps

Float

Number of sent compressed packets per second

rxmcstps

Float

Number of Received Multicast Packets per Second

ifutil

Float

The usage.

rxerrps

Float

Number of received error packets per second

txerrps

Float

Number of error packets sent per second

collps

Float

Number of Bad Packets/s

rxdropps

Float

Packet Loss Rate on the Receive Side (s)

txdropps

Float

Packet Loss Rate on the Transmit Side (s)

txcarrps

Float

TX-Side CE Packets/s

rxframps

Float

Bad Frames on the RX Side (s)

rxfifops

Float

FIFO queue overflow on the receive side/s

txfifops

Float

FIFO queue overflow on the transmit side/s

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 Usage (rss)

stat

String

Type

start

String

Indicates the time when the task is started.

duration

String

Running Time

command

String

Run the cmd command.

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

User

processid

Long

pID

cpu_percent

Float

CPU Usage

mem_percent

Float

Memory usage

vir_mem_size

String

Virtual Memory

res_mem_size

String

Memory Usage (rss)

stat

String

Type

start

String

Indicates the time when the task is started.

duration

String

Running Time

command

String

Run the cmd command.

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

It has no specific meaning

rtomin

Long

It has no specific meaning

rtomax

Long

It has no specific meaning

maxconn

Long

Max 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

It has no specific 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

It has no specific 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

Current Connection

synsent

Integer

The current status is sync_sent.

synrecv

Integer

The current state is sync_recv.

finwait1

Integer

The system is in the finwait1 state.

finwait2

Integer

The system is in the finwait2 state.

timewait

Integer

The system is in the timewait state.

closed

Integer

The current status is closed.

closewait

Integer

The current status is closewait.

lastack

Integer

The current status is lastack.

listening

Integer

The port is in listening state.

closing

Integer

The current state 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 of the locked object

relname

String

Name of the relation targeted by the lock.

partname

String

Name of the partition targeted by the lock.

page

Long

Number of the page targeted by the lock.

tuple

Long

Number of the tuple targeted by the lock.

transactionid

String

ID of the transaction targeted by the lock.

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

Locked or Not

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