Cutting a critical reporting endpoint's response time by ~75%

Intetics · Senior Software Engineer

Problem

  • A critical reporting endpoint took about 1.2 seconds to respond.

What I did

  • Restructured the PostgreSQL queries behind the endpoint.
  • Added indexes for the data the endpoint reads.
  • Cached results in Redis.

Result

  • The response time dropped by ~75%, from ~1.2s to ~300ms.

Tech

  • PostgreSQL
  • Redis
Back to home