About Measuring the Size of PostgreSQL Database and its Tables

1

$ python manage.py dbshell

1
2
3
4
5
6

> /* Show the size of the 'djangotricks' database */
> SELECT pg_size_pretty(pg_database_size('djangotricks'));
> /* List out database tables */
> \dt
> /* Show the size of the 'tricks_trick' database table */
> SELECT pg_size_pretty(pg_total_relation_size('tricks_trick'));

Tips and Tricks Dev Ops Optimization Maintenance Django 4.2 Django 3.2 Django 2.2 PostgreSQL

• Share
  on X
• Share
  on Facebook
• Share
  on LinkedIn