Re: PostgreSQL 9.6 Temporary files

Поиск
Список
Период
Сортировка
От Jimmy Augustine
Тема Re: PostgreSQL 9.6 Temporary files
Дата
Msg-id CAF3uhZEERT7MNg5dKNZAsBD1YTa+EEiQF5z5SDaK+QD6MOCNRQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: PostgreSQL 9.6 Temporary files  (Adrian Klaver <adrian.klaver@aklaver.com>)
Ответы Re: PostgreSQL 9.6 Temporary files
Список pgsql-general
Дерево обсуждения
Thanks all for your response,

$du -h $MY_DATA/base/$BASE_OID/ returns 162GB but when I execute this query:
SELECT stats.relname          AS table,      pg_size_pretty(pg_relation_size(statsio.relid))          AS table_size,      pg_size_pretty(pg_total_relation_size(statsio.relid)           - pg_relation_size(statsio.relid))          AS related_objects_size,      pg_size_pretty(pg_total_relation_size(statsio.relid))          AS total_table_size,      stats.n_live_tup          AS live_rows FROM pg_catalog.pg_statio_user_tables AS statsio JOIN pg_stat_user_tables AS statsUSING (relname)WHERE stats.schemaname = current_schemaUNION ALL
SELECT 'TOTAL'          AS table,      pg_size_pretty(sum(pg_relation_size(statsio.relid)))          AS table_size,      pg_size_pretty(sum(pg_total_relation_size(statsio.relid)           - pg_relation_size(statsio.relid)))          AS related_objects_size,      pg_size_pretty(sum(pg_total_relation_size(statsio.relid)))          AS total_table_size,      sum(stats.n_live_tup)          AS live_rows FROM pg_catalog.pg_statio_user_tables AS statsio JOIN pg_stat_user_tables AS statsUSING (relname)WHERE stats.schemaname = current_schemaORDER BY live_rows ASC;

I obtain 80GB in total_table_size (half of my database), where are missing data at?

2018-03-19 19:32 GMT+01:00 Adrian Klaver <adrian.klaver@aklaver.com>:
On 03/19/2018 10:27 AM, Jimmy Augustine wrote:
I tried this query and my database size is equal to 162GB.


 Well you can always look in $DATA directly. The database will be under $DATA/base/<db oid>.

You can find the <db oid> like this:

select oid, datname from  pg_database where datname='<db name>';


--
Adrian Klaver
adrian.klaver@aklaver.com

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

Предыдущее
От: Alexander Farber
Дата:
Сообщение: You might be able to move the set-returning function into a LATERALFROM item.
Следующее
От: Laurenz Albe
Дата:
Сообщение: Re: You might be able to move the set-returning function into aLATERAL FROM item.