SQL to display percent free space in Greenplum

posted Apr 28, 2017, 3:48 PM by Sachchida Ojha

select

ctime,hostname,

filesystem,total_bytes,bytes_used,bytes_available,

(bytes_available::numeric/total_bytes::numeric*100.0)::numeric(4,2) as  pct_free from diskspace_now;

Comments