{"Entry":{"collection":"func","key":"pg-tablespace-size","name":"pg_tablespace_size","aliases":[],"metadata":{"changed_in":[],"changes":[{"descriptions_changed":false,"doc_overhaul":false,"from":"8.0","group_changed":null,"signatures":{"added":[],"removed":[]},"status":"added","to":"8.1"},{"descriptions_changed":false,"doc_overhaul":true,"from":"12","group_changed":null,"signatures":{"added":[],"removed":[]},"status":"changed","to":"13"},{"descriptions_changed":true,"doc_overhaul":false,"from":"14","group_changed":null,"signatures":{"added":[],"removed":[]},"status":"changed","to":"15"},{"descriptions_changed":true,"doc_overhaul":false,"from":"18","group_changed":null,"signatures":{"added":[],"removed":[]},"status":"changed","to":"19"}],"content_hash":"f0d7f26ee2ce80a839d8f0a43666fb0a3e4baee670355aaa759cbb94b9b2a365","first_version":"8.1","group":"admin","group_label":"System Administration Functions","groups":["admin"],"imported_at":"2026-09-27T17:57:29.684901+08:00","last_version":"20","name":"pg_tablespace_size","name_key":"pg_tablespace_size","position":29106,"present_in":["8.1","8.2","8.3","8.4","9.0","9.1","9.2","9.3","9.4","9.5","9.6","10","11","12","13","14","15","16","17","18","19","20"],"signature":"pg_tablespace_size ( name ) → bigint","signature_count":2,"slug":"pg-tablespace-size","source_rev":"b7bd9cda","summary":"Computes the total disk space used in the tablespace with the specified name or OID.","summary_zh":""}},"Definition":{"Collection":"func","Key":"pg-tablespace-size","SourceDatabase":"center","Version":"18","SourceTable":"func","SourceKey":"pg-tablespace-size","SourceRevision":"b7bd9cda","Facts":{"description":"Computes the total disk space used in the tablespace with the specified name or OID. To use this function, you must have CREATE privilege on the specified tablespace or have privileges of the pg_read_all_stats role, unless it is the default tablespace for the current database.","description_html":"Computes the total disk space used in the tablespace with the specified name or OID. To use this function, you must have \u003ccode class=\"literal\"\u003eCREATE\u003c/code\u003e privilege on the specified tablespace or have privileges of the \u003ccode class=\"literal\"\u003epg_read_all_stats\u003c/code\u003e role, unless it is the default tablespace for the current database.","description_zh":"","description_zh_html":"","doc":{"anchor":"FUNCTIONS-ADMIN-DBSIZE","file":"functions-admin.html","slug":"18"},"group":"admin","group_label":"System Administration Functions","lang":"en","layout":"table-new","pages":["functions-admin.html"],"prose_only":false,"signatures":[{"description":"Computes the total disk space used in the tablespace with the specified name or OID. To use this function, you must have CREATE privilege on the specified tablespace or have privileges of the pg_read_all_stats role, unless it is the default tablespace for the current database.","description_html":"Computes the total disk space used in the tablespace with the specified name or OID. To use this function, you must have \u003ccode class=\"literal\"\u003eCREATE\u003c/code\u003e privilege on the specified tablespace or have privileges of the \u003ccode class=\"literal\"\u003epg_read_all_stats\u003c/code\u003e role, unless it is the default tablespace for the current database.","description_zh":"","description_zh_html":"","examples":[],"html":"\u003ccode class=\"function\"\u003epg_tablespace_size\u003c/code\u003e ( \u003ccode class=\"type\"\u003ename\u003c/code\u003e ) → \u003ccode class=\"returnvalue\"\u003ebigint\u003c/code\u003e","returns":"bigint","text":"pg_tablespace_size ( name ) → bigint","zh_from":""},{"description":"Computes the total disk space used in the tablespace with the specified name or OID. To use this function, you must have CREATE privilege on the specified tablespace or have privileges of the pg_read_all_stats role, unless it is the default tablespace for the current database.","description_html":"Computes the total disk space used in the tablespace with the specified name or OID. To use this function, you must have \u003ccode class=\"literal\"\u003eCREATE\u003c/code\u003e privilege on the specified tablespace or have privileges of the \u003ccode class=\"literal\"\u003epg_read_all_stats\u003c/code\u003e role, unless it is the default tablespace for the current database.","description_zh":"","description_zh_html":"","examples":[],"html":"\u003ccode class=\"function\"\u003epg_tablespace_size\u003c/code\u003e ( \u003ccode class=\"type\"\u003eoid\u003c/code\u003e ) → \u003ccode class=\"returnvalue\"\u003ebigint\u003c/code\u003e","returns":"bigint","text":"pg_tablespace_size ( oid ) → bigint","zh_from":""}],"zh_from":""},"ManualEvidence":{"doc":{"anchor":"FUNCTIONS-ADMIN-DBSIZE","file":"functions-admin.html","slug":"18"}},"MeasuredEvidence":{}},"Text":{"Collection":"func","Key":"pg-tablespace-size","SourceDatabase":"pgweb","Version":"18","Locale":"zh-Hans","Title":"pg_tablespace_size","Summary":"计算具有指定名称或OID的表空间中使用的总磁盘空间。要使用此函数，您必须对指定的表空间具有CREATE权限，或者具有pg_read_all_stats角色的权限，除非它是当前数据库的默认表空间。","BodyHTML":"计算具有指定名称或OID的表空间中使用的总磁盘空间。要使用此函数，您必须对指定的表空间具有\u003ccode\u003eCREATE\u003c/code\u003e权限，或者具有\u003ccode\u003epg_read_all_stats\u003c/code\u003e角色的权限，除非它是当前数据库的默认表空间。\u003cpre\u003epg_tablespace_size ( name ) → bigint\u003c/pre\u003e计算具有指定名称或OID的表空间中使用的总磁盘空间。要使用此函数，您必须对指定的表空间具有\u003ccode\u003eCREATE\u003c/code\u003e权限，或者具有\u003ccode\u003epg_read_all_stats\u003c/code\u003e角色的权限，除非它是当前数据库的默认表空间。\u003cpre\u003epg_tablespace_size ( oid ) → bigint\u003c/pre\u003e计算具有指定名称或OID的表空间中使用的总磁盘空间。要使用此函数，您必须对指定的表空间具有\u003ccode\u003eCREATE\u003c/code\u003e权限，或者具有\u003ccode\u003epg_read_all_stats\u003c/code\u003e角色的权限，除非它是当前数据库的默认表空间。","SourceRevision":"1b5ca64c","ContentHash":"f400bfabf444d99321e022721207f0cd54bf79d4ce83d395dae83847f8903d5a","Payload":{"description_zh":"计算具有指定名称或OID的表空间中使用的总磁盘空间。要使用此函数，您必须对指定的表空间具有CREATE权限，或者具有pg_read_all_stats角色的权限，除非它是当前数据库的默认表空间。","description_zh_html":"计算具有指定名称或OID的表空间中使用的总磁盘空间。要使用此函数，您必须对指定的表空间具有\u003ccode class=\"literal\"\u003eCREATE\u003c/code\u003e权限，或者具有\u003ccode class=\"literal\"\u003epg_read_all_stats\u003c/code\u003e角色的权限，除非它是当前数据库的默认表空间。","signatures":[{"description_zh":"计算具有指定名称或OID的表空间中使用的总磁盘空间。要使用此函数，您必须对指定的表空间具有CREATE权限，或者具有pg_read_all_stats角色的权限，除非它是当前数据库的默认表空间。","description_zh_html":"计算具有指定名称或OID的表空间中使用的总磁盘空间。要使用此函数，您必须对指定的表空间具有\u003ccode class=\"literal\"\u003eCREATE\u003c/code\u003e权限，或者具有\u003ccode class=\"literal\"\u003epg_read_all_stats\u003c/code\u003e角色的权限，除非它是当前数据库的默认表空间。","returns":"bigint","text":"pg_tablespace_size ( name ) → bigint","zh_from":"doc"},{"description_zh":"计算具有指定名称或OID的表空间中使用的总磁盘空间。要使用此函数，您必须对指定的表空间具有CREATE权限，或者具有pg_read_all_stats角色的权限，除非它是当前数据库的默认表空间。","description_zh_html":"计算具有指定名称或OID的表空间中使用的总磁盘空间。要使用此函数，您必须对指定的表空间具有\u003ccode class=\"literal\"\u003eCREATE\u003c/code\u003e权限，或者具有\u003ccode class=\"literal\"\u003epg_read_all_stats\u003c/code\u003e角色的权限，除非它是当前数据库的默认表空间。","returns":"bigint","text":"pg_tablespace_size ( oid ) → bigint","zh_from":"doc"}],"zh_from":"doc"}},"RequestedLocale":"zh-Hans","Fallback":false,"Versions":["10","11","12","13","14","15","16","17","18","19","20","8.1","8.2","8.3","8.4","9.0","9.1","9.2","9.3","9.4","9.5","9.6"],"Locales":["en","zh-Hans"],"Signatures":[{"Version":"18","Ordinal":0,"Hash":"29e4fa5c9503a2828a1821838db745c76f2ebbae7f9b271c536c281e06fde45d","Text":"pg_tablespace_size ( name ) → bigint","Returns":"bigint","Payload":{"description":"Computes the total disk space used in the tablespace with the specified name or OID. To use this function, you must have CREATE privilege on the specified tablespace or have privileges of the pg_read_all_stats role, unless it is the default tablespace for the current database.","description_html":"Computes the total disk space used in the tablespace with the specified name or OID. To use this function, you must have \u003ccode class=\"literal\"\u003eCREATE\u003c/code\u003e privilege on the specified tablespace or have privileges of the \u003ccode class=\"literal\"\u003epg_read_all_stats\u003c/code\u003e role, unless it is the default tablespace for the current database.","description_zh":"","description_zh_html":"","examples":[],"html":"\u003ccode class=\"function\"\u003epg_tablespace_size\u003c/code\u003e ( \u003ccode class=\"type\"\u003ename\u003c/code\u003e ) → \u003ccode class=\"returnvalue\"\u003ebigint\u003c/code\u003e","returns":"bigint","text":"pg_tablespace_size ( name ) → bigint","zh_from":""}},{"Version":"18","Ordinal":1,"Hash":"d1e3e445d07a2b09c6c6aaf32cda727a2b5bb00fa6b72a7072c87060c7dd0f5a","Text":"pg_tablespace_size ( oid ) → bigint","Returns":"bigint","Payload":{"description":"Computes the total disk space used in the tablespace with the specified name or OID. To use this function, you must have CREATE privilege on the specified tablespace or have privileges of the pg_read_all_stats role, unless it is the default tablespace for the current database.","description_html":"Computes the total disk space used in the tablespace with the specified name or OID. To use this function, you must have \u003ccode class=\"literal\"\u003eCREATE\u003c/code\u003e privilege on the specified tablespace or have privileges of the \u003ccode class=\"literal\"\u003epg_read_all_stats\u003c/code\u003e role, unless it is the default tablespace for the current database.","description_zh":"","description_zh_html":"","examples":[],"html":"\u003ccode class=\"function\"\u003epg_tablespace_size\u003c/code\u003e ( \u003ccode class=\"type\"\u003eoid\u003c/code\u003e ) → \u003ccode class=\"returnvalue\"\u003ebigint\u003c/code\u003e","returns":"bigint","text":"pg_tablespace_size ( oid ) → bigint","zh_from":""}}],"Spellings":null,"SQLState":null,"Evidence":null}