gpsscli list

A newer version of this documentation is available. Use the version menu above to view the most up-to-date release of the Greenplum 6.x documentation.

gpsscli list

List Greenplum Stream Server jobs and status.


gpsscli list [--all]
     [--gpss-host host] [--gpss-port port]
     [-l | --log-dir directory] [-v | --verbose]

gpsscli list {-h | --help}


The gpsscli list command lists the running jobs serviced by a specific Greenplum Stream Server (GPSS) instance. You can request that the command list all jobs regardless of state.

gpsscli list displays the job identifier and status, as well as the Greenplum Database master host, port, database, schema, and table.

If the GPSS instance to which you want to send the request is not running on the default host ( or the default port number (5000), you can specify the GPSS host and/or port via command line options.


Show information for all jobs regardless of state.
--gpss-host host
Specify the GPSS host. The default host address is
--gpss-port port
Specify the GPSS port number. The default port number is 5000.
-l | --log-dir directory
Specify the directory to which GPSS writes client command log files. GPSS must have write permission to the directory. GPSS creates the log directory if it does not exist.
If you do not provide this option, GPSS writes gpsscli client log files to the $HOME/gpAdminLogs directory.
-v | --verbose
The default behaviour of the command utility is to display information and error messages to stdout. When you specify the --verbose option, GPSS also outputs debug-level messages about the operation.
-h | --help
Show command utility help, and then exit.


List all Greenplum Stream Server jobs:

$ gpsscli list --all

See Also

gpss, gpsscli submit