I think you should review your postgres database. Run vacuum analyze for tables contain large tombstone. I opened monitoring topic in thread, you can review it.
Related topics
| Topic | Replies | Views | Activity | |
|---|---|---|---|---|
| Extremely slow performance when using AWX with external Postgres instance | 4 | 64 | December 14, 2017 | |
| Reduce Postgres memory usage for AWX | 3 | 534 | March 1, 2024 | |
| AWX Slowness issue - Long start time for jobs-AWX 24.6.1 | 13 | 920 | October 31, 2024 | |
| AWX UI/API slowness | 0 | 40 | September 2, 2020 | |
| AWX 17 very slow | 1 | 22 | August 25, 2021 |