PostgreSQL Query Optimization and Rewrite Patterns

Summary

This skill provides a structured workflow for analysing PostgreSQL execution plans and applying restructuring patterns to improve query performance. It covers techniques such as converting subqueries to joins, managing CTE materialisation, and implementing keyset pagination.