Revisit Postgres Indices

[fm3]

We should have a look at how performance for typical queries could be improved by indices or other ideas from the postgres toolbox. We already have a few create index statements, but it is not clear if the collection is optimal. Is there any tooling with which to monitor our database to figure out which indices may help most?