Help Center > > Developer Guide> System Catalogs and System Views> System Views> PV_SESSION_MEMORY

PV_SESSION_MEMORY

Updated at:Jul 15, 2020 GMT+08:00

PV_SESSION_MEMORY displays statistics about memory usage at the session level in the unit of MB, including all the memory allocated to Postgres and Stream threads on DNs for jobs currently executed by users.

Table 1 PV_SESSION_MEMORY columns

Name

Type

Description

sessid

text

Thread start time and ID

init_mem

integer

Memory allocated to the currently executed task before the task enters the executor, in MB

used_mem

integer

Memory allocated to the currently executed task, in MB

peak_mem

integer

Peak memory allocated to the currently executed task, in MB

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel