PostgreSQL indexes creation time

Question

what is the query that i can use to find out when(date) a particular index (unique or non-unique) has been created in the database. Basically i want to find out the indexes that were created in the last one month or so.

You can get the relfilenode for the index from the system catalogs and examine the ctime of the on-disk file that backs the index. However (a) I think REINDEX will delete and recreate it, and (b) for big indexes there can be more than one such file as they're in 1GB chunks. I'm curious: why do you want that? — Craig Ringer
– Craig Ringer, Commented Oct 4, 2012 at 1:35
The best thing to do is to keep log_statement on to at least log DDL, so you can trace such events. — Craig Ringer
– Craig Ringer, Commented Oct 4, 2012 at 1:35

Pavel Stehule · Accepted Answer · 2018-12-10 13:06:34Z

4

This is not possible. There is no info about creating time of relations, indexes, ...

edited Dec 10, 2018 at 13:06

user330315

answered Oct 3, 2012 at 15:13

Pavel Stehule

46.6k6 gold badges103 silver badges102 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

PostgreSQL indexes creation time

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related