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?
Список 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 по дате отправления: