Vertica System Tables and Parameters

• How can i get the values for the Vertica database parameters? - Stack Overflow
• The Vertica Database Forums • View topic - System Table Metadata !! (desc)

select parameter_name, current_value, default_value, change_requires_restart from configuration_parameters where parameter_name in ('ActivePartitionCount', 'MergeOutInterval', 'MoveOutInterval', 'MoveOutMaxAgeTime', 'MoveOutSizePct');
    parameter_name    | current_value | default_value | change_requires_restart
----------------------+---------------+---------------+-------------------------
 ActivePartitionCount | 1             | 1             | f
 MergeOutInterval     | 600           | 600           | f
 MoveOutInterval      | 300           | 300           | f
 MoveOutMaxAgeTime    | 1800          | 1800          | f
 MoveOutSizePct       | 0             | 0             | f
(5 rows)