Identifying Slow Queries and Fixing Them!
Talk by Stephen Frost
https://www.socallinuxexpo.org/scale/...
We'll be looking at PostgreSQL configuration options (postgresql.conf) for logging and basic tuning parameters, how to monitor which queries are taking the most time using pg_stat_statements, going over EXPLAIN and EXPLAIN ANALYZE output for select queries (and the auto_explain module), what the EXPLAIN output means in terms of how the query is being executed, and then going over ways to improve the queries, including index creation, rewriting the query to allow PG to use a different plan, and how to tune parameters for specific queries.
Watch video Identifying Slow Queries and Fixing Them! online without registration, duration hours minute second in high quality. This video was added by user Southern California Linux Expo 25 December 2022, don't forget to share it with your friends and acquaintances, it has been viewed on our site 80 once and liked it 3 people.