PostgreSQL execution plan explained

PostgreSQL execution plan explained
Recently I ran into slow query problem in our PostgreSQL database, after doing some research, I found those tips are pretty good. Just shared here: 1. Run “Explain [analyze] your SQL statement” The ANALYZE option causes the statement to be actually executed, not only planned. For more details, check PostgreSQL official ‘explain’ document: http://www.postgresql.org/docs/current/static/sql-explain.html 2. Look for “seq scan” in ...