# SQLの実行時間は以下のどれが正しいのでしょうか? 以下の3つでそれぞれ速度値が異なる。どれが正しいのでしょうか? - 158.8ms `performance_schema.events_statements_summary_by_digest` - 191ms コンソール出力 - 141.7ms スロークエリーのログ ## performance_schema.events_statements_summary_by_digest ```sql SELECT DIGEST_TEXT, COUNT_STAR, MIN_TIMER_WAIT, AVG_TIMER_WAIT, MAX_TIMER_WAIT FROM performance_schema.events_statements_summary_by_digest; ``` | DIGEST_TEXT | COUNT_STAR | MIN_TIMER_WAIT|AVG_TIMER_WAIT|MAX_TIMER_WAIT | -------- | -------- | -------- | -------- | -------- |SELECT * FROM `salaries` | 1 |15886781000 |15886781000 |15886781000 ## コンソール出力 ```bash employees> SELECT * FROM salaries [2021-03-02 21:46:39] 500 rows retrieved starting from 1 in 191 ms (execution: 28 ms, fetching: 163 ms) ``` ## スロークエリーのログ ```log # Time: 2021-03-02T12:46:39.054380Z # User@Host: root[root] @ [172.17.0.1] Id: 2 # Query_time: 0.014172 Lock_time: 0.012786 Rows_sent: 501 Rows_examined: 501 use employees; SET timestamp=1614689199; /* ApplicationName=IntelliJ IDEA 2020.3.2 */ SELECT * FROM salaries; ```
×
Sign in
Email
Password
Forgot password
or
By clicking below, you agree to our
terms of service
.
Sign in via Facebook
Sign in via Twitter
Sign in via GitHub
Sign in via Dropbox
Sign in with Wallet
Wallet (
)
Connect another wallet
New to HackMD?
Sign up