- Using EXPLAIN ANALYZE in SQL, the UNOPTIMIZED QUERY returned in Planning Time: 1.235 ms Execution Time: 1.033 ms while the OPTIMIZED QUERY returned in Planning Time: 0.360 ms, Execution Time: 0.224 ms. This shows that the optimized query ran faster than the unoptimized one.
- Run the test with the command
> $ npm test
Typescript, Node, Express, Postgres(SQL)