PostgreSQL
Short link: https://jlelse.dev/s/11
Upgrades
Useful commands
- Size of database:
SELECT pg_size_pretty(pg_database_size('dbname'));
- Size of table in current database:
SELECT pg_size_pretty(pg_total_relation_size('tablename'));
SELECT pg_size_pretty(pg_database_size('dbname'));
SELECT pg_size_pretty(pg_total_relation_size('tablename'));