viewing tablespace and filespace information in greenplum

posted Apr 28, 2017, 4:19 PM 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