# Having a hard time optimising

**URL:** https://meta.discourse.org/t/having-a-hard-time-optimising/359446
**Category:** Support
**Created:** [March 29, 2025, 4:45pm UTC](https://meta.discourse.org/t/having-a-hard-time-optimising/359446 "2025-03-29T16:45:41Z")
**Posts on this page:** 1
**Showing post:** 1

<div class="post-metadata">

### Author: ![Eviepayne](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/eviepayne/32/352733_2.png) [@Eviepayne](https://meta.discourse.org/u/Eviepayne)
#### Post date: [March 29, 2025, 4:45pm UTC](https://meta.discourse.org/t/having-a-hard-time-optimising/359446/1 "2025-03-29T16:45:41Z")

</div>

Our forum underwent a large infrastructure change and now it’s not performing well.  
I migrated the database to be a managed database at digitalocean, I put S3 assets on a minio instance with cloudflare in front of it.  
I also re-deployed the discourse with a smaller vm but still enough resources to handle the load.  
from what I can see there are postgres queries that are taking forever:  
21 seconds  
 ![image](https://global.discourse-cdn.com/meta/original/4X/7/1/9/719b5d4d795611241ae171346b8dfb0ad1b8c09a.png)  
19 seconds  
 ![image](https://global.discourse-cdn.com/meta/original/4X/0/1/4/014ebfdd2e7e3b83ad9b2af6b051e31f491cc98d.png)

---

_[View the full topic](https://meta.discourse.org/t/having-a-hard-time-optimising/359446)._
