Global management
Checking system health
The following query returns an Empty
response or an error code depending on the status of the database:
SYSCTL REPORT STATUS
If you receive an error code, we recommend you to connect to the host and check logs. If the server has crashed, you may need to recover the database.
Inspecting all spaces
The single DDL query that lets you do a "sneak peek" into the status of the entire system is the INSPECT GLOBAL
query. It
returns a JSON string like this:
{
"spaces:"["space1", "space2"],
"users":["root", "staging_server"],
"settings:{},
}
spaces
: lists all the spaces in the systemusers
: lists all usersAccess control noteThis is only returned if you are the
root
user. Standard users cannot see the other users in the systemsettings
: returns system settings (currently an empty dictionary is returned)