PGPOOL_SHOW - show the value of a configuration parameter

PGPOOLSHOW will display the current value of Pgpool-II configuration parameters. This command is similar
       to the SHOW[1] command in PostgreSQL with an addition of PGPOOL keyword to distinguish it from the
       PostgreSQL SHOW command.

       Show the current setting of the parameter port:

           PGPOOL SHOW port;
           port
           ------
           9999
           (1 row)

       Show the current setting of the parameter write_function_list:

           PGPOOL SHOW write_function_list;
           write_function_list
           ---------------------
           nextval,setval
           (1 row)

       Show the current settings of all the configuration parameters belonging to backend group:

           PGPOOL SHOW backend;
           item                     |          value          |              description
           -------------------------+-------------------------+-----------------------------------------------------------
           backend_hostname0        | 127.0.0.1               | hostname or IP address of PostgreSQL backend.
           backend_port0            | 5434                    | port number of PostgreSQL backend.
           backend_weight0          | 0                       | load balance weight of backend.
           backend_data_directory0  | /var/lib/pgsql/data     | data directory of the backend.
           backend_flag0            | ALLOW_TO_FAILOVER       | Controls various backend behavior.
           backend_hostname1        | 127.0.0.1               | hostname or IP address of PostgreSQL backend.
           backend_port1            | 5432                    | port number of PostgreSQL backend.
           backend_weight1          | 1                       | load balance weight of backend.
           backend_data_directory1  | /home/work/installed/pg | data directory of the backend.
           backend_flag1            | ALLOW_TO_FAILOVER       | Controls various backend behavior.
           (10 rows)

       Show all settings:

           PGPOOL SHOW ALL;
           item                     |          value          |              description
           -------------------------+-------------------------+-----------------------------------------------------------
           backend_hostname0        | 127.0.0.1               | hostname or IP address of PostgreSQL backend.
           backend_port0            | 5434                    | port number of PostgreSQL backend.
           backend_weight0          | 0                       | load balance weight of backend.
           backend_data_directory0  | /var/lib/pgsql/data     | data directory of the backend.
           backend_flag0            | ALLOW_TO_FAILOVER       | Controls various backend behavior.
           backend_hostname1        | 127.0.0.1               | hostname or IP address of PostgreSQL backend.
           backend_port1            | 5432                    | port number of PostgreSQL backend.
           backend_weight1          | 1                       | load balance weight of backend.
           backend_data_directory1  | /home/work/installed/pg | data directory of the backend.
           backend_flag1            | ALLOW_TO_FAILOVER       | Controls various backend behavior.
           hostname0                | localhost               | Hostname of pgpool node for watchdog connection.
           .
           .
           .
           ssl                      | off                     | Enables SSL support for frontend and backend connections
           (138 rows)

       PGPOOL_SHOW - show the value of a configuration parameter

        1.
               SHOW
           https://www.postgresql.org/docs/current/static/sql-show.html

pgpool-II 4.6.0                                       2023                                        PGPOOLSHOW(1)

configuration_parameter
           The name of a Pgpool-II configuration parameter. Available parameters are documented in Chapter 5,
           Server Configuration, in the documentation.

               Note
               If the parameter contains uppercase letters (e.g.  delegate_ip), the parameter name must be
               enclosed in double quotes.

       configuration_parameter_group
           The name of the Pgpool-II configuration parameter group. Currently there are four parameter groups.

           backend
               Configuration group of all backend config parameters.

           watchdog
               Configuration group of all watchdog node config parameters.

           heartbeat
               configuration group of all watchdog heartbeat config parameters.

           health_check
               configuration group of all health check parameters.

       ALL
           Show the values of all configuration parameters, with descriptions.

       PGPOOL SET (PGPOOL_SET(1))

          PGPOOL SHOW configuration_parameter
          PGPOOL SHOW configuration_parameter_group
          PGPOOL SHOW ALL