Hi, On Tue, Aug 26, 2025 at 04:55:09PM -0500, Sami Imseih wrote: > I worry that a single view will grow very wide, and we will have to eventually > split it. So we may as well start thinking about having multiple views > in advance.
I gave it more thoughts and I now think that multiple views is better. We could start with pg_stat_backend_relations here. > > Having said that, we could imagine adding > > pg_stat_get_backend_wal() output to pg_stat_backend too. > > For this one, I think we should just overload the function > pg_stat_get_backend_wal, > and if a PID is not passed in, return all of them; and just create a > new view called > pg_stat_backend_wal that returns all the PIDs. sort of like how we have > pg_stat_get_activity and pg_stat_activity, etc. Yes, and it's also how the new view is designed in this patch. I think I'll add a new pg_stat_backend_wal view if the current proposal goes in (for consistency). Regards, -- Bertrand Drouvot PostgreSQL Contributors Team RDS Open Source Databases Amazon Web Services: https://aws.amazon.com
