database and table information collect
Dear Support Team,
How can we know each table of database information as listed as below?
Maximum Database Size
Maximum Table Size
Maximum Row Size
Maximum Field Size
Maximum Rows per Table
Maximum Columns per Table
Maximum Indexes per Table
Thank you.
On Tue, Oct 20, 2015 at 07:07:32AM +0800, 許耀彰 wrote:
Dear Support Team,
How can we know each table of database information as listed as below?Maximum Database Size
Maximum Table Size
Maximum Row Size
Maximum Field Size
Maximum Rows per Table
Maximum Columns per Table
Maximum Indexes per Table
See this:
--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ As you are, so once was I. As I am, so you will be. +
+ Roman grave inscription +--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
Dear Bruce,
How do we know our database situation as listed as below: (How many size
of each table used condition? ) Thank you.
Maximum Database Size
Maximum Table Size
Maximum Row Size
Maximum Field Size
Maximum Rows per Table
Maximum Columns per Table
Maximum Indexes per Table
2015-10-20 10:07 GMT+08:00 Bruce Momjian <bruce@momjian.us>:
Show quoted text
On Tue, Oct 20, 2015 at 07:07:32AM +0800, 許耀彰 wrote:
Dear Support Team,
How can we know each table of database information as listed as below?Maximum Database Size
Maximum Table Size
Maximum Row Size
Maximum Field Size
Maximum Rows per Table
Maximum Columns per Table
Maximum Indexes per Table
See this:
--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com+ As you are, so once was I. As I am, so you will be. + + Roman grave inscription +
On 10/19/2015 9:30 PM, 許耀彰 wrote:
Dear Bruce,
How do we know our database situation as listed as below: (How many
size of each table used condition? ) Thank you.
these questions would better be asked of the pg_general email list, and
not the bug reporting mail list, as they are not bug reports.
that said, this was answered when you asked it 3 days ago... there's a
series of functions like pg_relation_size(), pg_total_relation_size()
which will give you the size of a specific table. these are all
documented here,
http://www.postgresql.org/docs/current/static/functions-admin.html
if you want the size of every table, then you could do something like...
select table_schema || '.' || table_name,
pg_size_pretty(pg_total_relation_size(table_schema||'.'||table_name))
from informa
tion_schema.tables where table_schema not in ('pg_catalog',
'information_schema') order by pg_total_relation_size(table_schema||'.'|
|table_name) desc;
--
john r pierce, recycling bits in santa cruz
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs