show

Shows information about the cluster and its objects. Every form ends with the elapsed time.

Syntax and results

show tables;                        the tables, with owner, lock status and datacenter
show datacenters;                   the datacenters
show version;                       version, build number and build date of the broker
show license;                       license type, maximum number of data brokers, expiration date
show cluster;                       lock status, maximum and running data brokers, license end date
show server;                        the broker you are connected to
show servers;                       the SQL brokers: name, status, address, port, cores, backup directory
show databrokers;                   the data brokers
show masterbrokers;                 the master brokers
show connections;                   the connected users: name, group, address
show users;                         the users
show grants for USER;               the privileges of a user
show backups for TABLE;             the backups of a table

Example

> show tables;
Name                            Owner                           Locked Datacenter
------------------------------- ------------------------------- ------ ---------
gaia_source                     system                          no     DC1
single_cell                     system                          no     DC1

Notes

• show cluster prints the cluster id only to administrators.
• show runningservers is what the clients use to learn the brokers of the cluster: its answer is meant for programs.
• The older word list was removed: use show.