Information Schema PROFILING Table
The Information Schema PROFILING table contains information about statement resource usage. Profiling information is only recorded if the profiling session variable is set to 1.
It contains the following columns:
| Column Name | Description |
|---|---|
QUERY_ID | Query_ID. |
SEQ | Sequence number showing the display order for rows with the same QUERY_ID. |
STATE | Profiling state. |
DURATION | Time in seconds that the statement has been in the current state. |
CPU_USER | User CPU usage in seconds. |
CPU_SYSTEM | System CPU usage in seconds. |
CONTEXT_VOLUNTARY | Number of voluntary context switches. |
CONTEXT_INVOLUNTARY | Number of involuntary context switches. |
BLOCK_OPS_IN | Number of block input operations. |
BLOCK_OPS_OUT | Number of block output operations. |
MESSAGES_SENT | Number of communications sent. |
MESSAGES_RECEIVED | Number of communications received. |
PAGE_FAULTS_MAJOR | Number of major page faults. |
PAGE_FAULTS_MINOR | Number of minor page faults. |
SWAPS | Number of swaps. |
SOURCE_FUNCTION | Function in the source code executed by the profiled state. |
SOURCE_FILE | File in the source code executed by the profiled state. |
SOURCE_LINE | Line in the source code executed by the profiled state. |
It contains similar information to the SHOW PROFILE and SHOW PROFILES statements.
Profiling is enabled per session. When a session ends, its profiling information is lost.
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
