GLOBAL_STATEMENT_COMPLEX_HISTORY
Displays workload management information about completed jobs executed on each node, as described in Table 1.
Name |
Type |
Description |
---|---|---|
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 thread, 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. |
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.
|
min_spill_size |
integer |
Minimum spilled data among database nodes when a spill occurs, in MB. The default value is 0. |
max_spill_size |
integer |
Maximum spilled data among database nodes when a spill occurs, in MB. The default value is 0. |
average_spill_size |
integer |
Average spilled data among database nodes when a spill occurs, in MB. The default value is 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 peak IOPS of the statement across database nodes (unit: 10 thousands per second). |
max_peak_iops |
integer |
Maximum peak IOPS of the statement across database nodes (unit: 10 thousands per second). |
average_peak_iops |
integer |
Average peak IOPS of the statement across database nodes (unit: 10 thousands per second). |
iops_skew_percent |
integer |
I/O skew of the statement among the database nodes. |
warning |
text |
Warning. The following warnings are displayed:
|
queryid |
bigint |
Internal query ID used for statement execution. |
query |
text |
Executed statement. |
query_plan |
text |
Execution plan of the statement. |
node_group |
text |
Logical database 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 2nd highest memory usage. |
mem_top3_node_name |
text |
Name of the node with the 3rd highest memory usage. |
mem_top4_node_name |
text |
Name of the node with the 4th highest memory usage. |
mem_top5_node_name |
text |
Name of the node with the 5th highest memory usage. |
cpu_top1_value |
bigint |
1st CPU usage. |
cpu_top2_value |
bigint |
2nd CPU usage. |
cpu_top3_value |
bigint |
3rd CPU usage. |
cpu_top4_value |
bigint |
4th CPU usage. |
cpu_top5_value |
bigint |
5th CPU usage. |
mem_top1_value |
bigint |
1st memory usage. |
mem_top2_value |
bigint |
2nd memory usage. |
mem_top3_value |
bigint |
3rd memory usage. |
mem_top4_value |
bigint |
4th memory usage. |
mem_top5_value |
bigint |
5th memory usage. |
top_mem_dn |
text |
Top N memory usage. |
top_cpu_dn |
text |
Top N CPU usage. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot