| From: | John R Pierce <pierce(at)hogranch(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: How to view creation date and time of a relation |
| Date: | 2016-05-19 07:28:26 |
| Message-ID: | ffe5069b-d991-0c05-ced2-cfe3ec7f3045@hogranch.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 5/19/2016 12:18 AM, Shrikant Bhende wrote:
>
> Our application executes come scripts with the code consist of DDL
> which creates lot of objects in the database in various schemas,also
> there are lot of connections firing the same code. I am able to locate
> the IP from where the script is initiated (which is causing more load
> on the database ), but I would like to know if I can pinpoint the
> relations which are created on a specific date and time or else I can
> do something through which I get creation date and time of the objects.
you would need to have postgres configured to log DDL, and set the log
prefix to include timestamping, then you could scan those logs to get
that information. its not otherwise stored in the database.
--
john r pierce, recycling bits in santa cruz
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sameer Kumar | 2016-05-19 07:57:48 | Re: How to view creation date and time of a relation |
| Previous Message | Shrikant Bhende | 2016-05-19 07:18:47 | How to view creation date and time of a relation |