SQL to display percent free space in Greenplum

posted Dec 9, 2013, 7:01 AM 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