This talk will take you to an optimizer backstage tour: from theoretical background of state-of-the-art query optimization to close look at current implementation of PostgreSQL. We also share our experiences to hack the optimizer in our laboratory. Query optimization is a cornerstone of modern database software including PostgreSQL. However its internal mechanism is not widely known to the community. The goal of this talk is to offer clear and deep knowledge of query optimization technology.