Viewing Settings of Server Configuration Parameters in Greenplum

The SHOW SQL command allows you to see the settings of the server configuration parameters used by the Greenplum Database system. For example, to see the settings for all parameters: 

$ psql -c 'SHOW ALL;'

Running SHOW will show the settings for the master instance only. If you want to see the value of a particular parameter across the entire system (master and all segments), you can use the gpconfig utility. For example:

$ gpconfig --show max_connections