Postgres performance-monitoring gem/app by Andrew Kane with a solid algorithm for detecting missing indexes. Speaker notes the algorithm is 'very complete' for typical Rails/Postgres apps but was last meaningfully updated ~5 years ago, so pull requests are welcome.