Help Center/ GaussDB/ Developer Guide(Centralized_V2.0-8.x)/ System Catalogs and System Views/ System Views/ Other System Views/ GS_SESSION_ALL_SETTINGS
Updated on 2025-08-19 GMT+08:00
GS_SESSION_ALL_SETTINGS
GS_SESSION_ALL_SETTINGS displays the full GUC parameter settings of all sessions on the local node. Only the sysadmin and monadmin users have the permission to view this view. In the multi-tenancy scenario, the result about a PDB is returned to its own PDB, and all information is returned to a non-PDB.
| Name | Type | Description |
|---|---|---|
| sessionid | bigint | Session ID. |
| pid | bigint | Backend thread ID. |
| name | text | Parameter name. |
| setting | text | Current parameter value. |
| unit | text | Implicit unit of a parameter. |
Parent topic: Other System Views
What is your overall rating for this page?
0
1
2
3
4
5
6
7
8
9
10
Very dissatisfiedVery satisfied
Thank you very much for your feedback. We will continue working to improve the documentation.
The system is busy. Please try again later.
