Production Best Practices

Monitoring and Optimization

0:00

0% complete

LearnStep 1 of 2

Monitoring PostgreSQL

Learning Objectives

•Monitor query performance
•Identify slow queries
•Tune configuration

Lesson Outline

LearnStep 1/2

Monitoring PostgreSQL

PostgreSQL Monitoring

Built-in Statistics Views

python

Slow Query Logging

sql

pg_stat_statements Extension

python

EXPLAIN ANALYZE

python

Performance Tuning Parameters

sql

Python Monitoring Script

python