performance: add indexes for common queries
performance: use update_column to store last_seen_at