如何查看表空间？

xiaozai193

如题，谢谢各位解答，不甚感激

smallfish_xy

参考我博客：http://hi.baidu.com/smallfish_xy ... 0ccb36b80e2d8f.html

SELECT spcname FROM pg_tablespace;

下流砥柱

\db

aaaaa5aa

查看表空间使用情况的SQL语句：
   SELECT a.tablespace_name "表空间名",total 表空间大小,free 表空间剩余大小,
(total-free) 表空间使用大小,
ROUND((total-free)/total,4)*100 "使用率 %"
FROM  (SELECT tablespace_name,SUM(bytes) free FROM DBA_FREE_SPACE
GROUP BY tablespace_name ) a,
(SELECT tablespace_name,SUM(bytes) total FROM DBA_DATA_FILES
GROUP BY tablespace_name) b
WHERE a.tablespace_name=b.tablespace_name

epstar

楼上说的是Oracle的

Name Return Type Description
pg_column_size(any) int Number of bytes used to store a particular value (possibly compressed)
pg_database_size(oid)  bigint Disk space used by the database with the specified OID
pg_database_size(name)  bigint Disk space used by the database with the specified name
pg_relation_size(relation regclass, fork text)  bigint Disk space used by the specified fork ('main', 'fsm' or 'vm') of the table or index with the specified OID or name  
pg_relation_size(relation regclass)  bigint Shorthand for pg_relation_size(..., 'main')  
pg_size_pretty(bigint)  text Converts a size in bytes into a human-readable format with size units
pg_tablespace_size(oid)  bigint Disk space used by the tablespace with the specified OID
pg_tablespace_size(name)  bigint Disk space used by the tablespace with the specified name
pg_total_relation_size(regclass)  bigint Total disk space used by the table with the specified OID or name, including indexes and TOAST data