Problem: Account transactions API may not be optimized

[calvinaco]

Right now account transactions API sometimes take a long time to return result for account with huge transaction records.

The long term solution is to support cursor pagination #628 .

In a short term, there are already some Postgre index introduced but we can analyze common SQL (where and order clause) and see if more index can be introduced to improve the performance.