Postgres Pro
Downloads
Home   >   mailing lists

How do I measure user disk usage on Postgresql table? - Mailing list pgsql-general

From Dave
Subject How do I measure user disk usage on Postgresql table?
Date
Msg-id 4cef5$48062fe8$453dce02$4149@FUSE.NET
Whole thread Raw
Responses Re: How do I measure user disk usage on Postgresql table?  (Richard Huxton <dev@archonet.com>)
List pgsql-general
Tree view
Lets say I have a Postgresql table where I store uploaded data for all users, identified by user_id column. Is it possible to run a query to measure the storage a user is consuming?

Ideally this would be a SELECT query with WHERE clause on user_id and will only return size of the data field(s), rather then the overhead.

Any other ideas?
 
Thanks

pgsql-general by date:

Previous
From: wasenbr
Date:
Subject: How to retore a pg_dumpall dump?
Next
From: Michael Enke
Date:
Subject: Re: util/int8.h: missing int8_text() function