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

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:

1
SELECT pg_stat_get_mem_mbytes_reserved(0);
Table 1 PG_STAT_GET_MEM_MBYTES_RESERVED columns

Column

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.