Do an EXPLAIN for each query and figure out which queries are not supported by index or sequence scans

[provokateurin]

How to use GitHub

• Please use the 👍 reaction to show that you are interested into the same feature.
• Please don't comment if you have no relevant information to add. It's just extra noise for everyone subscribed to this issue.
• Subscribe to receive notifications on status change and new comments.

---

Feature request

Which Nextcloud Version are you currently using: (see administration page)

Is your feature request related to a problem? Please describe.
Currently it's not trivial to figure out how well a query is supported by indices or sequences. This either requires using PMM, validating the query manually or extract it and running EXPLAIN on it manually.

Describe the solution you'd like
The profiler should allow doing this automatically and ideally also parse the results so queries without indices or sequences can be shown as problematic without any manual work.

[sorbaugh]

After short alignment with @Altahrim, It's possible to tell MySQLi to report queries not using indices

https://www.php.net/manual/en/mysqli.constants.php#constant.mysqli-report-index

[nickvergessen]

At least from my attempts back then on prod, certain tables will be logged there even if their is an index, as the db is faster sometimes simply loading the whole table into ram

[provokateurin]

It's possible to tell MySQLi to report queries not using indices

We shouldn't have a solution that only works for certain DB types.