List of lectures for the course SQL, 41 quest level on JavaRush

Intro to Query Performance Analysis
SQL SELF
41 level,0 lecture
Learn how to spot and fix bottlenecks in your PostgreSQL workflow using EXPLAIN, pg_stat_statements, and slow query logging. Real-world examples and tips for optimizing your queries to boost your database performance.
Open
Main concepts of the query execution plan: cost, rows, width
SQL SELF
41 level,1 lecture
Learn how PostgreSQL evaluates and picks an execution plan for your SQL query. We're breaking down the cost, rows, and width parameters with real-life examples, so you can optimize your queries and actually get how the optimizer works.
Open
What is EXPLAIN and How to Use It to Analyze Queries
SQL SELF
41 level,2 lecture
Learn how to use the EXPLAIN command in PostgreSQL to analyze and optimize SQL queries. We'll break down the syntax, sample output, main options, and common mistakes when working with execution plans.
Open
Using EXPLAIN ANALYZE to Measure Actual Query Execution Time
SQL SELF
41 level,3 lecture
Learn how to use EXPLAIN ANALYZE in PostgreSQL to analyze the real execution time of your SQL queries, find bottlenecks, and optimize your database performance.
Open
Execution Plan Interpretation: Reading and Analyzing Nodes (`Seq Scan`, `Index Scan`, `Hash Join`)
SQL SELF
41 level,4 lecture
Learn how to read and analyze query execution plans in PostgreSQL. We'll break down the main node types (`Seq Scan`, `Index Scan`, `Hash Join`), their pros and cons, and figure out how to spot and fix common performance issues.
Open