Hi ,
How we can check the execution time of a query on service center. Is it only log for slow queries? or for every query. Because I am not able to find the logs for normal query. I need to check how much time it has taken to execute a query.
Thanks
Hi @Lovish Goyal
Please go through the below Link:
https://www.outsystems.com/forums/discussion/52841/question-on-query-time-on-service-center-general-logs/
Md Mansur
Hi @Lovish Goyal,
Have you checked this link for log message:
https://success.outsystems.com/support/troubleshooting/application_runtime/slowsql_log_messages/
or you can use LogMessage server action before or after your SQL to log time and check in service center.
Hope this helps you!!!
Regards,
Rajat
Service Center logs are for SQL queries that are slow, specifically those exceeding the 200 ms threshold. You can configure this threshold using the Factory Configuration. Please see if you can change this to a lower value to include execution time of all the queries ( temporary solution )
@Siya ,
Thanks for the reply!
I have changed the value to 20 and with different values but not able to catch the time less than 200ms. Just today I have changed it, Will it take time to reflect?
As you can see these settings might not be applied immediately. You need to apply the configuration.