GS_QUERY_RESOURCE_INFO

The GS_QUERY_RESOURCE_INFO view displays the resource information about all running jobs on the current DN. This parameter is supported only by clusters of version 9.1.0 or later.

This view can be queried only on DNs. It is used only for O&M operations to locate faults. You are advised not to use this function.

**Table 1** GS_QUERY_RESOURCE_INFO
Name	Type	Description
node_name	text	Instance name, which contains only DNs
user_id	oid	User ID.
queryid	bigint	Internal query ID used for statement execution.
used_mem	int	Memory used by the statement on the current DN. The unit is MB.
cpu_time	bigint	CPU time of a statement on the current DN. The unit is ms.
used_cpu	double	Number of CPUs used by the statement on the current DN.
spill_size	bigint	Amount of data spilled to disks on the current DN. The default value is 0. The unit is MB.
read_bytes	bigint	Number of logical read bytes used by the statement on the current DN. The unit is KB.
write_bytes	bigint	Number of logical write bytes used by the statement on the current DN. The unit is KB.
read_count	bigint	Number of logical reads used by the statement on the current DN.
write_count	bigint	Number of logical writes used by the statement on the current DN.
read_speed	int	Logical read rate used by the statement on the current DN. The unit is KB/s.
write_speed	int	Logical write rate used by the statement on the current DN. The unit is KB/s.
curr_iops	int	I/O operations per second of the statement on the current DN. It is recorded as a count in a column-store table and as a count of 10,000 in a row-store table.
send_pkg	bigint	Total number of communication packages sent by a statement across all DNs.
recv_pkg	bigint	Total number of communication packages received by a statement across all DNs.
send_bytes	bigint	Total sent data of the statement stream, in byte.
recv_bytes	bigint	Total received data of the statement stream, in byte.
send_speed	int	Network sending rate of the statement on the current DN. The unit is KB/s.
recv_speed	int	Network receiving rate of the statement on the current DN. The unit is KB/s.