datid
|
oid
|
OID of the database the backend is connected to
|
dbname
|
name
|
Name of the database the backend is connected to
|
schemaname
|
text
|
Schema name
|
nodename
|
text
|
Name of the database instance where the statement is executed
|
username
|
name
|
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.
|
pid
|
bigint
|
ID of the backend thread
|
sessionid
|
bigint
|
Session ID
|
block_time
|
bigint
|
Block time before the statement is run. The unit is ms.
|
start_time
|
timestamp with time zone
|
Time when the statement execution starts
|
duration
|
bigint
|
Duration that the statement has been executed (unit: ms)
|
estimate_total_time
|
bigint
|
Estimated execution time of the statement. The unit is ms.
|
estimate_left_time
|
bigint
|
Estimated remaining time of statement execution. The unit is ms.
|
enqueue
|
text
|
Resource status in workload management
|
resource_pool
|
name
|
Resource pool used by the user
|
control_group
|
text
|
Cgroup used by the statement
|
estimate_memory
|
integer
|
Estimated memory used by the statement. The unit is MB.
|
min_peak_memory
|
integer
|
Minimum memory peak of the statement across the database instances, in MB
|
max_peak_memory
|
integer
|
Maximum memory peak of the statement across the database instances, in MB
|
average_peak_memory
|
integer
|
Average memory usage during statement execution, in MB
|
memory_skew_percent
|
integer
|
Memory usage skew of the statement among the database instances
|
spill_info
|
text
|
Information about statement spill to the database instances: - None: The statement has not been spilled to disks on the database instances.
- All: The statement has been spilled to disks on the database instances.
- [a:b]: The statement has been spilled to disks on a of b database instances.
|
min_spill_size
|
integer
|
Minimum spilled data among database instances when a spill occurs (unit: MB). The default value is 0.
|
max_spill_size
|
integer
|
Maximum spilled data among database instances when a spill occurs (unit: MB). The default value is 0.
|
average_spill_size
|
integer
|
Average spilled data among database instances when a spill occurs (unit: MB). The default value is 0.
|
spill_skew_percent
|
integer
|
Database instance spill skew when a spill occurs
|
min_dn_time
|
bigint
|
Minimum execution time of the statement across the database instances (unit: ms)
|
max_dn_time
|
bigint
|
Maximum execution time of the statement across the database instances (unit: ms)
|
average_dn_time
|
bigint
|
Average execution time of the statement across the database instances (unit: ms)
|
dntime_skew_percent
|
integer
|
Execution time skew of the statement among the database instances
|
min_cpu_time
|
bigint
|
Minimum CPU time of the statement across the database instances (unit: ms)
|
max_cpu_time
|
bigint
|
Maximum CPU time of the statement across the database instances (unit: ms)
|
total_cpu_time
|
bigint
|
Total CPU time of the statement across the database instances (unit: ms)
|
cpu_skew_percent
|
integer
|
CPU time skew of the statement among the database instances
|
min_peak_iops
|
integer
|
Minimum IOPS peak of the statement across the database instances. 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 instances. 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 instances. 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 instances
|
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 that is being executed
|
query_plan
|
text
|
Execution plan of the statement
|
node_group
|
text
|
Logical database instance of the user to which the statement belongs
|
top_cpu_dn
|
text
|
Top N CPU usage
|
top_mem_dn
|
text
|
Top N memory usage
|