• Data Warehouse Service

dws
  1. Help Center
  2. Data Warehouse Service
  3. Developer Guide
  4. Systems Tables and Views
  5. PG_STAT_GET_MEM_MBYTES_RESERVED

PG_STAT_GET_MEM_MBYTES_RESERVED

PG_STAT_GET_MEM_MBYTES_RESERVED displays the current activity information of a thread stored in memory. You need to specify the thread ID (pid in PG_STAT_ACTIVITY) for query. If the thread ID is set to 0, the current thread ID is used. For example:

select pg_stat_get_mem_mbytes_reserved(0);
Table 1 PG_STAT_GET_MEM_MBYTES_RESERVED columns

Parameter

Description

ConnectInfo

Connection information

ParctlManager

Concurrency management information

GeneralParams

Basic parameter information

GeneralParams RPDATA

Basic resource pool information

ExceptionManager

Exception management information

CollectInfo

Collection information

GeneralInfo

Basic information

ParctlState

Concurrency status information

CPU INFO

CPU information

ControlGroup

Cgroup information

IOSTATE

I/O status information