Help Center > > Developer Guide> GUC Parameters> Viewing GUC Parameters

Viewing GUC Parameters

Updated at: Sep 17, 2021 GMT+08:00

GaussDB(DWS) uses a set of default GUC parameters after it is installed. You can modify the parameters to better fit your service scenarios and data volume.

Procedure

  1. View the parameter values of a database.

    • Use the SHOW command.
      • To view a certain parameter, run the following command:
        1
        SHOW server_version;
        

        server_version indicates the database version.

      • Run the following command to view values of all parameters:
        1
         SHOW ALL;
        
    • Use the pg_settings view.
      • To view a certain parameter, run the following command:
        1
        SELECT * FROM pg_settings WHERE NAME='server_version';
        
      • Run the following command to view values of all parameters:
        1
        SELECT * FROM pg_settings;
        

Examples

Run the following command to view the server version:

1
2
3
4
5
SHOW server_version;
 server_version 
----------------
 9.2.4
(1 row)

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