How do you use pg_stat_statements and other monitoring tools to identify the queries that most need optimization?

Sample answer preview

Identifying which queries to optimize is as important as knowing how to optimize them. Spending time optimizing a query that runs once a day and takes two seconds is far less valuable than optimizing a query that runs ten thousand times per hour and takes 50 milliseconds.