Asset size includes the size of db entry for the Asset, too.  Things like url, title, lineage, etc.

If you want to start at a certain point, you'll need to consider the Asset's lineage entry. 

--- (Edited on 2/19/2008 4:06 pm [GMT-0600] by colink) ---

Hello. My query is returning PDFs that are in a uncommitted version tag. Is there a way to filter them out?

select distinct assetData.url, assetData.menutitle as myfilename, round(assetData.assetSize/1024) as mykB, FROM_UNIXTIME(assetData.revisionDate, '%c/%e/%Y %l:%i %p') as mydate
from asset
inner join FileAsset on asset.assetId = FileAsset.assetId
inner join assetData on asset.assetId = assetData.assetId
where left(asset.lineage,length(?)) = ?
and assetData.url like '%.pdf'
and asset.className = 'WebGUI::Asset::File'
and FileAsset.filename like '%.pdf'
and assetData.groupIdView = 7
and asset.state = 'published'
and
  assetData.revisionDate =
    (SELECT
      MAX(maxassetData.revisionDate)
     FROM assetData as maxassetData
     WHERE assetData.assetId=maxassetData.assetId)
order by assetData.menutitle

--- (Edited on 3/13/2008 10:13 pm [GMT-0500] by elnino) ---