How to monitor greenplum segment disk space

Gp_toolkit Administrative schema:the Greenplum Database includes the Gp_toolkit Schema, which collects system information Through log files and operating system commands. Can run a query against the Gp_toolkit to quickly view free disk space. Results are shown in bytes.

[Gpadmin@mdw ~]$ psql-d zwcdb-u zhongwc-h 192.168.1.23-w

Password for user zhongwc:

Psql (8.2.15)

Type ' help ' for help.

zwcdb=# Select Dfhostname, Dfspace,dfdevice from Gp_toolkit.gp_disk_free order by Dfhostname;

Dfhostname |  Dfspace | Dfdevice

------------+----------+------------

SDW1 |  51692604 | /dev/sdb1

SDW2 |  51692588 | /dev/sdb1

(2 rows)

[Gpadmin@mdw config]$ gpssh-f seg_hosts df-th

[SDW1] FileSystem Type Size Used avail use% mounted on

[SDW1]/dev/mapper/volgroup00-logvol00

[SDW1] ext3 54G 3.7G 47G 8%/

[SDW1]/dev/sda1 ext3 104M 14M 85M 14%/boot

[SDW1] Tmpfs tmpfs 1.1G 0 1.1G 0%/dev/shm

[SDW1]/dev/sdb1 xfs 54G 727M 53G 2%/data

[SDW2] FileSystem Type Size Used avail use% mounted on

[SDW2]/dev/mapper/volgroup00-logvol00

[SDW2] ext3 54G 3.7G 47G 8%/

[SDW2]/dev/sda1 ext3 104M 14M 85M 14%/boot

[SDW2] Tmpfs tmpfs 1.1G 0 1.1G 0%/dev/shm

[SDW2]/dev/sdb1 xfs 54G 727M 53G 2%/data

See more highlights of this column: http://www.bianceng.cnhttp://www.bianceng.cn/database/storage/