How to get SQLs for queries?

For debugging purposes of query slowness, SQLs are required to check query performance.

In OpenSpecimen, it can be achieved easily by following the below steps.

  1. Log in as a super admin.

  2. Click on Queries card → Query Audit button → List view of queries.

  3. Click on user/unsaved query.

  4. The pop-up will come up, which will display a SQL query.