Thread: data/index file size info

data/index file size info

From
chris@skyout.net (Chris)
Date:
Is there a table that contains info about the data/index files of
a postgresql db, such as filename, bytesize, etc??  I'm looking for
something similar to oracle's DBA_DATA_FILES view...

Thanks,
--
Chris de Villiers
chris AT skyout DOT net
http://skyout.net

Re: data/index file size info

From
Bruce Momjian
Date:
Chris wrote:
> Is there a table that contains info about the data/index files of
> a postgresql db, such as filename, bytesize, etc??  I'm looking for
> something similar to oracle's DBA_DATA_FILES view...

See the documentation on database sizing:

    http://developer.postgresql.org/docs/postgres/diskusage.html

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073