Explain the purpose of the EXPLAIN statement in PostgreSQL and how it can be used for query optimization.

 EXPLAIN is used to analyze the execution plan of a query. It shows how PostgreSQL intends to execute the query, helping in identifying bottlenecks and optimizing queries.