Schedule - PGConf.DE 2024
Understanding PostgreSQL statistics to optimize performance
Date: 2024-04-12
Time: 13:45–14:30
Room: Ballsaal 3
Level: Intermediate
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.
Slides
The following slides have been made available for this session: