These views list normalized statements that have used temporary tables. By default, rows are sorted by descending number of on-disk temporary tables used and descending number of in-memory temporary tables used.
views have these columns:
The normalized statement string.
The default database for the statement, or
NULLif there is none.
The total number of times the statement has executed.
The total wait time of timed occurrences of the statement.
The total number of internal in-memory temporary tables created by occurrences of the statement.
The total number of internal on-disk temporary tables created by occurrences of the statement.
The average number of internal temporary tables created per occurrence of the statement.
The percentage of internal in-memory temporary tables that were converted to on-disk tables.
The time at which the statement was first seen.
The time at which the statement was most recently seen.
The statement digest.