Updated on 2025-10-23 GMT+08:00

profiling

The profiling view provides statement profiling information. For details, see Table 1. This view is read-only. All users have the read permission on this view. In the current version, this view is not implemented, and all column values in the view are NULL.

Table 1 information_schema.profiling columns

Name

Type

Description

QUERY_ID

integer

Statement identifier. This column is not supported in the current version, and the value is NULL.

SEQ

integer

Sequence number indicating the display order for rows with the same query_id value. This column is not supported in the current version, and the value is NULL.

STATE

varchar(30)

Status of each analysis step. This column is not supported in the current version, and the value is NULL.

DURATION

decimal(9,6)

Duration of statement execution in the given state, in seconds. This column is not supported in the current version, and the value is NULL.

CPU_USER

decimal(9,6)

CPU usage of a user, in seconds. This column is not supported in the current version, and the value is NULL.

CPU_SYSTEM

decimal(9,6)

CPU usage of the system, in seconds. This column is not supported in the current version, and the value is NULL.

CONTEXT_VOLUNTARY

integer

Number of voluntary context switches. This column is not supported in the current version, and the value is NULL.

CONTEXT_INVOLUNTARY

integer

Number of involuntary context switches. This column is not supported in the current version, and the value is NULL.

BLOCK_OPS_IN

integer

Number of block input operations. This column is not supported in the current version, and the value is NULL.

BLOCK_OPS_OUT

integer

Number of block output operations. This column is not supported in the current version, and the value is NULL.

MESSAGES_SENT

integer

Number of communication messages sent. This column is not supported in the current version, and the value is NULL.

MESSAGES_RECEIVED

integer

Number of communication messages received. This column is not supported in the current version, and the value is NULL.

PAGE_FAULTS_MAJOR

integer

Number of major page faults. This column is not supported in the current version, and the value is NULL.

PAGE_FAULTS_MINOR

integer

Number of minor page faults. This column is not supported in the current version, and the value is NULL.

SWAPS

integer

Number of swaps. This column is not supported in the current version, and the value is NULL.

SOURCE_FUNCTION

varchar(30)

Information indicating where in the source code the profiled state executes. This column is not supported in the current version, and the value is NULL.

SOURCE_FILE

varchar(20)

Information indicating where in the source code the profiled state executes. This column is not supported in the current version, and the value is NULL.

SOURCE_LINE

integer

Information indicating where in the source code the profiled state executes. This column is not supported in the current version, and the value is NULL.