PostgreSQL Spotting Query Problems 10/12

Опубликовано: 22 Октябрь 2024
на канале: High-Performance Programming
3,701
43

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.