Ascertaining how much disk space a series uses

The first thing to do is to go into the SUMS database and build a temporary table (lasts only for the current session) with storage information :

create temporary table space_used as ( select sum(bytes) as bytes, owning_series from sum_main group by owning_series );

The resulting table looks something like this :

bytes | owning_series

---

2293889467054 | hmi.m_45s 2551641062389 | hmi.v_45s 2604818885633 | hmi.s_720s

34888439851665 | aia.lev1

The creation of this table can take a while.

Then we need to do a sum through that table of storage for series name(s) that match what we want (and convert to GB) - for instance :

select sum(bytes)/1024/1024/1024 as HMI_GB from space_used where owning_series like 'hmi%';

hmi_gb

---

51440.777539771982

(1 row)

select sum(bytes)/1024/1024/1024 as AIA_GB from space_used where owning_series like 'aia%';

aia_gb

---

47510.095782309771

(1 row)