Request a Demo
Home   >   mailing lists

Re: [Patch] New pg_stat_tablespace view - Mailing list pgsql-hackers

From shihao zhong
Subject Re: [Patch] New pg_stat_tablespace view
Date
Msg-id CAGRkXqRp+mK_uuCEp+wuBvuvFf_1v=MGC6Dd6HgJigJUzZanHg@mail.gmail.com
Whole thread
In response to [Patch] New pg_stat_tablespace view  (shihao zhong <zhong950419@gmail.com>)
Responses Re: [Patch] New pg_stat_tablespace view
List pgsql-hackers
Tree view 
On Mon, Mar 23, 2026 at 3:08 PM shihao zhong <zhong950419@gmail.com> wrote:
>
> Hi hackers,
>
> I’ve been working on extending the cumulative statistics system to
> provide better visibility into tablespace-level workloads, and I'd
> like to propose a patch to add a new system view: pg_stat_tablespace.
>
> Currently, PostgreSQL provides statistics per database (e.g.,
> pg_stat_database) and per relation (e.g., pg_statio_user_tables).
> However, because tablespaces can span multiple databases, it is
> difficult for DBAs to analyze storage hotspots across the cluster or
> verify if a specific tablespace (such as a high-performance SSD vs a
> slow HDD array) is experiencing I/O bottlenecks or excessive temporary
> file usage.
>
> The pg_stat_tablespace view bridges this gap by providing an aggregate
> view of block I/O and temporary file usage grouped by tablespace,
> making it easier to optimize storage architectures.
>
> Thanks,
> Shihao

New version fix the CI/CD
Attachment

pgsql-hackers by date:

Previous
From: David Rowley
Date:
Subject: Re: Fix "could not find memoization table entry"
Next
From: Chao Li
Date:
Subject: Re: [Proposal] Adding Log File Capability to pg_createsubscriber