Nikolay and Michael discuss query macro analysis — at the whole system level as opposed to an individual query.
Here are links to a few things we mentioned:
- pg_stat_statements: https://www.postgresql.org/docs/current/pgstatstatements.html
- pgFouine: https://github.com/milo/pgFouine
- pgBadger: https://github.com/darold/pgbadger
- pg_query: https://github.com/pganalyze/pg_query
- pg_stat_activity: https://www.postgresql.org/docs/current/monitoring-stats.html#MONITORING-PG-STAT-ACTIVITY-VIEW
- auto_explain: https://www.postgresql.org/docs/current/auto-explain.html
- Can auto_explain (with timing) have low overhead? https://www.pgmustard.com/blog/auto-explain-overhead-with-timing
- track_io_timing https://www.postgresql.org/docs/current/runtime-config-statistics.html#GUC-TRACK-IO-TIMING
- pgbench https://www.postgresql.org/docs/current/pgbench.html
- PgHero https://github.com/ankane/pghero
- pgCenter https://github.com/lesovsky/pgcenter
- pgwatch2 (Postgres AI edition) https://gitlab.com/postgres-ai/pgwatch2
- pg_stat_kcache https://github.com/powa-team/pg_stat_kcache
- PostgreSQL ASH Viewer (PASH Viewer) https://github.com/dbacvetkov/PASH-Viewer
-----------------------
What did you like or not like? What should we discuss next time? Let us know by tweeting us on @samokhvalov https://twitter.com/samokhvalov and @michristofides https://twitter.com/michristofides
~~~
Postgres FM is brought to you by:
- Nikolay Samokhvalov, founder of Postgres.ai
- Michael Christofides, founder of pgMustard
~~~
This is the uncut version, with video. Check out https://Postgres.fm to find audio-only podcast episodes, edited for convenient listening.
