Hi Vassilis, since people seem reluctant to give you an answer on this one it might not be a good idea to rely on this feature - It may not work correctly or be gone in the next release. However you should (currently) get what you want using this query: select "schema", "table", sum("size") as size from storage() group by "schema","table" having "schema" <> 'tmp'; . This includes the system objects. kind regards holger On Jan 10, 2012, at 15:32 , Vassilis Papakonstantinou wrote:

What I mean is to get how much space is being used by each table in a database..

Vassilis

On 01/10/2012 02:08 PM, Vassilis Papakonstantinou wrote:

...

Hello,

Is there a way to get the disk space of a table?

Vassilis

------------------------------------------------------------------------------ Write once. Port to many. Get the SDK and tools to simplify cross-platform app development. Create new or port existing apps to sell to consumers worldwide. Explore the Intel AppUpSM program developer opportunity. appdeveloper.intel.com/join

http://p.sf.net/sfu/intel-appdev

_______________________________________________ MonetDB-users mailing list

MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users

------------------------------------------------------------------------------ Write once. Port to many. Get the SDK and tools to simplify cross-platform app development. Create new or port existing apps to sell to consumers worldwide. Explore the Intel AppUpSM program developer opportunity. appdeveloper.intel.com/join http://p.sf.net/sfu/intel-appdev____________________________________________... MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users

sys.#storage SEEMS to have what you want, but I haven't been able to figure out how to issue queries on any of the tables that start with '#'. sql>\d #storage CREATE TABLE "sys"."#storage" ( "schema" CHARACTER LARGE OBJECT, "table" CHARACTER LARGE OBJECT, "column" CHARACTER LARGE OBJECT, "location" CHARACTER LARGE OBJECT, "count" BIGINT, "capacity" BIGINT, "width" INTEGER, "size" BIGINT, "hashsize" BIGINT ); I found this last week when trying to figure out the location of columns. On Tue, Jan 10, 2012 at 8:32 AM, Vassilis Papakonstantinou < papv@ics.forth.gr> wrote:

** What I mean is to get how much space is being used by each table in a database..

Vassilis

On 01/10/2012 02:08 PM, Vassilis Papakonstantinou wrote:

Hello,

Is there a way to get the disk space of a table?

Vassilis

------------------------------------------------------------------------------ Write once. Port to many. Get the SDK and tools to simplify cross-platform app development. Create new or port existing apps to sell to consumers worldwide. Explore the Intel AppUpSM program developer opportunity. appdeveloper.intel.com/joinhttp://p.sf.net/sfu/intel-appdev _______________________________________________ MonetDB-users mailing listMonetDB-users@lists.sourceforge.nethttps://lists.sourceforge.net/lists/listinfo/monetdb-users

------------------------------------------------------------------------------ Write once. Port to many. Get the SDK and tools to simplify cross-platform app development. Create new or port existing apps to sell to consumers worldwide. Explore the Intel AppUpSM program developer opportunity. appdeveloper.intel.com/join http://p.sf.net/sfu/intel-appdev _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users