SQL to display percent free space in Greenplum

Post date: Dec 09, 2013 3:1:15 PM

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;