dba_resusageSummary
Summarize Teradata system usage metrics by weekday and hour, filtering by workload type, complexity, user, or application ID.
Instructions
Get the Teradata system usage summary metrics by weekday and hour for each workload type and query complexity bucket.
Arguments:
dimensions - list of dimensions to aggregate the resource usage summary. All dimensions are: ["LogDate", "hourOfDay", "dayOfWeek", "workloadType", "workloadComplexity", "UserName", "AppId"]
user_name - user name
date - Date to analyze, formatted as YYYY-MM-DD
dayOfWeek - day of the week to analyze
hourOfDay - hour of day to analyze
workloadType - workload type to analyze, example: 'LOAD', 'ETL/ELT', 'EXPORT', 'QUERY', 'ADMIN', 'OTHER'
workloadComplexity - workload complexity to analyze, example: 'Ingest & Prep', 'Answers', 'System/Procedural'
AppId - Application ID to analyze, example: 'TPTLOAD%', 'TPTUPD%', 'FASTLOAD%', 'MULTLOAD%', 'EXECUTOR%', 'JDBC%'
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| dimensions | No | ||
| user_name | No | ||
| date | No | ||
| dayOfWeek | No | ||
| hourOfDay | No | ||
| workloadType | No | ||
| workloadComplexity | No | ||
| AppId | No |