viewing tablespace and filespace information in greenplum

Post date: May 02, 2013 1:52:37 PM

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;