10

In PostgreSQL, EXPLAIN or EXPLAIN ANALYZE will show the estimate cost of executing a query. But EXPLAIN in MySQL doesn't provide this information. How can I get the estimate cost without installation of other tools? I'm using MySQL-5.6.16.

Community
  • 1
zli89
  • 907
  • 2
  • 11
  • 18

2 Answers2

10

In short

  1. Run your SELECT ... query
  2. SHOW STATUS LIKE 'last_query_cost'
  3. if the answer was 0 rerun the query with select SQL_NO_CACHE ... and do step 2 above again
Ruan Malan N
  • 311
  • 3
  • 3
5

There isn't much out there for MySQL except the following:

Read these carefully, see what you think ...

RolandoMySQLDBA
  • 182,700
  • 33
  • 317
  • 520
  • 1
    Also note that while query cost isn't returned in the basic EXPLAIN command, it is available if instead you use EXPLAIN FORMAT=JSON – Anarkopsykotik Jul 02 '19 at 12:53