Schedule - PGConf.DE 2024

Understanding PostgreSQL statistics to optimize performance

Date: 2024-04-12
Time: 13:45–14:30
Room: Ballsaal 3
Level: Intermediate
Feedback: Leave feedback

In this session, I will explain the types of statistics in PostgreSQL - 1. Data Distribution statistics (which are generated when we run 'Analyze' and will also talk about 'Create Statistics' command) 2. Monitoring Statistics and its uses (most commonly used stat views - pg_stat_user_tables, pg_stat_user_indexes, pg_stat_bgwriter etc.)

The session will aim to explain these statistics and how to make use of them to optimize your workloads.

Speaker

Divya Sharma