table disk space usage query?

Поиск
Список
Период
Сортировка
От lawpoop@gmail.com
Тема table disk space usage query?
Дата
Msg-id 1183051891.044658.38930@q69g2000hsb.googlegroups.com
обсуждение исходный текст
Ответы Re: table disk space usage query?  (Dimitri Fontaine <dfontaine@hi-media.com>)
Список pgsql-general
Hello all -

I was looking for a way to find out how much disk space each table is
using.

I stumbled upon this page ( http://www.ffnn.nl/pages/articles/linux/postgresql-tips-and-tricks.php
) which gave me a query to show the number of disk pages per object.
Given that a page is 8kb, I added these calculated columns to the
query:

SELECT relname, reltuples, relpages,
relpages * 8 AS relpagesKB,
(relpages * 8 )/1024 AS relpagesMB
FROM pg_class ORDER BY relpages DESC ;

Is this correct?


В списке pgsql-general по дате отправления:

Предыдущее
От: "Joshi, Yateen"
Дата:
Сообщение: Re: Why does postgres take time to shut down sometimes?
Следующее
От: "Mavinakuli, Prasanna (STSD)"
Дата:
Сообщение: Looking for help regarding getting the latest inserted sequence value.