From: Andrew Gierth <andrew@tao11.riddles.org.uk>
To: Horst =?utf-8?Q?D=C3=BCster?= <horst.duester@sourcepole.ch>
Cc: pgsql-admin@lists.postgresql.org
Subject: Re: Calculation of db size
In-Reply-To: <3d17ce68-70b6-677c-311e-b05b5195ba35@sourcepole.ch> ("Horst
	\=\?utf-8\?Q\?D\=C3\=BCster\=22's\?\= message of "Mon,
 21 Jan 2019 15:09:24 +0100")
Message-ID: <87fttm3xlm.fsf@news-spur.riddles.org.uk>
References: <3d17ce68-70b6-677c-311e-b05b5195ba35@sourcepole.ch>
User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/25.1 (berkeley-unix)
Date: Mon, 21 Jan 2019 14:22:27 +0000
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable
Precedence: bulk

>>>>> "Horst" =3D=3D Horst D=C3=BCster <horst.duester@sourcepole.ch> writes:

 Horst> Then I have a subsequent question.

 Horst> Does the query

 Horst> SELECT g_database_size('dbname');

 Horst> take into account the storage space of the table pg_shdepend or
 Horst> not?

It does not. Nor does it include the other global tables, such as
pg_database, pg_authid, etc. To get the list of global tables and their
indexes, use:

select relname from pg_class where relisshared;=20=20

The size of the global tables and indexes, which don't count towards the
size of any individual database, can be obtained with
pg_tablespace_size('pg_global'). (All global tables must be in the
pg_global tablespace, and no other tables are allowed there.)

--=20
Andrew (irc:RhodiumToad)