Charting My Path: Journey of a GSoC 2023 Contributor to PostgreSQL with pg_statviz
summary
pg_statviz is a minimalist Postgres extension plus Python CLI that snapshots Postgres internal views (24 cumulative views) into timestamped rows, generates PNG plots with matplotlib, and requires only superuser or pg_monitor to snapshot. It runs no restart required and ships eight modules out of the box; a custom module tracked pgbench_accounts and exposed rising sequential scans vs index scans, leading to a new index and improved queries. Recommended sampling is 2-minute snapshots and storage growth is few MBs/month, the workflow is modular extension + Python CLI.
AI-written summary · about
chapters (9)
- 0:00Introduction to pg_statviz
- 3:58Why pg_statviz is needed
- 7:29Installing and using pg_statviz
- 10:39How pg_statviz works internally
- 13:14Use case with checkpointer
- 16:20GSoC journey and mentors
- 18:50Experiences during GSoC
- 21:40Extending pg_statviz further
- 22:24Q&A session
related talks
32mFibonacci Spirals and Ways to Contribute to Postgres—Beyond Code
25mDiscover your contribution-magic
07mKeynote: Contributing to Critical Open Source Projects: Lessons from PostgreSQL
43mHow to Contribute to an Open Source Project like Postgres?
50mHacking on Postgres: An Overview
27mHow Do We Get Postgres to the Next Level?
35mWho What How: Understanding Kubernetes Development through DevStats - Josh Berkus & Łukasz Gryglicki
52mSupporting a New PostgreSQL Version in Your Extension...