Archives of the TeradataForum

Message Posted: Mon, 14 Mar 2011 @ 13:53:37 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi Anomy,

depends if you have query logging or accounting activated. If querylogging, it would be something like:

     select cast(collecttimestamp as date) as DAT, username,
     sum(totaliocount)(decimal(18,0)) as IO,
     sum(totalcputime)(decimal(18,0)) as CPU
     from dbc.qrylog
     where DAT between '2010-01-01' and '2010-12-31'
     group by 1,2
     ;

Or you can use table DBC.ACCTG if you use accounting. AFAIK, CPU and IOs for aborted queries do not appear in QRYLOG table and you can find them in ACCTG.

It is up to you to see if your DBQL tables (originally in DBC) are not historized into some other, user-defined table.

Hope this helps.

Regards,

Tomas

	<Prev	Next>		<<First	<Prev	Next>	Last>>