Guest User

Untitled

a guest
Aug 17th, 2021
77
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 2.49 KB | None | 0 0
  1. mysql> SELECT SEQ,STATE,DURATION,SOURCE_FUNCTION FROM INFORMATION_SCHEMA.PROFILING WHERE QUERY_ID=4;
  2. +-----+----------------------+------------+---------------------------+
  3. | SEQ | STATE                | DURATION   | SOURCE_FUNCTION           |
  4. +-----+----------------------+------------+---------------------------+
  5. |   2 | starting             |   0.000148 | NULL                      |
  6. |   3 | checking permissions |   0.000003 | check_access              |
  7. |   4 | checking permissions |   0.000001 | check_access              |
  8. |   5 | checking permissions |   0.000001 | check_access              |
  9. |   6 | checking permissions |   0.000003 | check_access              |
  10. |   7 | checking permissions |   0.000002 | check_access              |
  11. |   8 | checking permissions |   0.000003 | check_access              |
  12. |   9 | Opening tables       |   0.000160 | open_tables               |
  13. |  10 | init                 |   0.000076 | handle_query              |
  14. |  11 | System lock          |   0.000009 | mysql_lock_tables         |
  15. |  12 | optimizing           |   0.000019 | optimize                  |
  16. |  13 | statistics           |   0.000631 | optimize                  |
  17. |  14 | preparing            |   0.000048 | optimize                  |
  18. |  15 | Creating tmp table   |   0.000050 | create_intermediate_table |
  19. |  16 | Sorting result       |   0.000006 | make_tmp_tables_info      |
  20. |  17 | executing            |   0.000001 | exec                      |
  21. |  18 | Sending data         | 826.993521 | exec                      |
  22. |  19 | Creating sort index  |   0.050288 | sort_table                |
  23. |  20 | end                  |   0.000017 | handle_query              |
  24. |  21 | query end            |   0.000132 | mysql_execute_command     |
  25. |  22 | removing tmp table   |   0.000138 | free_tmp_table            |
  26. |  23 | query end            |   0.000011 | free_tmp_table            |
  27. |  24 | removing tmp table   |   0.000163 | free_tmp_table            |
  28. |  25 | query end            |   0.000004 | free_tmp_table            |
  29. |  26 | closing tables       |   0.000017 | mysql_execute_command     |
  30. |  27 | freeing items        |   0.000045 | mysql_parse               |
  31. |  28 | logging slow query   |   0.000002 | log_slow_do               |
  32. |  29 | logging slow query   |   0.000131 | log_slow_do               |
  33. |  30 | cleaning up          |   0.000067 | dispatch_command          |
  34. +-----+----------------------+------------+---------------------------+
  35. 29 rows in set, 1 warning (0.00 sec)
Advertisement
Add Comment
Please, Sign In to add comment