Overview

This repo will be used to perform database loadtesting on a postgres database

How to run the test

• pip3 install psycopg - https://www.psycopg.org/psycopg3/docs/basic/install.html

• pip3 install locust - https://docs.locust.io/en/stable/installation.html

• Update line 48 of the postgres_test.py file, you can change postgresql://postgres:postgres@localhost:5432/loadtesting_db with the connection string for your database

• Open the terminal and run locust -f postgres_test.py this will give you a URL to follow. Likely http://0.0.0.0:8089 from here, you can put in custom parameters to run your test

• For all of the custom tags that you can use in your terminal command use: locust --help

• Example: locust -f postgres_test.py --users=500 --spawn-rate=10 --run-time='15s' --autostart --autoquit 3

• To make sure the requests are actually hitting the database you can run this query SELECT pid, query_start, state, query FROM pg_stat_activity inside of your postgres database