PGXC_QUERY_INFO

dbname

text

Name of the database connected to the backend

nodename

text

Name of the CN where the statement is run

username

text

Username used for connecting to the backend

application_name

text

Name of the application that is connected to the backend

client_addr

inet

IP address of the client connected to this backend. If this column is null, it indicates that the client is connected via a Unix socket on the server machine or that it is an internal process, such as autovacuum.

query_band

text

Job type, which can be set using the GUC parameter query_band and is a null string by default.

block_time

bigint

Blocking time before statement execution, including statement parsing and optimization time, in milliseconds.

start_time

timestamp with time zone

Start time of statement execution

finish_time

timestamp with time zone

End time of statement execution

duration

bigint

Execution time of the statement, in milliseconds

status

text

End status of statement execution: finished for normal and aborted for abnormal. The statement status recorded here should be the database server execution status. When the server-side execution is successful and an error occurs when the result set is returned, the statement should be finished.

abort_info

text

Exception information displayed if the final statement execution status is aborted.

resource_pool

text

Resource pool used by the user

estimate_memory

integer

Estimated memory used by a statement on a single instance. The unit is MB. This column takes effect only when the GUC parameter enable_dynamic_workload is set to on.

min_peak_memory

integer

Minimum memory peak of a statement across all DNs. The unit is MB.

max_peak_memory

integer

Maximum memory peak of a statement across all DNs. The unit is MB.

spill_info

text

Spill information for the statement on all DNs. The options are:

None: The statement has not been spilled to disks on any DNs.

All: The statement has been spilled to disks on all DNs.

[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. The unit is MB. The default value is 0.

max_spill_size

integer

Maximum spilled data among all DNs when a spill occurs. The unit is MB. The default value is 0.

min_dn_time

bigint

Minimum execution time of a statement across all DNs, in milliseconds

max_dn_time

bigint

Maximum execution time of a statement across all DNs, in milliseconds

total_cpu_time

bigint

Total CPU time of a statement across all DNs, in milliseconds

warning

text

Warning. The following warnings and warnings related to SQL self-diagnosis tuning are displayed:

1. Spill file size larger than 256 MB
2. Broadcast size larger than 100 MB
3. Early spill
4. Spill times are greater than 3
5. Spill on memory adaptive
6. Hash table conflict

queryid

bigint

Internal query ID used for statement execution

query

text

Statement to be executed. A maximum of 64 KB of strings can be retained.

query_plan

text

Execution plan of a statement

Specifications restrictions:

1. Execution plans are displayed only for DML statements.
2. In 8.2.1.100 and later versions, the number of data binding times is added to the execution plans of Parse Bind Execute (PBE) statements to facilitate statement analysis. The number of data binding times is displayed in the format of PBE bind times: Times.

node_group

text

Logical cluster of the user running the statement

pid

bigint

PID of the backend thread for the statement

lane

text

Fast/Slow lane where the statement is executed

unique_sql_id

bigint

ID of the normalized unique SQL

stmt_type

text

Query type corresponding to the statement

except_info

text

Information about the exception rule triggered by the statement

sql_hash

text

Normalized SQL hash

parse_time

bigint

Total parsing time before the statement is queued (including lexical and syntax parsing, optimization rewriting, and plan generation time), in milliseconds. This column is only supported in version 8.3.0.100 or later.

gxid

xid

Statement transaction ID

inserted_rows

bigint

Number of rows inserted by the statement

deleted_rows

bigint

Number of rows deleted by the statement

updated_rows

bigint

Number of rows updated by the statement

returned_rows

bigint

Number of rows returned by the statement