girish
05/10/2023, 1:18 PMJohn Speno
05/10/2023, 1:42 PMSELECT
ROUND(SUM(blocks * blocks_size) / (1024 * 1024 * 1024), 2) AS a_total_disk_space_gb,
ROUND(SUM((blocks - blocks_free - blocks_available) * blocks_size) / (1024 * 1024 * 1024), 2) AS b_total_all_gb
FROM mounts;
girish
05/10/2023, 2:24 PMJohn Speno
05/10/2023, 2:30 PMdz
05/10/2023, 10:13 PM