If your /projects page is slow or errors out with a large Phoenix database (e.g., 4TB), but direct GraphQL queries are fast, the issue is likely due to the UI loading or aggregating too much data at once, or hitting timeouts or memory limits. This is a known issue—Phoenix's /projects page can block on metric queries for each project, causing slow loads or timeouts, especially with large datasets. Improvements have been made (e.g., lazy loading, reducing page size, and optimizing queries), but performance can still degrade with very large data volumes or many projects/traces. Upgrading to the latest Phoenix version is recommended, as recent releases include major speed improvements and better lazy loading for project views. Also, try reducing the number of projects, limiting the time range, or filtering to root spans to improve performance. If you still hit errors, check server logs for timeouts or memory errors, and consider increasing server resources or database tuning (e.g., indexes, partitioning) for large-scale deployments. For persistent issues, you may need to pre-aggregate metrics or further optimize your database setup (<https://github.com/Arize-ai/phoenix/issues/6868|source>, <https://github.com/Arize-ai/phoenix/issues/6201|source>, <https://arize.com/docs/phoenix/production-guide#memory-sizing|source>, <https://arize.com/docs/phoenix/self-hosting/architecture|source>, <https://arize.com/docs/phoenix/release-notes/03-2025/03-06-2025-project-improvements|source>).
Would you like more detail on specific optimizations, configuration, or troubleshooting steps?
Sources:
- <https://github.com/Arize-ai/phoenix/issues/6868|https://github.com/Arize-ai/phoenix/issues/6868>
- <https://github.com/Arize-ai/phoenix/issues/6201|https://github.com/Arize-ai/phoenix/issues/6201>
- <https://arize.com/docs/phoenix/production-guide#memory-sizing|https://arize.com/docs/phoenix/production-guide#memory-sizing>
- <https://arize.com/docs/phoenix/self-hosting/architecture|https://arize.com/docs/phoenix/self-hosting/architecture>
- <https://arize.com/docs/phoenix/release-notes/03-2025/03-06-2025-project-improvements|https://arize.com/docs/phoenix/release-notes/03-2025/03-06-2025-project-improvements>