Unsupported Screen Size: The viewport size is too small for the theme to render properly.

(Feature Request) Slow Query Log Analyzer: Apply Filters

forums forums Monyog Monyog: Bugs / Feature Requests (Feature Request) Slow Query Log Analyzer: Apply Filters

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • #11993

      I would like to apply filters to the slow query log analyzer. Especially when log_queries_not_using_indexes is turned on there are a lot of false positives (queries on empty or very small tables for example). I suggest:

      “””

      Discard entries where:

      – total execution time <= .. ms – average execution time <= .. ms – maximum execution time <= ... ms – user = … – rows sent <= ... – rows examined <= ... – count <= – query occurence <= ...% Filters are concatenated with a logical OR. “””

    • #30933
      peterlaursen
      Participant

      Currently the design is that you can do this after CSV export (in a spreadsheet for instance).   But we will discuss such filtering options in the interface itself. 

      But please do not expect any update for the first 1-2 weeks. 

Viewing 1 reply thread
  • You must be logged in to reply to this topic.