Query Abandonment Pattern Indicating Timeout or Client Issues
warningHigh rate of abandoned queries where clients disconnect before completion, potentially indicating query timeouts, impatient users, or client application crashes.
Monitor presto_execution_abandoned_queries_one_minute_rate relative to presto_execution_completed_queries_one_minute_rate. High abandonment ratio (>10%) suggests systematic issues. Check if abandonment correlates with high presto_execution_execution_time_one_minute_p95 or specific query patterns. Review client connection logs for patterns.
If correlated with long execution times, focus on query optimization to reduce latency. Implement query result caching for common queries. If client-side timeouts, increase client timeout settings. For user impatience, provide query progress indicators in client applications. Monitor for client application stability issues causing disconnections.