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; |
Greenplum DBA FAQ >
Greenplum DBA FAQ >
SQL to display percent free space in Greenplumposted Dec 9, 2013, 7:01 AM by Sachchida Ojha
|