This article is half-done without your Comment! *** Please share your thoughts via Comment ***
In this post, I am sharing a script to check the Tablespace and Filespace information in Greenplum.
In a big database system, DBAs are creating different tablespaces for storage purpose so using below script we can get the information of tablespaces.
|
1 2 3 4 5 6 7 8 9 10 11 |
SELECT spcname as tblspc ,fsname as filespc ,fsedbid as seg_dbid ,fselocation as datadir FROM pg_tablespace pgts ,pg_filespace pgfs ,pg_filespace_entry pgfse WHERE pgts.spcfsoid=pgfse.fsefsoid AND pgfse.fsefsoid=pgfs.oid ORDER BY tblspc, seg_dbid |
