Lightsail is really aimed at simple web apps and websites.
You have one CPU core, so that means 2 unicorn workers, but your shared_buffers could be upped to 512MB. Your app.yml should include this comment:
With 2GB we recommend 3-4 workers, with 1GB only 2
So you’re using twice as many workers with half the recommended buffer size.
Spinning discs are what came before SSD, although you may also know them as hard drives or HDD. They’re too slow for Discourse.