Weeding out unused user created database objects, could I use pg_catalog?

From: Allan Kamau <kamauallan(at)gmail(dot)com>
To: Postgres General Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Weeding out unused user created database objects, could I use pg_catalog?
Date: 2010-02-12 12:32:03
Message-ID: ab1ea6541002120432pf0e099dv3ced6f20b34e1e83@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I have been written several psql functions, tiggers and defined
several tables over time for a database application I have been
developing. The application has evolved as I have gained better
understanding of the solution and so I have written newer psql
functions and other database objects inline with this evolution and
stopped calling (making use of) the older database objects I had
previously written. Now I would like to only keep these database
objects that are currently been used by the application. I have
dedicted a single database object for use with this application, and I
have all the DDL scripts in files which I execute for a clean
deployment.

If I start with a clean deployment, is there a way I could perhaps
query the table(s) in pg_catalog for example to find out the database
objects (I have constructed) that have been invoked or used in some
way during a complete run of my application. I had a quick look at the
pg_catalog but was unable to determine the tables that may contain
pieces of this information. If pg_catalog could provide me with this
solution, what are the table(s) to query?

Allan.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message A. Kretschmer 2010-02-12 12:40:34 possible bug with inheritance?
Previous Message Oliver Kohll - Mailing Lists 2010-02-12 12:29:49 pg_dump: SQL command failed