Optimize DB queries and profile times for all read/write paths in application

[aahnik]

• brainstorm about the appropriate indexes for each schema
• run the db queries for the read and write path of each entity at a very high number of operations per second, and record the time taken by postgres at different RAM and CPU conditions
• apply apt indexes as required