datid
|
oid
|
OID of the database that the backend is connected to
|
dbname
|
text
|
Name of the database that the backend is connected to
|
schemaname
|
text
|
Schema name
|
nodename
|
text
|
Node name
|
username
|
text
|
Username used for connecting to the backend
|
application_name
|
text
|
Name of the application connected to the backend
|
client_addr
|
inet
|
IP address of the client connected to the backend. If this column is null, it indicates either the client is connected via a Unix socket on the server or this is an internal process, such as autovacuum.
|
client_hostname
|
text
|
Host name of the connected client, as reported by a reverse DNS lookup of client_addr. This column will be non-null only for IP connections and only when log_hostname is enabled.
|
client_port
|
integer
|
TCP port number that the client uses for communication with this backend (-1 if a Unix socket is used)
|
query_band
|
text
|
Job type, which is specified by the GUC parameter query_band. The default value is a null string.
|
block_time
|
bigint
|
Duration that the statement is blocked before being executed, including the statement parsing and optimization duration (unit: ms)
|
start_time
|
timestamp with time zone
|
Time when the statement starts to be executed
|
finish_time
|
timestamp with time zone
|
Time when the statement execution ends
|
duration
|
bigint
|
Execution time of the statement (unit: ms)
|
estimate_total_time
|
bigint
|
Estimated execution time of the statement (unit: ms)
|
status
|
text
|
Final statement execution status, which can be finished (normal) or aborted (abnormal).
|
abort_info
|
text
|
Exception information displayed if the final statement execution status is aborted
|
resource_pool
|
text
|
Resource pool used by the user
|
control_group
|
text
|
Cgroup used by the statement
|
estimate_memory
|
integer
|
Estimated memory used by the statement (unit: MB)
|
min_peak_memory
|
integer
|
Minimum memory peak of the statement across the database nodes (unit: MB)
|
max_peak_memory
|
integer
|
Maximum memory peak of the statement across the database nodes (unit: MB)
|
average_peak_memory
|
integer
|
Average memory usage during statement execution (unit: MB)
|
memory_skew_percent
|
integer
|
Memory usage skew of the statement among the database nodes
|
spill_info
|
text
|
Information about statement spill to the database nodes - None: The statement has not been spilled to disks on the database nodes.
- All: The statement has been spilled to disks on the database nodes.
- [a:b]: The statement has been spilled to disks on a of b database nodes.
|
min_spill_size
|
integer
|
Minimum spilled data among database nodes when a spill occurs (unit: MB) (default value: 0)
|
max_spill_size
|
integer
|
Maximum spilled data among database nodes when a spill occurs (unit: MB) (default value: 0)
|
average_spill_size
|
integer
|
Average spilled data among database nodes when a spill occurs (unit: MB) (default value: 0)
|
spill_skew_percent
|
integer
|
Database node spill skew when a spill occurs
|
min_dn_time
|
bigint
|
Minimum execution time of the statement across the database nodes (unit: ms)
|
max_dn_time
|
bigint
|
Maximum execution time of the statement across the database nodes (unit: ms)
|
average_dn_time
|
bigint
|
Average execution time of the statement across the database nodes (unit: ms)
|
dntime_skew_percent
|
integer
|
Execution time skew of the statement among the database nodes
|
min_cpu_time
|
bigint
|
Minimum CPU time of the statement across the database nodes (unit: ms)
|
max_cpu_time
|
bigint
|
Maximum CPU time of the statement across the database nodes (unit: ms)
|
total_cpu_time
|
bigint
|
Total CPU time of the statement across the database nodes (unit: ms)
|
cpu_skew_percent
|
integer
|
CPU time skew of the statement among the database nodes
|
min_peak_iops
|
integer
|
Minimum IOPS peak of the statement across the database nodes. It is counted by ones in a column-store table and by ten thousands in a row-store table.
|
max_peak_iops
|
integer
|
Maximum IOPS peak of the statement across the database nodes. 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 the statement across the database nodes. 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 the statement among the database nodes
|
warning
|
text
|
Warning. The following warnings are displayed: - Spill file size large than 256MB
- Broadcast size large than 100MB
- Early spill
- Spill times is greater than 3
- Spill on memory adaptive
- Hash table conflict
|
queryid
|
bigint
|
Internal query ID used for statement execution
|
query
|
text
|
Statement executed
|
query_plan
|
text
|
Execution plan of the statement
|
node_group
|
text
|
Logical openGauss of the user running the statement
|
cpu_top1_node_name
|
text
|
Name of the node with the highest CPU usage
|
cpu_top2_node_name
|
text
|
Name of the node with the second highest CPU usage
|
cpu_top3_node_name
|
text
|
Name of the node with the third highest CPU usage
|
cpu_top4_node_name
|
text
|
Name of the node with the fourth highest CPU usage
|
cpu_top5_node_name
|
text
|
Name of the node with the fifth highest CPU usage
|
mem_top1_node_name
|
text
|
Name of the node with the highest memory usage
|
mem_top2_node_name
|
text
|
Name of the node with the second highest CPU usage
|
mem_top3_node_name
|
text
|
Name of the node with the third highest CPU usage
|
mem_top4_node_name
|
text
|
Name of the node with the fourth highest CPU usage
|
mem_top5_node_name
|
text
|
Name of the node with the fifth highest CPU usage
|
cpu_top1_value
|
bigint
|
CPU usage
|
cpu_top2_value
|
bigint
|
CPU usage
|
cpu_top3_value
|
bigint
|
CPU usage
|
cpu_top4_value
|
bigint
|
CPU usage
|
cpu_top5_value
|
bigint
|
CPU usage
|
mem_top1_value
|
bigint
|
Memory usage
|
mem_top2_value
|
bigint
|
Memory usage
|
mem_top3_value
|
bigint
|
Memory usage
|
mem_top4_value
|
bigint
|
Memory usage
|
mem_top5_value
|
bigint
|
Memory usage
|
top_mem_dn
|
text
|
Top N memory usage
|
top_cpu_dn
|
text
|
Top N CPU usage
|