A number of edit-related tables have columns storing timestamps:
- edit: open_time, expire_time, close_time
- edit_note: post_time
- vote: vote_time
They have a strong correlation with the relevant ID column, but Postgres isn't aware of this fact. Adding BRIN indexes (introduced in 9.5) might help with this. In that case, existing btree indexes could probably be dropped.