Drop files here

SQL upload ( 0 ) x -

Page-related settings Click on the bar to scroll to top of page
Press Ctrl+Enter to execute query Press Enter to execute query
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse Expand Show trace Hide trace Count : Time taken :
Bookmarks
Refresh
Add
No bookmarks
Add bookmark
Options
Set default





Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database : Queried time :
Browse mode
Customize browse mode.
Browse mode
Documentation Use only icons, only text or both. Restore default value
Documentation Use only icons, only text or both. Restore default value
Documentation Whether a user should be displayed a "show all (rows)" button. Restore default value
Documentation Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next" links will be shown. Restore default value
Documentation SMART - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise. Restore default value
Documentation Highlight row pointed by the mouse cursor. Restore default value
Documentation Highlight selected rows. Restore default value
Documentation Restore default value
Documentation Restore default value
Documentation Repeat the headers every X cells, 0 deactivates this feature. Restore default value
Documentation Maximum number of characters shown in any non-numeric column on browse view. Restore default value
Documentation These are Edit, Copy and Delete links. Restore default value
Documentation Whether to show row links even in the absence of a unique key. Restore default value
Documentation Default sort order for tables with a primary key. Restore default value
Documentation When browsing tables, the sorting of each table is remembered. Restore default value
Documentation For display Options Restore default value
SELECT * FROM `events_statements_summary_by_program`
Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
OBJECT_TYPE
Object type for which the summary is generated.
OBJECT_SCHEMA
The schema of the object for which the summary is …
OBJECT_NAME
The name of the object for which the summary is ge…
COUNT_STAR
The number of summarized events (from events_state…
SUM_TIMER_WAIT
The total wait time of the summarized timed events…
MIN_TIMER_WAIT
The minimum wait time of the summarized timed even…
AVG_TIMER_WAIT
The average wait time of the summarized timed even…
MAX_TIMER_WAIT
The maximum wait time of the summarized timed even…
COUNT_STATEMENTS
Total number of nested statements invoked during s…
SUM_STATEMENTS_WAIT
The total wait time of the summarized timed statem…
MIN_STATEMENTS_WAIT
The minimum wait time of the summarized timed stat…
AVG_STATEMENTS_WAIT
The average wait time of the summarized timed stat…
MAX_STATEMENTS_WAIT
The maximum wait time of the summarized timed stat…
SUM_LOCK_TIME
The total time spent (in picoseconds) waiting for …
SUM_ERRORS
The total number of errors that occurend for the s…
SUM_WARNINGS
The total number of warnings that occurend for the…
SUM_ROWS_AFFECTED
The total number of affected rows by the summarize…
SUM_ROWS_SENT
The total number of rows returned by the summarize…
SUM_ROWS_EXAMINED
The total number of rows examined by the summarize…
SUM_CREATED_TMP_DISK_TABLES
The total number of on-disk temporary tables creat…
SUM_CREATED_TMP_TABLES
The total number of in-memory temporary tables cre…
SUM_SELECT_FULL_JOIN
The total number of full joins executed by the sum…
SUM_SELECT_FULL_RANGE_JOIN
The total number of range search joins executed by…
SUM_SELECT_RANGE
The total number of joins that used ranges on the …
SUM_SELECT_RANGE_CHECK
The total number of joins that check for key usage…
SUM_SELECT_SCAN
The total number of joins that did a full scan of …
SUM_SORT_MERGE_PASSES
The total number of merge passes that the sort alg…
SUM_SORT_RANGE
The total number of sorts that were done using ran…
SUM_SORT_ROWS
The total number of sorted rows that were sorted b…
SUM_SORT_SCAN
The total number of sorts that were done by scanni…
SUM_NO_INDEX_USED
The total number of statements that performed a ta…
SUM_NO_GOOD_INDEX_USED
The total number of statements where no good index…
Query results operations Create view Create view
Bookmark this SQL query Bookmark this SQL query