wiki Disk Usage, table size: ERROR: could not open relation with OID 0
От | Hans Schou |
---|---|
Тема | wiki Disk Usage, table size: ERROR: could not open relation with OID 0 |
Дата | |
Msg-id | CAApBw37QdLBn0bE=OykDnn1BUJmz_rDBHcs3bWfbTScQ6cDg3A@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: wiki Disk Usage, table size: ERROR: could not open relation withOID 0
|
Список | pgsql-general |
Hi
I got the message
ERROR: could not open relation with OID 0
when running the "General Table Size Information" from https://wiki.postgresql.org/wiki/Disk_Usage
This patch gives some system tablesI got the message
ERROR: could not open relation with OID 0
when running the "General Table Size Information" from https://wiki.postgresql.org/wiki/Disk_Usage
@@ -12,5 +12,6 @@
FROM pg_class c
LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
WHERE relkind = 'r'
+ AND reltoastrelid!=0
) a
) a;
SELECT *, pg_size_pretty(total_bytes) AS total , pg_size_pretty(index_bytes) AS INDEX , pg_size_pretty(toast_bytes) AS toast , pg_size_pretty(table_bytes) AS TABLE FROM ( SELECT *, total_bytes-index_bytes-COALESCE(toast_bytes,0) AS table_bytes FROM ( SELECT c.oid,nspname AS table_schema, relname AS TABLE_NAME , c.reltuples AS row_estimate , pg_total_relation_size(c.oid) AS total_bytes , pg_indexes_size(c.oid) AS index_bytes , pg_total_relation_size(reltoastrelid) AS toast_bytes FROM pg_class c LEFT JOIN pg_namespace n ON n.oid = c.relnamespace WHERE relkind = 'r' ) a ) a;
Any help much appreciated.
./best regards
В списке pgsql-general по дате отправления: