optimize my Postgrees SQl queries

Job ID: 33151356

Budget: ₹1,500 – ₹12,500 INR

Hey, I need to optimize my Postgres db .the size is small(70 MB). Only one table has more than 10,000 rows (500k) rows rest of the tables are pretty small.

I am looking to optimize my API response times and query time to under 600 ms from the current 2-4 seconds.the DB runds on AWS RDS.