Difference between revisions of "Postgres"
From Wasya Wiki
Line 1: | Line 1: | ||
+ | === Install === | ||
<pre> | <pre> | ||
brew install postgresql | brew install postgresql | ||
Line 13: | Line 14: | ||
</pre> | </pre> | ||
+ | |||
+ | === check size of each database === | ||
From: https://wiki-bsse.ethz.ch/display/ITDOC/Check+size+of+tables+and+objects+in+PostgreSQL+database | From: https://wiki-bsse.ethz.ch/display/ITDOC/Check+size+of+tables+and+objects+in+PostgreSQL+database | ||
− | |||
<pre> | <pre> | ||
SELECT | SELECT | ||
Line 23: | Line 25: | ||
</pre> | </pre> | ||
− | check size of each table | + | === check size of each table === |
<pre> | <pre> | ||
SELECT | SELECT |
Revision as of 19:18, 28 August 2018
Install
brew install postgresql brew services start postgresql psql postgres \du \q CREATE DATABASE yourdbname; CREATE USER youruser WITH ENCRYPTED PASSWORD 'yourpass'; GRANT ALL PRIVILEGES ON DATABASE yourdbname TO youruser;
check size of each database
From: https://wiki-bsse.ethz.ch/display/ITDOC/Check+size+of+tables+and+objects+in+PostgreSQL+database
SELECT pg_database.datname, pg_size_pretty(pg_database_size(pg_database.datname)) AS size FROM pg_database;
check size of each table
SELECT relname as "Table", pg_size_pretty(pg_total_relation_size(relid)) As "Size", pg_size_pretty(pg_total_relation_size(relid) - pg_relation_size(relid)) as "External Size" FROM pg_catalog.pg_statio_user_tables ORDER BY pg_total_relation_size(relid) DESC;