System information

This section summarizes commands that are available to Database Admins and Database Monitors roles to explore usage, track operations and investigate ingestion failures.

• .show queries - displays information on completed and running queries.
• .show commands - displays information on completed commands and their resources utilization.
• .show commands-and-queries - displays information on completed commands and queries, and their resources utilization.
• .show journal - displays history of the metadata operations.
• .show operations - displays administrative operations both running and completed, since Admin node was last elected.
• .show failed ingestions - displays information on failures encountered during data ingestion to the cluster.
• .show table data statistics - displays table data statistics per column.