Change stat_lock.wait_time to double precision
Michael Paquier <michael@paquier.xyz>
Change stat_lock.wait_time to double precision Other statistics views (pg_stat_io, pg_stat_database, etc.) use float8 for all measured-time columns, the new pg_stat_lock standing out as an outlier by using bigint. This commit aligns pg_stat_lock with the other stats views for consistency. Like pg_stat_io, the time is stored in microseconds, and is displayed in milliseconds with a conversion done when the view is queried. While on it, replace a use of "long" by PgStat_Counter, the former could overflow for large wait times where sizeof(long) is 4 bytes (aka WIN32). Bump catalog version. Author: Tatsuya Kawata <kawatatatsuya0913@gmail.com> Reviewed-by: Bertrand Drouvot <bertranddrouvot.pg@gmail.com> Reviewed-by: Michael Paquier <michael@paquier.xyz> Discussion: https://postgr.es/m/CAHza6qerEiQehrbW5xaXyxvR0qJe3KBX1R4kocDz1+7Ygu8x-g@mail.gmail.com Backpatch-through: 19
Files
| Path | Change | +/− |
|---|---|---|
| doc/src/sgml/monitoring.sgml | modified | +1 −1 |
| src/backend/storage/lmgr/proc.c | modified | +5 −4 |
| src/backend/utils/activity/pgstat_lock.c | modified | +2 −2 |
| src/backend/utils/adt/pgstatfuncs.c | modified | +1 −1 |
| src/include/catalog/catversion.h | modified | +1 −1 |
| src/include/catalog/pg_proc.dat | modified | +1 −1 |
| src/include/pgstat.h | modified | +3 −2 |
Discussion
- [PATCH] Change wait_time column of pg_stat_lock to double precision 14 messages · 2026-06-15 → 2026-07-01