Changes between Initial Version and Version 1 of drmsAscertainSpace

Timestamp:

03/25/14 12:44:56 (10 years ago)

Author:

niles

Comment:

--

drmsAscertainSpace

@@ +1 @@
+
+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)
+
+