ERP

lista endpointów ponetcjalnych do opytmalizacji

SELECT
endpoint,
COUNT(*) AS requests_count,
MAX(execution_time) AS 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 endpoint
HAVING AVG(execution_time) > 10
ORDER BY avg_execution_time DESC;