(In reply to Mayank Bansal from comment #8) > I am happy to give a profile using the profiler. What preset should I use? Or what threads I should add in the profiler UI to capture slow SQL or placesstuff in general? Thank you, I think we have all we need to fix this already. I must file a bug to improve our profiler story around queries execution, currently you can check the "ignore selected elements and register all threads" option in about:profiling, and that will also show sqldb threads, but they don't report the executed query.... we can really do better there.
Bug 1927173 Comment 9 Edit History
Note: The actual edited comment in the bug view page will always show the original commenter’s name and original timestamp.
(In reply to Mayank Bansal from comment #8) > I am happy to give a profile using the profiler. What preset should I use? Or what threads I should add in the profiler UI to capture slow SQL or placesstuff in general? Thank you, I think we have all we need to fix this already. I must file a bug to improve our profiler story around queries execution, currently you can check the "ignore selected elements and register all threads" option in about:profiling, and that will also show sqldb threads, but they don't report the executed query.... we can really do better there (fwiw it looks like the StepStatement call shows the query in the stack)