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

Intro to Database Monitoring
SQL SELF
45 level,0 lecture
Database monitoring is the key to keeping your services stable and predictable. In this material, you'll find out why you should keep an eye on your database's health, which metrics matter for PostgreSQL, and how to use simple queries to get the info you need to prevent issues before they blow up.
Open
Main Monitoring Commands in PostgreSQL — pg_stat_activity and pg_stat_user_tables
SQL SELF
45 level,1 lecture
Learn how to use the system views pg_stat_activity and pg_stat_user_tables for effective monitoring and performance analysis of your PostgreSQL database. Real-life query examples and optimization tips included.
Open
Real-Time Tracking of Active Transactions with pg_stat_activity
SQL SELF
45 level,2 lecture
Learn how to use the pg_stat_activity view effectively for monitoring, finding, and killing long-running or problematic transactions in PostgreSQL. Practical query examples, tips for filtering and automation, plus a breakdown of common monitoring mistakes.
Open
Query Logging
SQL SELF
45 level,3 lecture
Learn how to properly set up logging in PostgreSQL: which parameters control query logging, how to spot slow operations, analyze logs, and boost your database performance. Real-world examples and tips for effective auditing and troubleshooting.
Open
Analyzing Slow Queries with pg_stat_statements
SQL SELF
45 level,4 lecture
Learn how to use the pg_stat_statements extension in PostgreSQL to find and optimize slow and frequently executed SQL queries. Real-life examples, indexing tips, and performance analysis tricks.
Open