Viewing GUC Parameters¶
GaussDB(DWS) GUC parameters can control database system behaviors. You can check and adjust the GUC parameters based on your business scenario and data volume.
After a cluster is installed, you can check database parameters on the GaussDB(DWS) console.
You can also connect to a cluster and run SQL commands to check the GUC parameters.
Run the SHOW command.
Note
Method 2 is limited to querying GUC parameter values of CNs. To view GUC parameter values of DNs, you can utilize Method 1 on the management console.
To view a certain parameter, run the following command:
SHOW server_version;
server_version indicates the database version.
Run the following command to view values of all parameters:
SHOW ALL;
Use the pg_settings view.
To view a certain parameter, run the following command:
SELECT * FROM pg_settings WHERE NAME='server_version';
Run the following command to view values of all parameters:
SELECT * FROM pg_settings;