Database space used

[Sarah Butash]

Hello DSpace Community,

I've been asked to report the amount of space used for our DSpace data.  I can report the size of the volume allocated for the database, but this doesn't give me the actual data used space.  We are on DSpace 5.10 on a linux server.

If you have any helpful hints, it would be great if you could share.

Have a great day!

Sarah

--

Sarah Butash

she / her

Library Systems Analyst, OU Libraries

Kresge Library, Room 227

100 Library Drive, Rochester, MI  48309-4479

Phone: 248-370-2368

[Michael Plate]

Hi Sarah,

Am 22.03.22 um 13:05 schrieb Sarah Butash:

> Hello DSpace Community,
>
> I've been asked to report the amount of space used for our DSpace data.
> I can report the size of the volume allocated for the database, but this
> doesn't give me the actual data used space.  We are on DSpace 5.10 on a
> linux server.
>
> If you have any helpful hints, it would be great if you could share.

log into the database via psql and do this query, assuming the name of
your database is 'dspace':


select pg_size_pretty(pg_database_size('dspace'));


Michael

[Mark H. Wood]

On Tue, Mar 22, 2022 at 08:05:13AM -0400, Sarah Butash wrote:
> I've been asked to report the amount of space used for our DSpace data. I
> can report the size of the volume allocated for the database, but this
> doesn't give me the actual data used space. We are on DSpace 5.10 on a
> linux server.

https://makandracards.com/makandra/37935-postgresql-show-size-of-all-databases

gives a query that will show you the sizes of *all* databases in the
cluster. It shouldn't be too hard to alter it to select just the
database you want, and to report in other units.

--
Mark H. Wood
Lead Technology Analyst

University Library
Indiana University - Purdue University Indianapolis
755 W. Michigan Street
Indianapolis, IN 46202
317-274-0749
www.ulib.iupui.edu

[Sean Carte]

Hi Sarah

If you also need the size of the assetstore directory, this should do it:

du -sh /assetstore/

But check your dspace.cfg that that is the correct directory.

Sean

--
All messages to this mailing list should adhere to the Code of Conduct: https://www.lyrasis.org/about/Pages/Code-of-Conduct.aspx
---
You received this message because you are subscribed to the Google Groups "DSpace Technical Support" group.
To unsubscribe from this group and stop receiving emails from it, send an email to dspace-tech...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/dspace-tech/YjsKsHViqcr3VYaG%40IUPUI.Edu.