Not the answer you need?
Register and ask your own question!

qan window example option

Hi there,
In qan window, there is an option called example. If I click on it, it says no query example. what's the purpose of it? I found that EXPLAIN option is removed from PMM 1.0.4 to 1.0.5. Is there any option to check EXPLAIN plan in qan?

Comments

  • weberweber Advisor Inactive User Role Beginner
    Hello,

    When using perfschema as a query source, a real query example (EXAMPLE tab) is not available. Thus, we hid EXPLAIN plan in that case as we can't run explain not having a real example. It is available when using slowlog.

    However, in one of the next versions (probably 1.0.6) we are planning to add query examples for perfschema and EXPLAIN should be also available.
  • govindareddy20govindareddy20 Contributor Current User Role Beginner
    could you please tell us when the new version will be available? Just out of curiosity.
  • weberweber Advisor Inactive User Role Beginner
    In a week or two.
  • govindareddy20govindareddy20 Contributor Current User Role Beginner
    Thank you Weber for your quick response. Appreciate it.
This discussion has been closed.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.