https://bugzilla.novell.com/show_bug.cgi?id=726206 https://bugzilla.novell.com/show_bug.cgi?id=726206#c10 --- Comment #10 from Christian Boltz <suse-beta@cboltz.de> 2011-11-27 14:16:04 CET --- select resourcetable.id as res_id, resourcetable.name as resourcename , parttable.name, count(parttable.name), round(avg(parttable.datasize)) as datasize_avg, round(sum(parttable.datasize)/1024/1024) as datasize_sum_MB from parttable,pimitemtable, collectiontable, resourcetable where pimitemtable.collectionid=collectiontable.id and parttable.pimitemid=pimitemtable.id and parttable.name like 'PLD%' and collectiontable.resourceId = resourcetable.id group by parttable.name, collectiontable.resourceId; +--------+---------------------------------+--------------+-----------------------+--------------+-----------------+ | res_id | resourcename | name | count(parttable.name) | datasize_avg | datasize_sum_MB | +--------+---------------------------------+--------------+-----------------------+--------------+-----------------+ | 6 | akonadi_mixedmaildir_resource_0 | PLD:ENVELOPE | 339848 | 355 | 115 | | 7 | akonadi_maildir_resource_1 | PLD:ENVELOPE | 171 | 327 | 0 | | 6 | akonadi_mixedmaildir_resource_0 | PLD:HEAD | 339848 | 3149 | 1021 | | 7 | akonadi_maildir_resource_1 | PLD:HEAD | 171 | 14 | 0 | | 6 | akonadi_mixedmaildir_resource_0 | PLD:RFC822 | 32689 | 10897 | 340 | | 7 | akonadi_maildir_resource_1 | PLD:RFC822 | 165 | 169 | 0 | | 26 | akonadi_contacts_resource_0 | PLD:RFC822 | 114 | 0 | 0 | +--------+---------------------------------+--------------+-----------------------+--------------+-----------------+ This is not really surprising - nearly all data belongs to my mixedmaildir. -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.