# Partitioning: relation size per "group"

DevFeed: [Partitioning: relation size per "group"](<https://devfeed.tech/articles/partitioning-relation-size-per-group-34375.md>)

Original publisher: [Read original article](<https://tapoueh.org/blog/2010/07/partitioning-relation-size-per-group/>)

Author: Dimitri Fontaine PostgreSQL Major Contributor; Author

Published: 2010-07-26T15:00:00Z

Content type: tutorial

Language: en

Sources: [Dimitri Fontaine](<https://devfeed.tech/sources/dimitri-fontaine.md>)

Topics: [Structured-data](<https://devfeed.tech/topics/structured-data.md>)

Tags: [partition](<https://devfeed.tech/tags/partition.md>), [partitioning](<https://devfeed.tech/tags/partitioning.md>), [partitions](<https://devfeed.tech/tags/partitions.md>), [schema](<https://devfeed.tech/tags/schema.md>), [table](<https://devfeed.tech/tags/table.md>), [window-functions](<https://devfeed.tech/tags/window-functions.md>)

## AI overview

A PostgreSQL-focused tutorial presents queries for aggregating disk usage across DDL-partitioned tables by partition set. It also discusses detailed table and index usage views and using window functions to compare historical partition-size changes.

## Source excerpt

This time, we are trying to figure out where is the bulk of the data on disk. The trick is that we're using DDL partitioning, but we want a "nice" view of size per partition set. Meaning that if you have for example a parent table foo with partitions foo_201006 and foo_201007, you would want to see a single category foo containing the accumulated size of all the partitions underneath foo.