Diagnose and Fix Slow queries (Postgres)
Budget: $15 – $25 USD
We are looking for someone to fix some slow queries (probably due to a lock and/or some bad indexing)
The queries are very simple SELECT like :
- SELECT timereceived FROM accelerometers WHERE wellid=$1 AND timereceived >= $2 ORDER BY timereceived DESC LIMIT 1
The queries are very simple SELECT like :
- SELECT timereceived FROM accelerometers WHERE wellid=$1 AND timereceived >= $2 ORDER BY timereceived DESC LIMIT 1