The Trino Utilization dashboard shows your recent and historical use of Trino resources. You can use the dashboard to determine if you risk exceeding your monthly plan limits. The Trino Utilization page is available upon request for most customers.
Since July 2025, Presto Utilization Dashboard is renamed to Trino Utilization Dashboard.
Log into the Treasure Data Console as an owner or an administrator.
Select Control Panel > Utilization.
Open Trino Utilization.
The dashboard includes the following charts:
The Trino Query Details table at the bottom of the dashboard, shows per-query usage data. Use the table to target your top-consuming, unusually resource-intensive queries.
You can then work to optimize resource usage. Consider whether these queries can be run less frequently or modified to process less data. Or perhaps you can identify inefficient operations like unnecessary sorting or unnecessary columns.
The Trino Query Details table includes the following columns:
| Column | Description |
|---|---|
| Month | The month and year that the query ran. |
| Query Signature | It offers a “query hash” to identify unique ad hoc, script, or Treasure Workflow-based queries. |
| Last Month Total Split Hours | The total number of split-hours this query consumed last month. |
| Current Month Split Hours | This query consumed the total number of split hours up to the present day this month. |
| Current Month Total Executions | The total number of times that this query or query signature ran up to the present day this month. |
| Average Split Hours Per Run | The average number of split-hours consumed per run of that query. |
| Median Query Duration in Minutes | Median duration, in minutes, the query takes to complete. |
| Number of Jobs over Allotted Memory | The number of times this query hit the account’s maximum per-query memory limit, regardless of whether the job succeeded or failed. |
| Maximum Memory Used in MB | This field is for a query that exceeds the maximum memory limit per query for the account. It shows the maximum amount of memory consumed when the query ended. If the query ends with an error, more memory might be required than what is displayed. |
| Last Job ID | The most recent Treasure Data Job ID runs from this query. This is helpful if you want to learn more about the query in question, which is from an external system. No Treasure Data Saved Query ID exists, but you can use the most recent (last executed) Job ID. |
| Term | Description |
|---|---|
| Splits | Sections of a larger data set, including tables and intermediate data, during query processing. A split is a unit of query processing in Trino. Trino creates a distributed query execution plan consisting of several divisions. As you process more data and more query stages, the number of divisions will increase: A split is useful for SLA critical, such as separating development and production environments or dividing up resources between multiple teams. |
| Anytime Splits | The total number of splits that can be processed at any moment. |
| Splits Hours | Refers to the time required to process splits. |
| Trino Query Signatures | For queries that don’t have a name, the query signature is a concise representation that summarizes the operations performed by the query. The notation used for query signatures is described in Trino Query Signatures. |
Also, understanding Trino concepts and terminology is useful when assessing metrics presented in the dashboard.
| Chart | Description |
|---|---|
| Your Current Trino Units | The total number of Trino units assigned to your account based on your minimum price plan. |
| Maximum Anytime Split Limit | The total number of split resources you can use at a given moment. Calculated as Trino Units × 300 Anytime Splits. |
| Monthly Split Hour Limit | The total number of split hours your account can use within one month. Calculated as Trino Units × 15,000 Split-Hrs. |
| Maximum Query Memory Limit | The maximum total memory that can be used on a per-query basis, based on your price plan. |
| Additional Trino Units Needed | Additional Trino units required to support split hours beyond your limit or the memory needed for top memory-consuming queries. Calculated as Trino Units × 1 Hr. |
| This Month’s and Last Month’s Split Hours | Pink Line: Cumulative split-hour usage within the month (successful jobs only). Blue Line: Daily split-hour usage within the month. Red Line: Maximum allowed split-hour usage based on the price plan. |
| Monthly Total Trino Jobs Ran | The number of Trino jobs run each month over the past 12 months. |
| Total Trino Hours | The number of Trino split-hours consumed each month over the past 12 months. |
| Monthly Over Memory Jobs | The number of jobs that exceeded your account’s max memory limit. |