pg_query_optimizer is a gem that improving the performance of complex queries specifically desingned for postgress database. This query significantly improves query execution times for large datasets.