Episode 44
pg_stat_statements
Postgres FM · Nikolay Samokhvalov and Michael Christofides
May 5, 202345m 51s
Audio is streamed directly from the publisher (media.transistor.fm) as published in their RSS feed. Play Podcasts does not host this file. Rights-holders can request removal through the copyright & takedown page.
Show Notes
Nikolay and Michael discuss pg_stat_statements — why everyone should use it, but also some downsides!
Here are links to a few things we mentioned:
- pg_stat_statements (docs)
- pg_stat_statements (PgPedia)
- PGSQL Phriday
- Observer effect in pg_stat_statements and pg_stat_kcache (Postgres Hacking session on Postgres TV)
- track_io_timing (docs)
- Overhead comment (by Tom Kate, via Jeremy Schneider)
- pg_stat_monitor
- PGCon
- Our episode on query analysis
- Marginalia
~~~
What did you like or not like? What should we discuss next time? Let us know on YouTube, on social media, or by commenting on our Google doc.
If you would like to share this episode, here's a good link (and thank you!)
~~~
Postgres FM is brought to you by:
- Nikolay Samokhvalov, founder of Postgres.ai
- Michael Christofides, founder of pgMustard
With special thanks to:
- Jessie Draws for the amazing artwork
Topics
PostgresPostgreSQLDatabasesSQLtechnology