ERP

Development #321

Updated by Patryk Szymański 14 days ago

lista endpointów ponetcjalnych do opytmalizacji 

 SELECT  
     endpoint, 
     COUNT(*) AS requests_count, 
     MAX(execution_time) AS max_execution_time, 
     endpoint,count(*), max(execution_time), AVG(execution_time) AS avg_execution_time, 
     MAX(start_time) AS last_start_time 
 FROM request_log 
 WHERE start_time >= '2026-07-23' 
 GROUP BY `request_log`  
 group by endpoint 
   
 HAVING AVG(execution_time) > 10 count(*)>5 
 ORDER BY avg_execution_time `AVG(execution_time)`    DESC;

Back