---
title: "db-total-table-sizes"
description: "This command displays the total size of each table in the database. It is the sum of the values that `pg_table_size()` and `pg_indexes_size()` gives for each table. System tables inside `pg_catalog` and `information_schema` are not included."
type: skill
canonical_url: https://claudary.paisolsolutions.com/skills/db-total-table-sizes
source: "Claudary"
difficulty: intermediate
author: "Claude Code Knowledge Pack"
date: 2026-07-10T11:19:36.460Z
license: CC-BY-4.0
attribution: "db-total-table-sizes — Claudary (https://claudary.paisolsolutions.com/skills/db-total-table-sizes)"
---

# db-total-table-sizes
This command displays the total size of each table in the database. It is the sum of the values that `pg_table_size()` and `pg_indexes_size()` gives for each table. System tables inside `pg_catalog` and `information_schema` are not included.

## Overview

# db-total-table-sizes

This command displays the total size of each table in the database. It is the sum of the values that `pg_table_size()` and `pg_indexes_size()` gives for each table. System tables inside `pg_catalog` and `information_schema` are not included.

```
                NAME               │    SIZE
───────────────────────────────────┼─────────────
  job_run_details                  │ 395 MB
  slack_msgs                       │ 648 kB
  emails                           │ 640 kB
```

---

Source: [Claudary](https://claudary.paisolsolutions.com/skills/db-total-table-sizes) · https://claudary.paisolsolutions.com