Help Center> GaussDB(DWS)> 8.1.3 Recommended> System Catalogs and System Views> System Views> PG_STAT_GET_MEM_MBYTES_RESERVED

Updated on 2024-05-13 GMT+08:00

View PDF

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

Parent topic: System Views

Previous topic: PG_STAT_DATABASE_CONFLICTS

Next topic: PG_STAT_USER_FUNCTIONS

Feedback

Was this page helpful?

Helpful Not helpful

Provide feedback

Thank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.

The system is busy. Please try again later.

Which of the following issues have you encountered?

Content is inconsistent with the product UI

Unclear descriptions

Lack of examples or code

Incorrect steps

Can't find what I need

Lack of best practices

Feedback (optional)

0/500

Select at least one type of issue, and enter your comments or suggestions.

Enter a maximum of 500 characters.

Submit Cancel

For any further questions, feel free to contact us through the chatbot.