|
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
|
