This article is half-done without your Comment! *** Please share your thoughts via Comment ***
In this post, I am sharing two different scripts to check the full size of Greenplum DCA.
To monitor the disk space is a ubiquitous task of DBA. DBA can use below script and can automate the report on disk size notification/alert.
There are different options to check the disk size of the server; below I prepared two queries using gpperfmon database and gp_toolkit schema.
Use gpperfmon Database:
1 2 3 4 5 6 7 8 9 |
select hostname ,filesystem ,round(total_bytes/power(1024,4)::numeric,2) as TotalSize_inTB ,round(bytes_used/power(1024,4)::numeric,2) as UsedSize_inTB ,round(bytes_available/power(1024,4)::numeric,2) as AvailableSize_inTB from diskspace_now where filesystem in ('/data1','/data2') ORDER BY 4 DESC |
Use gp_toolkit Schema:
1 2 3 4 5 |
select distinct dfhostname ,dfdevice ,dfspace from gp_toolkit.gp_disk_free |
Leave a Reply