sql-statement-show-profiles.md

title	summary	aliases
SHOW PROFILES	An overview of the usage of SHOW PROFILES for the TiDB database.	/docs/dev/sql-statements/sql-statement-show-profiles/

SHOW PROFILES

The SHOW PROFILES statement currently only returns an empty result.

Synopsis

ShowProfilesStmt ::=
    "SHOW" "PROFILES" ShowLikeOrWhere?

ShowLikeOrWhere ::=
    "LIKE" SimpleExpr
|   "WHERE" Expression

Examples

SHOW PROFILES;

Empty set (0.00 sec)

MySQL compatibility

This statement is included only for compatibility with MySQL. Executing SHOW PROFILES always returns an empty result.

As an alternative, TiDB provides statement summary tables to help understand SQL performance issues.