profiling

The profiling view provides statement profiling information. 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.
SEQ	integer	Sequence number indicating the display order for rows with the same query_id value.
STATE	varchar(30)	Status of each analysis step.
DURATION	decimal(9,6)	Duration of statement execution in the given state, in seconds.
CPU_USER	decimal(9,6)	CPU usage of a user, in seconds.
CPU_SYSTEM	decimal(9,6)	CPU usage of the system, in seconds.
CONTEXT_VOLUNTARY	integer	Number of voluntary context switches.
CONTEXT_INVOLUNTARY	integer	Number of involuntary context switches.
BLOCK_OPS_IN	integer	Number of block input operations.
BLOCK_OPS_OUT	integer	Number of block output operations.
MESSAGES_SENT	integer	Number of communication messages sent.
MESSAGES_RECEIVED	integer	Number of communication messages received.
PAGE_FAULTS_MAJOR	integer	Number of major page faults.
PAGE_FAULTS_MINOR	integer	Number of minor page faults.
SWAPS	integer	Number of swaps.
SOURCE_FUNCTION	varchar(30)	Information indicating where in the source code the profiled state executes.
SOURCE_FILE	varchar(20)	Information indicating where in the source code the profiled state executes.
SOURCE_LINE	integer	Information indicating where in the source code the profiled state executes.