--- title: "See every byte of a Postgres query made over the network" publication: "Postgres Weekly" issue: 585 published_at: "2025-01-23" canonical_url: "https://postgresweekly.com/issues/585" --- Plus a look at who contributed to Postgres in 2024. | #​585 — January 23, 2025 [Web Version](https://postgresweekly.com/issues/585) Together with [![VeilSteam logo\](https://res.cloudinary.com/cpress/image/upload/c_fill,g_auto,w_1280,h_367/sdlzxxrugmthuvluzjr4.png)](https://www.veilstream.com/sign_up) Postgres Weekly [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60,q_auto/mk5bzh3up1xchq0gse6b.jpg)](http://rhaas.blogspot.com/2025/01/who-contributed-to-postgresql.html) [Who Contributed to Postgres Development in 2024?](http://rhaas.blogspot.com/2025/01/who-contributed-to-postgresql.html) — Each year, Robert compiles a list of those who contributed most to Postgres’ development over the past year. 229 folks were the principal authors of at least one commit, and 66% of new lines of code came from the top 18 contributors. Robert Haas [Anatomy of Table-Level Locks: Reducing Locking Impact](https://xata.io/blog/anatomy-of-locks-reduce) — It’s _easy_ to lock an entire table when performing an operation, but the performance and uptime impacts should quickly drive you to using less restrictive approaches. Gulcin explains some options. Gulcin Yildirim Jelinek [![\](https://res.cloudinary.com/cpress/image/upload/c_limit,w_480,h_480,q_auto/copm/7c2b012b.png)](https://www.veilstream.com/sign_up) [VeilStream – Simple Data Access Management for Postgres](https://www.veilstream.com/sign_up) — VeilStream is a secure, self-hosted, Postgres filter that sits in front of your production database to provide a powerful and simple GUI and API for setting up data redaction and anonymization rules. [Try it for free today](https://www.veilstream.com/sign_up). VeilStream sponsor [`GROUP BY` and Fixing Optimizer Estimates](https://www.cybertec-postgresql.com/en/group-by-fixing-optimizer-estimates/) — Did you know the more columns a `GROUP BY` contains, the more likely the optimizer overestimates the row count? Postgres maintains separate statistics for each column and creates group estimates by multiplying them together. Creating extended statistics can help get things in order. Hans-Jürgen Schönig **QUICK BITS:** [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60,q_auto/up6tlxtjaevrp6q1hrqn.jpg)](https://bytebybyte.dev/?postgres) - [Take a look at every byte](https://bytebybyte.dev/?postgres) that goes over the network when making a real Postgres query made to Neon over TLS _(above)_. Everything is annotated to help you understand the complexity. - [Clickbench](https://github.com/ClickHouse/ClickBench/tree/main) is a benchmark for real-time analytics databases and thanks to [pg_mooncake](https://github.com/Mooncake-Labs/pg_mooncake), Postgres is [now in the top 10 databases in the benchmark.](https://www.mooncake.dev/blog/clickbench-v0.1) - 🗓️ The schedules for both [Nordic PGDay 2025](https://www.postgresql.eu/events/nordicpgday2025/schedule/) and [pgDay Paris 2025](https://www.postgresql.eu/events/pgdayparis2025/schedule/) have now been published. - 🇧🇪 If you're going to the FOSDEM PGDay next month _or want to_, Andreas Scherbaum has [lots of useful advice and info here.](https://andreas.scherbaum.la/post/2025-01-20_postgresql-at-fosdem-2025/) [Implementing Thread-Safe Scanners and Parsers in Postgres](https://peter.eisentraut.org/blog/2025/01/21/implementing-thread-safe-scanners-and-parsers-in-postgresql) — Unless you’re a Postgres implementer (like [top 5 contributor](https://rhaas.blogspot.com/2025/01/who-contributed-to-postgresql.html) Peter Eisentraut here) this probably won’t be directly useful to you, but it’s fascinating to see what’s involved in potentially moving Postgres’ scanners and parsers to be thread safe. Spoiler: It’s _a lot._ Peter Eisentraut [Don't Forget About the Parallel Leader Participation Setting](https://kmoppel.github.io/2025-01-22-dont-forget-about-postgres-parallel-leader-participation/) — Kaarel has his own TLDR: _“You should actually look into disabling `parallel_leader_participation` if you’re working with larger out-of-cache datasets, have plenty of cores and especially when the tables are partitioned.”_ Kaarel Moppel 📄 [Unpivoting Data using JSONB](https://www.postgresonline.com/journal/index.php?/archives/417-Unpivoting-data-using-JSONB.html#unpivoting) – Very handy tip. Leo Hsu and Regina Obe 📄 [Whose Optimization is Better?](https://danolivo.substack.com/p/whose-optimisation-is-better) – Thoughts on comparing the quality of SQL query plans. Andrei Lepikhov 📄 [Postgres UUIDv7 + Per-Backend Monotonicity](https://brandur.org/fragments/uuid-v7-monotonicity) Brandur Leach 📄 [Logical Replication in Postgres: The Basics](https://www.enterprisedb.com/blog/logical-replication-postgres-basics) Phil Eaton 📰 Classifieds 🐘 [**POSETTE: An Event for Postgres**](https://posetteconf.com/2025/cfp/) is June 10-12. The [call for proposals](https://posetteconf.com/2025/cfp/) **closes Feb. 9**. New and experienced speakers are encouraged to submit! --- Achieve peak Postgres performance. [Take the pganalyze tour](https://pganalyze.com/product-tour?utm_source=PostgresWeeklyClassified01232025). 🛠 Code and Tools [DBOS Transact v2: Lightweight Durable Execution in TypeScript](https://github.com/dbos-inc/dbos-transact-ts) — An opensource library for lightweight durable execution built on Postgres. Durable execution means persisting the execution state of a program while it runs, so if it's interrupted or crashes, it resumes from where it left off, ideal for long-running or business-critical workflows. [Documentation.](https://docs.dbos.dev/) DBOS, Inc. [HeidiSQL 12.10: A Native Windows App for Database Work](https://www.heidisql.com/) — A handy, open source database management tool. Supports Postgres, MySQL, SQL Server, and SQLite. Written in Delphi and is [open source.](https://github.com/HeidiSQL/HeidiSQL) Ansgar Becker - [PostgresML 2.10](https://github.com/postgresml/postgresml/releases/tag/v2.10.0) – Machine learning from SQL. Now supporting Postgres 17. - [pgai 0.7](https://github.com/timescale/pgai/releases/tag/extension-0.7.0) – Timescale's tools to work with RAG and LLMs in Postgres. - [pg-diff 3.0](https://michaelsogos.github.io/pg-diff/) – PostgreSQL schema and data comparing tool. - [tbls 1.80](https://github.com/k1LoW/tbls) – Auto document a database in Markdown format. - [Bob 0.30](https://github.com/stephenafamo/bob/releases/tag/v0.30.0) – SQL query builder and ORM/Factory generator for Go. - [PostgreSQL JDBC Driver 42.7.5](https://github.com/pgjdbc/pgjdbc/releases/tag/REL42.7.5) - [PostGIS 3.5.2](https://postgis.net/2025/01/PostGIS-3.5.2/) **Got a new email?** You can [change your address here](https://postgresweekly.com/edit_subscription/*|UID|*). --- **Bored of us?** [Click here to stop getting Postgres Weekly](https://postgresweekly.com/leave/*|UID|*). --- **Got a link for us?** Reply and tell us. We can't include everything but we'll look at anything you send. _Thanks!_ --- Published by Cooper Press Ltd. Fairfield Enterprise Centre, Louth, LN11 0LS, United Kingdom Postgres, PostgreSQL and the Slonik Logo are trademarks or registered trademarks of the PostgreSQL Community Association of Canada. [Stop getting this newsletter](https://postgresweekly.com/leave/*|UID|*).