Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>   <<First <Prev

Subj:   Re: CPU and IO usage per user per day for a given
From:   Gorner, Tomas

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.



  <Prev Next>   <<First <Prev
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023