New realizing Postgres 13 has been launched and now it’s the time for making some updates to “Postgres Observability” diagram.
New open contains many improvements related to monitoring, a lot like new stats views and new added fields to present views. Let’s gain a more in-depth explore at these.
Checklist of progress views has been extended with two new views. The first one is the “pg_stat_progress_basebackup” which helps to ponder working heinous backups and estimate their progress, ETA and diversified properties. The second explore is the “pg_stat_progress_analyze” because the name suggests, it watches over attain/analyze operations.
The third new explore is is named pg_shmem_allocations which is purported to be outmoded for deeper inspection of how shared buffers are outmoded.
The fourth, and the final new explore is “pg_stat_slru” related to the inspection of SLRU caches. Each no longer too prolonged in the past added views are help to acknowledge the quiz “How Postgres spends its allocated memory”
Tons of improvements are current-motive and related to the current views.
The “pg_stat_statements” has few modifications:
- New fields related to time planning fetch been added, and thanks to this the present “time” fields fetch been renamed to executing time. So all monitoring tools that count on pg_stat_statements must be adjusted accordingly.
- New fields related to WAL fetch been added – now it’s that you simply are going to be ready to imagine to love how grand WAL has been generated by every assertion.
WAL utilization statistics fetch additionally been added to EXPLAIN (added WAL keyword), auto_explain and autovacuum. WAL utilization stats are appended to the logs (that’s if log_autovacuum_min_duration is enabled)
Pg_stat_activity has a new column “leader_pid”, which exhibits the PID of the parallel team leader and helps to explicitly title background staff with their leader.
A mountainous thank you goes to many who contributed to this new open, among which might perchance presumably presumably be my colleagues Victor Yegorov and Sergei Kornilov and additionally folk who help to unfold the observe about Postgres to diversified communities and across geographies.