On this page

Show all

GS_QUERY_RESOURCE_INFO

Updated on 2024-09-30 GMT+08:00

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.

NOTE:

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.

Feedback

Feedback

Feedback

0/500

Selected Content

Submit selected content with the feedback