The tables below provide insight into queries compiled and executed. See also: timing
sys.querylog_catalog
name | type | references | description |
---|---|---|---|
"id" | OID | The internal query identifier. | |
"owner" | VARCHAR | sys.users.name | The user defining it. |
"defined" | TIMESTAMP | Time when the query was added to the catalog. | |
"query" | CLOB | The complete SQL query statement. | |
"pipe" | CLOB | sys.optimizers.name | The MAL optimizer pipeline. |
"plan" | CLOB | The MAL execution plan. | |
"mal" | INTEGER | Size of MAL plan | |
"optimize" | BIGINT | Optimization time in micro-seconds. |
sys.querylog_calls
name | type | references | description |
---|---|---|---|
"id" | OID | sys.querylog_catalog.id | Reference to the querylog definition. |
"start" | TIMESTAMP | Time the statement was started. | |
"stop" | TIMESTAMP | Time the statement was completely finished. | |
"arguments" | CLOB | The actual call structure. | |
"tuples" | BIGINT | The number of tuples in the result set | |
"run" | BIGINT | The time spent (in usec) until the result export. | |
"ship" | BIGINT | The time spent (in usec) to ship the result set. | |
"cpu" | INTEGER | The average cpu load percentage during execution. | |
"io" | INTEGER | The percentage time waiting for IO to finish. |
sys.queyrlog_history
name | type | references | description |
---|---|---|---|
"id" | OID | sys.querylog_catalog.id | Reference to the querylog definition. |
"owner" | VARCHAR | sys.users.name | The user defining it. |
"defined" | TIMESTAMP | Time when the query was added to the catalog. | |
"query" | CLOB | The complete SQL query statement. | |
"pipe" | CLOB | sys.optimizers.name | The MAL optimizer pipeline. |
"plan" | CLOB | The MAL execution plan. | |
"mal" | INTEGER | Size of MAL plan | |
"optimize" | BIGINT | Optimization time in micro-seconds. | |
"start" | TIMESTAMP | Time the statement was started. | |
"stop" | TIMESTAMP | Time the statement was completely finished. | |
"arguments" | CLOB | The actual call structure. | |
"tuples" | BIGINT | The number of tuples in the result set | |
"run" | BIGINT | The time spent (in usec) until the result export. | |
"ship" | BIGINT | The time spent (in usec) to ship the result set. | |
"cpu" | INTEGER | The average cpu load percentage during execution. | |
"io" | INTEGER | The percentage time waiting for IO to finish. |
sys.queue
name | type | references | description |
---|---|---|---|
"tag" | BIGINT | Unique internal query call identifier. | |
"sessionid" | INTEGER | sys.sessions.sessionid | The internal session identifier. |
"username" | VARCHAR | sys.users.name | The name of the user responsible for the call. |
"started" | TIMESTAMP | The date and time the query was started. | |
"status" | VARCHAR | running or finished or paused. | |
"query" | CLOB | The SQL query itself. | |
"finished" | TIMESTAMP | The date and time the query finished, else null. | |
"workers" | INTEGER | The number of worker threads based on history. | |
"memory" | INTEGER | The amount of memory used in MB based on history. |
The sys.queue structure has been enhanced from release Jun2020 (11.37.7) onwards. Older versions will show less and some different columns.