aboutsummaryrefslogtreecommitdiff
path: root/content/blog/miscellaneous/debug-disk-usage-postgresql.md
blob: 1826c603f7811c6893b3c4106c52c8fd434e986f (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
---
title: "Investigate postgresql disk usage"
date: 2015-11-24
description: How to investigate postgresql disk usage
tags:
  - PostgreSQL
---

## How to debug disk occupation in postgresql

- get a database oid number from `ncdu` in `/var/lib/postgresql`
- reconcile oid number and db name with : `select oid,datname from pg_database where oid=18595;`
- Then in database : `select table_name,pg_relation_size(quote_ident(table_name)) from information_schema.tables where table_schema = 'public' order by 2;`