在两列上使用COUNT和GROUP BY进行极慢的SQL查询

I'm archiving this web forum, which normally gets purged about once a week. So I'm screen scraping it, and storing it into my database (PostgreSQL).I'm archiving this web forum, which normally ge