Long-running queries cause resource contention

warning

Resource ContentionUpdated Jul 8, 2025(via Exa)

Sources

10 Must-Have SQL Queries to Monitor Trino: Unlocking Insights from the trino_events.trino_queries | by Vivek Jain | Mediummedium.com

Technologies:

Trinosubject

How to detect:

Queries with excessive duration (measured as end_time - create_time) hog cluster resources

Recommended action:

Identify longest-running queries using SQL against trino_events.trino_queries. Analyze query execution plans, optimize inefficient SQL patterns, and investigate large data scans.