viewing tablespace and filespace information in greenplum

posted May 2, 2013, 6:52 AM by Sachchida Ojha
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;
Comments