Open topic with navigation
Useful System Tables Related to Database Operation
The following NuoDB system tables are particularly helpful when monitoring database operation and troubleshooting problems. You can access these tables by executing the
SQL SELECT command as you would for any other table. Your current schema must be set to
SYSTEM or you must specify a fully-qualified name, as in
SYSTEM.CONNECTIONS, when doing the query.
|System Table Name||Description|
Information about all connections to the database that are open and may or may not be actively executing SQL.
|INDEXSTATISTICS||A view on what the optimizer uses in compiling the tables that changed. See INDEXSTATISTICS System Table Description.|
|LOCALCONNECTIONS||List of open connections for the transaction engine to which this SQL connection is connected. See LOCALCONNECTIONS System Table Description|
|LOCALSTATEMENTS||List of SQL statements that are in the current statement cache. See LOCALSTATEMENTS System Table Description.|
|NODES||Lists the current processes/nodes (TEs and SMs) that make up the database. See NODES System Table Description.|
This table is commonly referred to as the slow query log because it stores the slowest queries.