Resource utilization statistics are stored in tables in Teradata SQL Engine. You can access these tables by using Teradata Studio or DBQL.
Table Name | Description |
---|---|
td_coprocessor_db.QueryLog | Contains query level statistics by global Teradata Vantage ID. |
td_coprocessor_db.ResUsageNetwork | Contains system level statistics for Teradata ML Engine network usage. |
td_coprocessor_db.ResUsageCpu | Contains system level statistics for Teradata ML Engine CPU usage. |
td_coprocessor_db.ResUsageDisk | This table is created but currently does not contain data. |
td_coprocessor_db.ResUsageMemory | Contains system level statistics for Teradata ML Engine disk usage. |
For more information, see System Monitoring.
The IOWaitTimewriteNanoSecs and IOWaittimeReadNanoSecs columns in the ResUsageNetwork table is zeroed out due to a known limitation.
If system monitoring is disabled, the following tables are empty:
- td_coprocessor_db.ResUsageNetwork
- td_coprocessor_db.ResUsageCpu
- td_coprocessor_db.ResUsageMemory
- td_coprocessor_db.ResUsageDisk