Скачать или смотреть pg_stat_statements track_planning | Postgres.FM 125 |

[ 🇬🇧_🇺🇸 Check out the subtitles – we now edit them, ChatGPT+manually! You can also try YouTube's auto-translation of them from English to your language; try it and share it with people interested in Postgres!]

Nikolay and Michael discuss the track_planning parameter of pg_stat_statements — what it is, how it affects performance, and when or whether you should switch it on.

Here are some links to things they mentioned:

pg_stat_statements.track_planning https://www.postgresql.org/docs/curre...
Our episode about pg_stat_statements https://postgres.fm/episodes/pg_stat_...
PostgreSQL 13.0 release notes https://www.postgresql.org/docs/relea...
track_planning causing performance regression (thread on hackers during v13 beta) https://www.postgresql.org/message-id...
Our episode on 4 million TPS https://postgres.fm/episodes/four-mil...
Observer effect in pg_stat_statements and pg_stat_kcache (Postgres TV Hacking session with Andrey and Kirk) https://www.youtube.com/live/wHMNX-fH...


~~~


What did you like or not like? What should we discuss next time? Let us know in the comments, or by tweeting us on @postgresfm   / postgresfm  , @samokhvalov   / samokhvalov   and @michristofides   / michristofides  


~~~


Postgres FM is produced by:
Nikolay Samokhvalov, founder of Postgres.ai https://postgres.ai/
Michael Christofides, founder of pgMustard https://pgmustard.com/


~~~


This is the video version. Check out https://postgres.fm to subscribe to the audio-only version, to see the transcript, guest profiles, and more.