Varada has open-sourced its Workload Analyzer for Presto, including both Trino (formerly known as PrestoSQL) and PrestoDB, making the source code available to everyone via Github.

The Workload Analyzer offers visibility into how Big Data and analytics workloads are performing, offering users insights into how to improve performance and optimize resources.

The tool collects details and metrics on every query, aggregates and extracts information, and delivers dozens of charts describing all the facets of cluster performance. For the first time, data engineers have a holistic view of their cluster and can drill down into pain points to determine what queries to optimize and how.

The Workload Analyzer is compatible with PrestoDB and Trino. The Workload Analyzer script runs safely within the Presto cluster in the user’s Virtual Private Cloud (VPC), collecting and analyzing query statistics (JSONs). No data leaves the cluster and the tool does not require any external resources.

According to the company, the Workload Analyzer has already been tested on dozens of massive scale production clusters, resulting in zero impact on query performance.