| From: | "Shulgin, Oleksandr" <oleksandr(dot)shulgin(at)zalando(dot)de> |
|---|---|
| To: | 許耀彰 <kpm906(at)gmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: [BUGS] postgresql table data control |
| Date: | 2015-10-19 08:29:33 |
| Message-ID: | CACACo5S8hhEPqH3YCkKXGVdqYrMUyyf-rArmftyT6Fs=NNUYHw@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs pgsql-general |
On Sat, Oct 17, 2015 at 1:26 AM, 許耀彰 <kpm906(at)gmail(dot)com> wrote:
> Dear Support Team,
> How can we know each table data increase day by day? It mean how do we get
> how many data produce today,included which data? Thank you.
>
[moving from bugs(at)]
Please refer to these SQL-level functions:
pg_relation_size()
pg_total_relation_size()
pg_size_pretty()
http://www.postgresql.org/docs/current/static/functions-admin.html
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gláucio Barros Barcelos | 2015-10-19 11:55:55 | Re: BUG #13676: C typedef code generated by ecpg with wrong syntax |
| Previous Message | billvelek | 2015-10-19 07:31:02 | BUG #13686: Near disaster installing PostgreSQL version 9.4.5 |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sven Löschner | 2015-10-19 08:34:51 | Re: postgresql 9.4 streaming replication |
| Previous Message | Matthias Müller | 2015-10-19 08:24:09 | Re: postgresql 9.4 streaming replication |