gistfile1.txt

airflow-rwdb01:airflow> show profile for query 1;
+--------------------------------+-----------+
| Status                         | Duration  |
+--------------------------------+-----------+
| starting                       |  0.000043 |
| Waiting for query cache lock   |  0.000005 |
| Waiting on query cache mutex   |  0.000004 |
| checking query cache for query |  0.001387 |
| checking permissions           |  0.000006 |
| checking permissions           |  0.000004 |
| checking permissions           |  0.000006 |
| Opening tables                 |  0.000045 |
| System lock                    |  0.000063 |
| optimizing                     |  0.000008 |
| statistics                     |  0.000009 |
| preparing                      |  0.000053 |
| executing                      |  0.000006 |
| Sending data                   |  0.000326 |
| optimizing                     |  0.000007 |
| statistics                     |  0.000016 |
| preparing                      |  0.000021 |
| executing                      |  0.000007 |
| Sorting result                 |  0.000004 |
| Sending data                   |  0.000800 |
| Waiting for query cache lock   |  0.000006 |
| Waiting on query cache mutex   |  0.000004 |
| Sending data                   |  0.000556 |
| init                           |  0.000890 |
| optimizing                     |  0.000075 |
| statistics                     |  1.475286 |
| preparing                      |  0.000204 |
| Creating tmp table             |  0.000335 |
| executing                      |  0.000006 |
| Copying to tmp table           | 14.869062 |
| Sorting result                 |  0.000139 |
| Sending data                   |  0.000123 |
| end                            |  0.000006 |
| removing tmp table             |  0.000211 |
| end                            |  0.000007 |
| query end                      |  0.000007 |
| closing tables                 |  0.000005 |
| removing tmp table             |  0.000141 |
| closing tables                 |  0.000005 |
| removing tmp table             |  0.000020 |
| closing tables                 |  0.000012 |
| freeing items                  |  0.000087 |
| Waiting for query cache lock   |  0.000005 |
| Waiting on query cache mutex   |  0.000004 |
| freeing items                  |  0.000046 |
| Waiting for query cache lock   |  0.000004 |
| Waiting on query cache mutex   |  0.000003 |
| freeing items                  |  0.000003 |
| storing result in query cache  |  0.000006 |
| logging slow query             |  0.000003 |
| logging slow query             |  0.016907 |
| cleaning up                    |  0.000018 |
+--------------------------------+-----------+
52 rows in set (0.00 sec)