Size of database

Started by Carmen Waiover 23 years ago2 messagesgeneral

wai_carmen@hotmail.com

over 23 years ago

Hello:

How can I check the size of the database? When I go to the directory of
$PGDATA/base, I found lots of sub-directories (their names are as numbers).
How can I identify which directory is representing the corresponding
database?

Thanks!
Carmen

_________________________________________________________________
Join the world�s largest e-mail service with MSN Hotmail.
http://www.hotmail.com

Tom Lane

tgl@sss.pgh.pa.us

over 23 years ago

In reply to: Carmen Wai (#1)

Re: Size of database

"Carmen Wai" <wai_carmen@hotmail.com> writes:

How can I identify which directory is representing the corresponding
database?

"SELECT oid, datname FROM pg_database" will tell you.