Add configuration option to permit collection of more execution plans

follow
🛠 Planned
Anonymous

Currently DBMarlin appears to limit SQL execution plan collection to only the top 10 statements. Please add an option to collect more (or all!) execution plans

1 year ago

Activity
Mick Mcguinness changed status to 🛠 Planned

1 month ago

Mick Mcguinness

Good idea. How far down the list would you need to go? If we set explain top N too high that might become an overhead so probably need some safeguard built-in.

0    1 year ago    Reply

Comment must be at least 20 characters.
Cancel
Paulavicovan

Hi Mick, could there be maybe a feature to also be able to load an execution plan on demand? Besides the bulk load of top N? Like if we investigate a few sql statements related to one User even if they are not in top N we could load execution plan on demand for each instead of checking it in DB.

0    1 year ago    Reply

Comment must be at least 20 characters.
Cancel
Lennart Jonsson

@Paulavicovan: I also think this would be a good feature. On the fly be able to explain a particular statement, not necesarly keep the plan in DBmarlin

0    1 year ago    Reply

Comment must be at least 20 characters.
Cancel
7 votes
Mick Mcguinness Paulavicovan Michael McGoldrick Nigel Noble Andy Moors Lennart Jonsson Gabriele Donufrio
Categories
Enhancement
⚡️ by ProductLift