On Fri, Jan 21, 2022 at 01:38:59PM +0100, Matthias Apitz wrote: > Does the PostgreSQL (11.4 or 13.1) record somewhere in system tables > the creation of INDEXes (or other objects)? Hard to say what you are looking for with such a general question. Would pg_index or pg_indexes be enough? There are a bunch of system catalogs and views, like what's in information_schema, that provide this information. If you are looking for a record of the timestamp when objects have been created, there is no such tracking in Postgres itself, but you could use an event trigger for this purpose. Here are some links; https://www.postgresql.org/docs/devel/catalog-pg-index.html https://www.postgresql.org/docs/devel/view-pg-indexes.html https://www.postgresql.org/docs/devel/event-triggers.html -- Michael
Attachment:
signature.asc
Description: PGP signature
