Earlier for debugging of a query slowness, the user/sysadmins was fetching the SQL to check query performance from the backend (database server).
In the latest OpenSpecimen, It is very easily possible from UI.
To achieve this follow below steps:
- Log in as a super admin.
- Click on Queries card → Query Audit button → List view of queries will be displayed.
- Click on the required user/unsaved query.
- The pop-up will come up which will contain the SQL query.
For more details refer to this wiki page: https://openspecimen.atlassian.net/wiki/x/GwDiGw