From: | mallikarjun t <mallit333(at)gmail(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | How to identify when the table is created in postgres |
Date: | 2019-10-30 14:02:49 |
Message-ID: | CAOA8XiWRbAg1vtaL-AhO02N3SL6eMY6yM8KH-Po7SYiejgXw=w@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Dear Team,
How to identify when the table is created in postgres database level, what
time it is created that details, I want to know,
To know the when table is stored in data directory by knowing,
select pg_relation_filepath('table_name');
How many reltuples and relpages we can know for that table by using
pg_class,
select relpages,reltuples,relname,oid from pg_class where
relname='table_name';
When the table doing last vacuum and analyzing to know this one by using
select *from pg_stat_user_tables where relname='table_name';
what date table is created, when last modified of that table to
know details?
Kindly give you explanation of above query?
Regards,
Mallikarjunarao,
+91-8142923383.
From | Date | Subject | |
---|---|---|---|
Next Message | mallikarjun t | 2019-10-30 14:13:17 | How to know transaction count in hour basic |
Previous Message | Pepe TD Vo | 2019-10-30 13:45:06 | commit & rollback |