All pastes #966115 Raw Edit

Stuff

public text v1 · immutable
·published 2008-04-01 14:30 UTC
rendered paste body
SQL> select identifier, round(filesize/1024/1024,0) as mb from tgeg_mailbox order by identifier;

IDENTIFIER                 MB
------------------ ----------
000000000003540749          4
000000000003540789          3
000000000003540913          3
000000000003543713          0
000000000003543717          0
000000000003543732          0
000000000003543748          0
000000000003543763          0
000000000003543813          0

9 rows selected.


SQL> select identifier, count(*) from tgeg_data group by identifier order by identifier;

IDENTIFIER           COUNT(*)
------------------ ----------
000000000001058824          1
000000000002028159          1
000000000002077816          1
000000000002077825          1
000000000002077837          1
000000000002077852          1
000000000002077867          1
000000000002123759          1
000000000002123802          1
000000000002123816          1
000000000002123834          1
000000000002123849          1
000000000002126949          1
000000000002126956          1
000000000002126968          1
000000000002126980          1
000000000002126992          1
000000000002127626          1
000000000002127638          1
000000000002127650          1
000000000002127662          1
000000000002127674          1
000000000002183694          1
000000000002183722          1
000000000002184055          1
000000000002184280          1
000000000002184532          1
000000000002184538          1
000000000002184543          1
000000000002184550          1
000000000002184558          1
000000000002184801          1
000000000002184807          1
000000000002184816          1
000000000002184822          1
000000000002184831          1
000000000002184860          1
000000000002184866          1
000000000002184871          1
000000000002184881          1
000000000002184887          1
000000000002184916          1
000000000002184922          1
000000000002184931          1
000000000002184939          1
000000000002184947          1
000000000002185124          1
000000000002185129          1
000000000002185137          1
000000000002185142          1
000000000002185147          1
000000000002188932          1
000000000002189148          1
000000000002190152          1
000000000002377419          1
000000000002552695          1
000000000002757805          1
000000000003524624          1
000000000003525217          1
000000000003525448          1
000000000003525451          1
000000000003525453          1
000000000003525454          1
000000000003525456          1
000000000003525459          1
000000000003525467          1
000000000003525474          1
000000000003525477          1
000000000003525480          1
000000000003525513          1
000000000003525541          1
000000000003525543          1
000000000003525545          1
000000000003525546          1
000000000003525548          1
000000000003525552          1
000000000003525558          1
000000000003526966          1
000000000003527463        149
000000000003527468          1
000000000003527474          1
000000000003527482          1
000000000003527489          1
000000000003527496          1
000000000003527509          1
000000000003527516          1
000000000003527523          1
000000000003527530          1
000000000003527537          1
000000000003527587          1
000000000003527594          1
000000000003527601          1
000000000003527608          1
000000000003527615          1
000000000003527665          1
000000000003527672          1
000000000003527679          1
000000000003527743          1
000000000003527810          1
000000000003527817          1
000000000003527824          1
000000000003528681          1
000000000003532647          1
000000000003540695          4
000000000003540699          4
000000000003540705          4
000000000003540708          4
000000000003540711          4
000000000003540739          1
000000000003540757          1
000000000003540797          1
000000000003540921          1
000000000003541244          1
000000000003543713          1
000000000003543904          1
000000000003543907          1
000000000003543940          1
000000000003543943          1

118 rows selected.