Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

PostgreSQL indexes creation time

Tags:

postgresql

ddl

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.

like image 457
cableload Avatar asked Oct 03 '12 14:10

cableload


1 Answers

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

like image 197
Pavel Stehule Avatar answered Oct 25 '22 03:10

Pavel Stehule