Lectures

Learn how to use the built-in pgAdmin debugger to step through your PL/pgSQL functions and procedures: set breakpoints, watch variables, analyze errors, and efficiently solve problems in your SQL code.

In this lecture, you'll learn how to use EXPLAIN ANALYZE to check out the performance of SQL queries, functions, and procedures in PostgreSQL. We'll look at output examples, figure out how to spot bottlenecks, optimize queries with indexes, and break down typical ways to speed up your database.

In this lecture, you'll learn how to speed up functions in PostgreSQL when working with big tables using indexes and partitioning. We'll look at examples of creating indexes, partitioned tables, function optimization, and common mistakes when dealing with big data.

In this lecture, you'll learn how to comprehensively debug and optimize multi-step procedures in PostgreSQL: from analyzing input data and logging to speeding things up with indexes and transactions. Real-world examples based on an online store will help you get the hang of reliable processing and mass automation of orders.

In this lecture, you'll learn about the most common mistakes when writing, debugging, and optimizing functions and procedures in PL/pgSQL. We'll check out examples of incorrect variable usage, missing logging, performance issues, error handling, and give you some practical tips to prevent bugs and speed up your functions.