How to view underlying query of a discover report
Hello, I am wondering if there is a way to view the underlying SQL query of a discover report? I am not finding the performance dialog in the bottom right of my screen.
Laura Lopez you will need to turn on benchmarking to see the query. Here's a screenshot of where to turn it on:
After enabling it you will see this on the bottom right side of your discovery screen:
Be aware that setting Benchmark logging on can impact the runtime performance of your Pyramid Server and recommended best practice is to only switch it on to troubleshoot problems, then when resolved, switch it off. If you have Admin privileges you can view the transaction log directly in the Admin Console. If not, you could ask your admin to get it for you.
Hope that helps!
Thank you for the help. Another question I had was how I could manually go into the queries and edit them as this method only allows me to view and copy the query.
You cannot. The Pyramid "Pyrana" SQL query engine uses advanced and sophisticated techniques to "shard and stitch" its generated SQL to deliver the analytic view the user has defined through their actions. Depending on what you have asked the query to deliver, this may result in many individual SQL queries being generated, submitted to the underlying DB in parallel, then the results post processed to create the requested output. It is not amenable to user editing...