hawq state

Shows the status of a running HAWQ system.


hawq state [-b] [-l log_directory] [-v | -q] 
          [-d master_data_directory] [--hawqhome]
hawq state -? | -h | --help


The hawq state utility displays information about a running HAWQ instance. A HAWQ system is comprised of multiple PostgreSQL database instances (segments) spanning multiple machines, and the hawq state utility can provide additional status information, such as:

  • Total segment count.
  • Which segments are down.
  • Master and segment configuration information (hosts, data directories, etc.).
  • The ports used by the system.
  • Whether a standby master is present, and if it is active.


-b (brief status)
Optional. Display a brief summary of the state of the HAWQ system. This is the default option.

-d master_data_directory –datadir=MASTER_DIR
Status of the master data directory. If not specified, the value set for $MASTER_DATA_DIRECTORY will be used.

Display details of the designated home data directory.

-l logfile_directory
Displays calls to the log file. Defaults to ~/hawq/AdminLogs.

-q (no screen output)
Optional. Run in quiet mode. Except for warning messages, command output is not displayed on the screen. However, this information is still written to the log file.

-v (verbose output)
Optional. Displays error messages and outputs detailed status and progress information.

-? | -h | –help (help)
Displays the online help.


Show brief status information of a HAWQ system:

hawq state -b

See Also

hawq start, gplogfilter