If you found this video helpful, you could check the full course on Udemy. In this course, you’ll find tips for tuning PostgreSQL 12 like a pro.
Use the link below to get a 60% OFF.
PostgreSQL High-Performance Tuning Guide - Full Course
https://www.udemy.com/course/postgres...
When looking at a plan, there are two questions that you might want to ask yourself:
• Is the runtime shown by the EXPLAIN ANALYZE clause justified for the given query?
• If the query is slow, where does the runtime jump?
Looking for jumps in the execution time of the query will reveal what is really going on.