I need to extract the metadata for the query executions for the last month in Teradata for a given database.
For example, how much MB is the most performance expensive query ran, what is the average query cost in MB, and such.
Is this information even available, and If it is, which table holds it?
P.S. I'm using Teradata Vantage express for testing purposes on a virtual Linux machine, if that makes any difference.
I've been searching in the official documentation. Spend there a good amount of time, but find it pretty hard to find this information.
I see some people are using 'ResUsageSPMA_hst' table, which seems to be missing on my end.