Utils

• Redshift: Query to get super admin users with more job access (this query in Aurora take 172 sec)
• My Speed connection
• Datadog: Error 500 for jobs/list endpoint
• DBT PR to debug information

Job Page

• After login, the Truman job listing page request the next endpoints
  • Screenshot
  • https://api.apploi.com/v1/jobs/list?limit=20&offset=0 (11 sec)
    • Response
    • Note: The problem is in the main database with the description field, you can check the description of the PR.
      • Query in execute for the user Chezkie Glatt (team_id)
  • https://api.apploi.com/v1/processedapplications/applicants?limit=20&offset=0 (6 sec)
    • Screenshot
    • Note: Maybe we need to use a new request only to count the unread message.
  • https://api.apploi.com/v1/teams?user_id=65955 (Duplicate request)
    • Screenshot
• Reload the page screenshot

Applicant Page

• Load the 1st time

  

  • https://api.apploi.com/v1/users/all_company?team_id=42317&exclude_same_team=0 (10 sec) but the request is not a block for using the page.
    • Note: This is about the company members.
  • https://api.apploi.com/v1/processedapplications/applicants?limit=20&offset=0 (6 sec)
    • Note: 2 or 3 requests when the page is load

• Request the 2nd page with 100 applications

  

  Note: For me, the response times are good.