Monitoring and System Objects #

The following commands can be used to get information about the system state. Each of the commands below has an equivalent function for convenience.

SHOW METRICS – get the essential system information for monitoring.

SHOW CONFIG – get the configuration settings.

SHOW STATE – get system state information.

SHOW USERS – show all users defined in the system.

SHOW BACKENDS – show created and active backend workers in the system.

SHOW REPLICAS – get a list of the status of replica servers.

SHOW REPLICATION – get the replication status.

SHOW WAL – get information about WAL.

SHOW SCHEMAS – show schema objects created in the system.

SHOW TABLES – show tables created in the system.