Help Center> Data Warehouse Service> Developer Guide> System Catalogs and System Views> System Views> PV_SESSION_MEMORY
PV_SESSION_MEMORY
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.
| 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 |
Parent topic: System Views
Last Article: PV_OS_RUN_INFO
Next Article: PV_SESSION_MEMORY_DETAIL
Did this article solve your problem?
Thank you for your score！Your feedback would help us improve the website.