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