Skip to end of metadata
Go to start of metadata

Total number of statements

This query returns the number of statements that currently are established.

Statement information

This query returns the information about statements, sorted in descending order by the execution time .

Column Name

Description

SESSSION_ID

the unique identifier of the session

STMT_ID

the unique identifier of the statement in the session

TX_ID

the transaction identifier if the statement participates in a transaction

PREPARE_TIME

the time taken to perform preparing the statement. (microsecond)

FETCH_TIME

the time taken to perform a fetch operation (microsecond)

EXECUTE_TIME

the time taken to execute the statement (microsecond)

TOTAL_TIME

the total elapsed time

EXECUTE_FLAG

set 1 if the statement is currently executed

LAST_START_TIME

the time when the statement last started

QUERY

the query string

The number of currently running statements

This query returns the number of statements that are currently executing.

Information about currently running statements

This query returns the statement information about those that are currently executing.

Column Name

Description

SESSSION_ID

the unique identifier of the session

STMT_ID

the unique identifier of statement in the session

TX_ID

the transaction identifier if the statement participate in a transaction

PREPARE_TIME

the time taken to perform preparing the statement. (microsecond)

FETCH_TIME

the time taken to perform a fetch operation (microsecond)

EXECUTE_TIME

the time taken to execute the statement (microsecond)

TOTAL_TIME

the total elapsed time

EXECUTE_FLAG

set 1 if the statement is currently executed

LAST_START_TIME

the time when the statement last started

QUERY

the query string

Long running query ( over 10 seconds)

This query returns the statement information about queries that are considered long running. (the queries with elapsed time over 10 seconds)

Column Name

Description

SESSSION_ID

the unique identifier of the session

STMT_ID

the unique identifier of statement in the session

TX_ID

the transaction identifier if the statement participate in a transaction

PREPARE_TIME

the time taken to perform preparing statement. (microsecond)

FETCH_TIME

the time taken to perform a fetch operation (microsecond)

EXECUTE_TIME

the time taken to execute statement (microsecond)

TOTAL_TIME

the total elapsed time

EXECUTE_FLAG

set 1 if the statement is currently executed

LAST_START_TIME

the time when the statement last started

QUERY

the query string

Long running transaction's last statement information (over 1 minute)

In the case of long running transactions in ALTIBASE HDB, this query shows the information for the last query of a transaction with an elapsed time over 1 minute.

Column Name

Description

SESSSION_ID

the unique identifier of the session

CLIENT_IP

the client IP address

CLIENT_PID

the client process identifier

UTRANS_TIME

the time taken during the transaction. (microsecond)

EXECUTE_TIME

the time taken to execute statement (microsecond)

TOTAL_TIME

the total elapsed time

LAST_START_TIME

the time when the statement last started

QUERY

the query string

Information about a query running a FULL SCAN

This query shows the information about a query that is running a FULL SCAN. You need to be careful and check the SQL if there is a FULL SCAN plan node in the statement.

Column Name

Description

SESSSION_ID

the unique identifier of the session

CLIENT_IP

the client IP address

CLIENT_PID

the client process identifier

LAST_START_TIME

the time when the statement last started

PREPARE_TIME

the time taken to perform preparing statement. (microsecond)

FETCH_TIME

the time taken to perform a fetch operation (microsecond)

EXECUTE_TIME

the time taken to execute statement (microsecond)

TOTAL_TIME

the total elapsed time

QUERY

the query string

  • No labels