「PostgreSQL」データベースのサイズを一覧で取得する

環境
Windows10 64bit
PostgreSQL 9.6.5

操作方法

1.データベースのサイズを一覧で取得します。
SQL構文

Plain text
Copy to clipboard
Open code in new window
EnlighterJS 3 Syntax Highlighter
SELECT
datname databasename,
pg_size_pretty(pg_database_size(datname)) size
FROM pg_database
SELECT datname databasename, pg_size_pretty(pg_database_size(datname)) size FROM pg_database
SELECT 
    datname databasename,
    pg_size_pretty(pg_database_size(datname))  size
FROM pg_database

実行結果

Plain text
Copy to clipboard
Open code in new window
EnlighterJS 3 Syntax Highlighter
databasename size
postgres     7017 kB
template1     6945 kB
template0     6945 kB
testdb         6945 kB
databasename size postgres     7017 kB template1     6945 kB template0     6945 kB testdb         6945 kB
databasename	size
postgres	    7017 kB
template1	    6945 kB
template0	    6945 kB
testdb	        6945 kB

2.指定データベースのサイズを取得します
SQL構文

Plain text
Copy to clipboard
Open code in new window
EnlighterJS 3 Syntax Highlighter
SELECT
datname databasename,
pg_size_pretty(pg_database_size(datname)) size
FROM pg_database where datname='testdb'
SELECT datname databasename, pg_size_pretty(pg_database_size(datname)) size FROM pg_database where datname='testdb'
SELECT 
    datname databasename,
    pg_size_pretty(pg_database_size(datname))  size
FROM pg_database where datname='testdb'

実行結果

Plain text
Copy to clipboard
Open code in new window
EnlighterJS 3 Syntax Highlighter
databasename size
testdb 6945 kB
databasename size testdb 6945 kB
databasename	size
testdb	        6945 kB

 

PostgreSQL

Posted by arkgame