EXA_SQL_MONTHLY

This system table contains the monthly aggregated number of executed SQL statements sorted by the interval start. Per interval several entries for each command type (for example, SELECT) is created. All users have access to the table.

Column Name	Description
`INTERVAL_START`	Timestamp at the start of the aggregation interval
`COMMAND_NAME`	Name of the statement (for example, `SELECT`, `COMMIT`, or `MERGE`)
`COMMAND_CLASS`	Class of statement (for example, `DQL`, `TRANSACTION`, or `DML`)
`SUCCESS`	Result of the statement: `TRUE`: Statement was executed successfully `FALSE`: Statement failed (for example, with a data exception)
`COUNT`	Number of executions
`DURATION_AVG`	Average execution time of statements in seconds
`DURATION_MAX`	Maximum execution time of statements in seconds
`CPU_AVG`	Average CPU utilization in percentage
`CPU_MAX`	Maximum CPU utilization in percentage
`TEMP_DB_RAM_PEAK_AVG`	Average usage of temporary DB memory of queries in MiB (cluster wide)
`TEMP_DB_RAM_PEAK_MAX`	Maximum usage of temporary DB memory of queries in MiB (cluster wide)
`PERSISTENT_DB_RAM_PEAK_AVG`	Average usage of modified, persistent DB memory of queries in MiB (cluster wide)
`PERSISTENT_DB_RAM_PEAK_MAX`	Maximum usage of modified, persistent DB memory of queries in MiB (cluster wide)
`HDD_READ_AVG`	Average hard disk read ratio in MiB per second (per node)
`HDD_READ_MAX`	Maximum hard disk read ratio in MiB per second (per node)
`HDD_WRITE_AVG`	Average hard disk write ratio in MiB per second (per node, `COMMIT` only)
`HDD_WRITE_MAX`	Maximum hard disk write ratio in MiB per second (per node, `COMMIT` only)
`NET_AVG`	Average network traffic ratio in MiB per second (per node)
`NET_MAX`	Maximum network traffic ratio in MiB per second (per node)
`ROW_COUNT_AVG`	Average number of result rows for queries, or number of affected rows for DML and DDL statements
`ROW_COUNT_MAX`	Maximum number of result rows for queries, or number of affected rows for DML and DDL statements
`EXECUTION_MODE`	The following execution modes are supported: `EXECUTE`: Normal execution of statements `PREPARE`: Prepared phase for prepared statements `CACHED`: Cached query results `PREPROCESS`: Execution of the Preprocessor script `CRASHED`: Marks the crashed queries (coredumps, segfaults, and so on)