Skip to content

sql-statement-show-profiles.md

Latest commit

 

History

History
36 lines (25 loc) · 767 Bytes

sql-statement-show-profiles.md

File metadata and controls

36 lines (25 loc) · 767 Bytes
title SHOW PROFILES
summary An overview of the usage of SHOW PROFILES for the TiDB database.
aliases
/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.