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
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.
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.
@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
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
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
@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 9 months ago Reply