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);
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 |