The PROFILING
table provides
statement profiling information. Its contents correspond to the
information produced by the SHOW
PROFILES
and SHOW PROFILE
statements (see Section 12.4.5.32, “SHOW PROFILES
Syntax”). The table is
empty unless the profiling
session variable is set to 1.
INFORMATION_SCHEMA Name | SHOW Name | Remarks |
---|---|---|
QUERY_ID | Query_ID | |
SEQ |
| |
STATE | Status | |
DURATION | Duration | |
CPU_USER | CPU_user | |
CPU_SYSTEM | CPU_system | |
CONTEXT_VOLUNTARY | Context_voluntary | |
CONTEXT_INVOLUNTARY | Context_involuntary | |
BLOCK_OPS_IN | Block_ops_in | |
BLOCK_OPS_OUT | Block_ops_out | |
MESSAGES_SENT | Messages_sent | |
MESSAGES_RECEIVED | Messages_received | |
PAGE_FAULTS_MAJOR | Page_faults_major | |
PAGE_FAULTS_MINOR | Page_faults_minor | |
SWAPS | Swaps | |
SOURCE_FUNCTION | Source_function | |
SOURCE_FILE | Source_file | |
SOURCE_LINE | Source_line |
Notes:
QUERY_ID
is a numeric statement identifier.SEQ
is a sequence number indicating the display order for rows with the sameQUERY_ID
value.STATE
is the profiling state to which the row measurements apply.DURATION
indicates how long statement execution remained in the given state, in seconds.CPU_USER
andCPU_SYSTEM
indicate user and system CPU use, in seconds.CONTEXT_VOLUNTARY
andCONTEXT_INVOLUNTARY
indicate how many voluntary and involuntary context switches occurred.BLOCK_OPS_IN
andBLOCK_OPS_OUT
indicate the number of block input and output operations.MESSAGES_SENT
andMESSAGES_RECEIVED
indicate the number of communication messages sent and received.PAGE_FAULTS_MAJOR
andPAGE_FAULTS_MINOR
indicate the number of major and minor page faults.SWAPS
indicates how many swaps occurred.SOURCE_FUNCTION
,SOURCE_FILE
, andSOURCE_LINE
provide information indicating where in the source code the profiled state executes.