dba_resusageSummary
Analyze Teradata system resource usage by weekday, hour, workload type, and query complexity. Aggregate metrics using dimensions like user name, date, dayOfWeek, and hourOfDay for detailed insights.
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", "StatementType"]
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
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| date | No | ||
| dayOfWeek | No | ||
| dimensions | No | ||
| hourOfDay | No | ||
| user_name | No |
Input Schema (JSON Schema)
{
"properties": {
"date": {
"anyOf": [
{
"type": "string"
},
{
"type": "null"
}
],
"default": null,
"title": "Date"
},
"dayOfWeek": {
"anyOf": [
{
"type": "string"
},
{
"type": "null"
}
],
"default": null,
"title": "Dayofweek"
},
"dimensions": {
"anyOf": [
{
"items": {
"type": "string"
},
"type": "array"
},
{
"type": "null"
}
],
"default": null,
"title": "Dimensions"
},
"hourOfDay": {
"anyOf": [
{
"type": "string"
},
{
"type": "null"
}
],
"default": null,
"title": "Hourofday"
},
"user_name": {
"anyOf": [
{
"type": "string"
},
{
"type": "null"
}
],
"default": null,
"title": "User Name"
}
},
"title": "handle_dba_resusageSummaryArguments",
"type": "object"
}