Optimizing Derived-Subquery Performance: Pulling Distinct Records into a Group Concat()

Understanding PostgreSQL Query Execution Plans: A Deep Dive into Optimization and Performance.