From: Gone, Sajan <SGone@lb.com>
To: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Determining the last modified time of a database.
Date: Wed, 20 Sep 2017 20:42:19 +0000
Message-ID: <D5E84AFF.111A3%sgone@lb.com> (raw)
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: SGone@lb.com
Subject: Re: Determining the last modified time of a database.
In-Reply-To: <D5E84AFF.111A3%sgone@lb.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox