HomeMogDBMogDB StackUqbar
v3.1

Documentation:v3.1

Supported Versions:

Other Versions:

GS_WLM_SESSION_INFO_ALL

GS_WLM_SESSION_INFO_ALL displays load management information about a completed job executed on the database instance. Only the user with the sysadmin or monitor admin permission can query this view.

Table 1 GS_WLM_SESSION_INFO_ALL columns

Name Type Description
datid oid OID of the database that this backend is connected to.
dbname text Name of the database the backend is connected to.
schemaname text Schema name.
nodename text Name of the CN where the statement is executed.
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 that the client is connected via a Unix socket on the server machine or that 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 the 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 execution starts.
finish_time timestamp with time zone Time when the statement execution ends.
duration bigint Execution time of a statement. The unit is ms.
estimate_total_time bigint Estimated execution time of a statement. The unit is 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 size of the statement.
min_peak_memory integer Minimum memory peak of the statement across all DNs, in MB.
max_peak_memory integer Maximum memory peak of the statement across all DNs, in 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.
spill_info text Information about statement spilled to all DNs:
- None: The statement has not been spilled to disks on any DNs.
- All: The statement has been spilled to disks on every DN.
- [a:b]: The statement has been spilled to disks on a of b DNs.
min_spill_size integer Minimum spilled data among all DNs when a spill occurs (unit: MB; default value: 0).
max_spill_size integer Maximum spilled data among all DNs when a spill occurs (unit: MB; default value: 0).
average_spill_size integer Average spilled data among all DNs when a spill occurs (unit: MB; default value: 0).
spill_skew_percent integer DN spill skew when a spill occurs.
min_dn_time bigint Minimum execution time of the statement across all DNs, in ms.
max_dn_time bigint Maximum execution time of the statement across all DNs, in ms.
average_dn_time bigint Average execution time of the statement across all DNs, in ms.
dntime_skew_percent integer Execution time skew of the statement among DNs.
min_cpu_time bigint Minimum CPU time of the statement across all DNs, in ms.
max_cpu_time bigint Maximum CPU time of the statement across all DNs, in ms.
total_cpu_time bigint Total CPU time of the statement across all DNs, in ms.
cpu_skew_percent integer CPU time skew of the statement among DNs.
min_peak_iops integer Minimum IOPS peak of the statement across all DNs. 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 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 the 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 the statement among DNs.
warning text Warning. The following warnings and warnings related to SQL self-diagnosis optimization 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 a statement.
node_group text Logical cluster 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 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 memory usage.
mem_top3_node_name text Name of the node with the third highest memory usage.
mem_top4_node_name text Name of the node with the fourth highest memory usage.
mem_top5_node_name text Name of the node with the fifth highest memory 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.
n_returned_rows bigint Number of rows in the result set returned by the SELECT statement.
n_tuples_fetched bigint Number of rows randomly scanned.
n_tuples_returned bigint Number of rows sequentially scanned.
n_tuples_inserted bigint Number of rows inserted.
n_tuples_updated bigint Number of rows updated.
n_tuples_deleted bigint Number of rows deleted.
n_blocks_fetched bigint Number of buffer block access times.
n_blocks_hit bigint Number of buffer block hits.
db_time bigint Valid DB time, which is accumulated if multiple threads are involved (unit: μs).
cpu_time bigint CPU time (unit: μs).
execution_time bigint Execution time in the executor (unit: μs).
parse_time bigint SQL parsing time (unit: μs).
plan_time bigint SQL plan generation time (unit: μs).
rewrite_time bigint SQL rewriting time (unit: μs).
pl_execution_time bigint Execution time of PL/pgSQL (unit: μs).
pl_compilation_time bigint Compilation time of PL/pgSQL (unit: μs).
net_send_time bigint Network time (unit: μs).
data_io_time bigint I/O time (unit: μs).
is_slow_query bigint Whether the record is a slow SQL record.
Copyright © 2011-2024 www.enmotech.com All rights reserved.