# Extremely slow performance when using AWX with external Postgres instance **URL:** \ **Category:** AWX Project\ **Tags:** awx\ **Created:** [December 11, 2017, 5:54pm UTC](https://forum.ansible.com/t/extremely-slow-performance-when-using-awx-with-external-postgres-instance/26248 "2017-12-11T17:54:12Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![Ben\_Donnaloia](https://avatars.discourse-cdn.com/v4/letter/b/8e8cbc/32.png) [@Ben\_Donnaloia](https://forum.ansible.com/u/Ben_Donnaloia)\ **Post date:** [December 11, 2017, 5:54pm UTC](https://forum.ansible.com/t/extremely-slow-performance-when-using-awx-with-external-postgres-instance/26248/1 "2017-12-11T17:54:12Z")
AWX is barely functional, clicking anything takes 3-4 minutes to load. Checked logs/monitoring (except for postgres which i do not have access to) and no red flags. As a test, I spun up a local postgres docker container, connected AWX to it and the issue went away… Other applications connected to our postgres production server don’t suffer from this, so wondering if there’s something I should be looking at on the AWX side? It’s strange that there are no errors in the logs… ---
**Author:** ![matburt](https://sea1.discourse-cdn.com/ansible/user_avatar/forum.ansible.com/matburt/32/3612_2.png) [@matburt](https://forum.ansible.com/u/matburt)\ **Post date:** [December 12, 2017, 3:17pm UTC](https://forum.ansible.com/t/extremely-slow-performance-when-using-awx-with-external-postgres-instance/26248/2 "2017-12-12T15:17:34Z")
Interesting, I’ve never noticed anything like this on installs with an external postgres deployment. Does postgres complain about slow queries? Are they geographically close to each other? ---
**Author:** ![Ben\_Donnaloia](https://avatars.discourse-cdn.com/v4/letter/b/8e8cbc/32.png) [@Ben\_Donnaloia](https://forum.ansible.com/u/Ben_Donnaloia)\ **Post date:** [December 13, 2017, 10:19pm UTC](https://forum.ansible.com/t/extremely-slow-performance-when-using-awx-with-external-postgres-instance/26248/3 "2017-12-13T22:19:15Z")
The slowness seems to be intermittent and the awx\_task log is filled with: [2017-12-13 22:08:12,090: ERROR/MainProcess] Timed out waiting for UP message from \ [2017-12-13 22:08:12,098: ERROR/MainProcess] Process ‘ForkPoolWorker-1095’ pid:1238 exited with ‘signal 9 (SIGKILL)’ [2017-12-13 22:08:12,429: ERROR/MainProcess] Timed out waiting for UP message from \ [2017-12-13 22:08:12,437: ERROR/MainProcess] Process ‘ForkPoolWorker-1096’ pid:1239 exited with ‘signal 9 (SIGKILL)’ [2017-12-13 22:08:12,873: ERROR/MainProcess] Timed out waiting for UP message from \ [2017-12-13 22:08:12,881: ERROR/MainProcess] Process ‘ForkPoolWorker-1097’ pid:1240 exited with ‘signal 9 (SIGKILL)’ [2017-12-13 22:08:15,477: ERROR/MainProcess] Timed out waiting for UP message from \ [2017-12-13 22:08:15,486: ERROR/MainProcess] Process ‘ForkPoolWorker-1098’ pid:1241 exited with ‘signal 9 (SIGKILL)’ [2017-12-13 22:08:16,252: ERROR/MainProcess] Timed out waiting for UP message from \ [2017-12-13 22:08:16,262: ERROR/MainProcess] Process ‘ForkPoolWorker-1099’ pid:1242 exited with ‘signal 9 (SIGKILL)’ [2017-12-13 22:08:16,595: ERROR/MainProcess] Timed out waiting for UP message from \ [2017-12-13 22:08:16,605: ERROR/MainProcess] Process ‘ForkPoolWorker-1100’ pid:1243 exited with 'signal This also happens when switching back to a local postgres docker container, so the issue is not external db. ---
**Author:** ![matburt](https://sea1.discourse-cdn.com/ansible/user_avatar/forum.ansible.com/matburt/32/3612_2.png) [@matburt](https://forum.ansible.com/u/matburt)\ **Post date:** [December 14, 2017, 4:34am UTC](https://forum.ansible.com/t/extremely-slow-performance-when-using-awx-with-external-postgres-instance/26248/4 "2017-12-14T04:34:31Z")
This looks like this: [https://github.com/celery/celery/issues/1715](https://github.com/celery/celery/issues/1715) Can you open an issue in the AWX issue tracker for us to track this? ---
**Author:** ![Ben\_Donnaloia](https://avatars.discourse-cdn.com/v4/letter/b/8e8cbc/32.png) [@Ben\_Donnaloia](https://forum.ansible.com/u/Ben_Donnaloia)\ **Post date:** [December 14, 2017, 8:22pm UTC](https://forum.ansible.com/t/extremely-slow-performance-when-using-awx-with-external-postgres-instance/26248/5 "2017-12-14T20:22:50Z")
the issue was my own mistake, we had a missing env variable for rabbitmq vhost, added it back and issue went away.