db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Fabian Merki" <fabian2...@merkisoft.ch>
Subject Re: a command to show table file-size?
Date Wed, 13 Jun 2007 09:40:50 GMT
why do you need a programm for this???

select tablename,
(select sum(numallocatedpages*pagesize) from new
org.apache.derby.diag.SpaceTable('APP',t.tablename) x),
 (select sum(estimspacesaving) from new
org.apache.derby.diag.SpaceTable('APP',t.tablename) x) from SYS.SYSTABLES t

could be improved but works and is very simple!

cheers
fabian


----- Original Message ----- 
From: "Kristian Waagan" <Kristian.Waagan@Sun.COM>
To: "Derby Discussion" <derby-user@db.apache.org>
Sent: Wednesday, June 13, 2007 11:18 AM
Subject: Re: a command to show table file-size?


> Stanley Bradbury wrote:
> > Geoff hendrey wrote:
> >> Is there a utility or command that I can use to
> >> identify the disk space (bytes) occupied by a
> >> particular table?
> >>
> >>
> >>
> >>
> > The query listed at the link below can be used to determine the filename
> > for a table or tables in a database.  You can then check the size
> > directly or feed the results into a routine that reports the size.
>
> Another option is to use DerbyDiskSpaceDiag.java attached to the
> following Jira:
> https://issues.apache.org/jira/browse/DERBY-2549
>
> It is not polished, but shows you the space of tables and indexes.
>
>
> hth,
> -- 
> Kristian
>
> >
> >
http://www.ibm.com/developerworks/db2/library/techarticle/dm-0408bradbury/#cs_map_filename
> >
> >
> > Note that this query requires the user function bigintToHexString be
> > created.  This is documented in the section just above the one pointed
> > to by the URL provided.
> >
> > Hope this helps.
> >
> >
>


Mime
View raw message