From: | "Gone, Sajan" <SGone(at)lb(dot)com> |
---|---|
To: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
Subject: | Determining the last modified time of a database. |
Date: | 2017-09-20 20:42:19 |
Message-ID: | D5E84AFF.111A3%sgone@lb.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi,
There are some unused databases on one of our existing Postgres Dev instance. I am currently in the process of determining those and eventually planning to drop those db’s.
So, how would I determine a database which has not been modified from past few days, lets say a month (or) so? Also is there a way to determine the last time when some one connected to a specific DB and retrieved some information (or) even an idle connection?
Any thoughts on this are highly appreciated. Many thanks in advance.
Thank You,
Sajan Gone
Database Administrator
L Brands
Mobile #: 517-990-5282
Office #: 614-577-7622
________________________________
Notice: This communication may contain privileged and/or confidential information. If you are not the intended recipient, please notify the sender by email, and immediately delete the message and any attachments without copying or disclosing them. LB may, for any reason, intercept, access, use, and disclose any information that is communicated by or through, or which is stored on, its networks, applications, services, and devices.
From | Date | Subject | |
---|---|---|---|
Next Message | Gustav Karlsson | 2017-09-25 05:08:38 | Risks of running Postgres as a Docker container? |
Previous Message | Tom Lane | 2017-09-20 19:57:14 | Re: make installcheck failing for postgres_fdw |