Help Center/ GaussDB/ Developer Guide(Centralized_V2.0-3.x)/ Configuring Running Parameters/ Viewing Parameters
Updated on 2025-08-19 GMT+08:00
View PDF

Viewing Parameters

GaussDB uses a set of default running parameters after it is installed. You can modify the parameters to enable GaussDB to better fit the current service scenarios and data volume.

Procedure

  1. Connect to the database.
  2. View the parameter values in the database.

    • Method 1: Run the SHOW command.
      • Run the following command to view the value of a certain parameter: 
        1
        		 
        gaussdb=# SHOW server_version;

        server_version indicates the database version.

      • Run the following command to view values of all parameters: 
        1
        		 
        gaussdb=#  SHOW ALL;
    • Method 2: Query the pg_settings view.
      • Run the following command to view the value of a certain parameter: 
        1
        		 
        gaussdb=# SELECT * FROM pg_settings WHERE NAME='server_version';
      • Run the following command to view values of all parameters: 
        1
        		 
        gaussdb=# SELECT * FROM pg_settings;

Example

Check the character encoding type of the client.

1
2
3
4
5
 
gaussdb=# SHOW SHOW client_encoding;
 SHOW client_encoding 
----------------
 UTF8
(1 row)