Fix some communities resulting in gateway timeout

[kyle1373]

The following were communities which resulted in a 504 gateway timeout:

• Hyrule Warriors community (https://archiverse.app/api/posts?title_id=14866558073375470466&game_id=14866558073375470493&sort_mode=popular&page=1)
• Animal Crossing: Happy Home Designer community (https://archiverse.app/api/posts?title_id=6437256808747468610&game_id=6437256808747468620&sort_mode=popular&page=1)
• Nintendo TVii Community (https://archiverse.app/api/posts?title_id=14866558072989539884&game_id=14866558072989539887&sort_mode=popular&page=1)
• Mario Party 10 Community (https://archiverse.app/api/posts?title_id=14866558073605628430&game_id=14866558073605628444&sort_mode=recent&page=1)

gives a 504 gateway timeout if you view their posts. The queries typically take more than 30 seconds. Meanwhile, other communities do not face this issue. First, figure out why some communities result in gateway timeout, then figure out a fix to them

[kyle1373]

queries:

EXPLAIN ANALYZE SELECT * FROM "Posts" WHERE "TitleId" = '14866558073375470466' AND "GameId" = '14866558073375470493' ORDER BY "EmpathyCount" DESC, "PostedDate" DESC

EXPLAIN ANALYZE SELECT * FROM "Posts" WHERE "TitleId" = '6437256808747468610' AND "GameId" = '6437256808747468620' ORDER BY "EmpathyCount" DESC, "PostedDate" DESC

EXPLAIN ANALYZE SELECT * FROM "Posts" WHERE "TitleId" = '14866558072989539884' AND "GameId" = '14866558072989539887' ORDER BY "EmpathyCount" DESC, "PostedDate" DESC

EXPLAIN ANALYZE SELECT * FROM "Posts" WHERE "TitleId" = '14866558073605628430' AND "GameId" = '14866558073605628444' ORDER BY "EmpathyCount" DESC, "PostedDate" DESC

[kyle1373]

Removed 2 db indexes which were being used over other ones. I'll check back on this and if archiverse isnt getting anymore gateway timeouts then this issue is solved

[kyle1373]

Looks like issue has been resolved. Removing the indexes which were used in those queries fixed it