postgresql
This is an old revision of the document!
Table of Contents
Postgresql
List tables
psql -U postgres -tA -c 'SELECT datname FROM pg_database' | sort
Get statistics
db=... ; pghost=localhost psql -U postgres -h $pghost -t -A -c "SELECT datname, tup_inserted, tup_updated, tup_deleted FROM pg_stat_database WHERE datname='$db';"
Show sizes
psql -U postgres -t -c 'SELECT datname, pg_size_pretty(pg_database_size(datname)) AS size FROM pg_database' | sort
or
psql -U postgres -t -c "SELECT datname, format('%8s MB.', pg_database_size(datname)/1000000) FROM pg_database" | sort
Show data directory
psql -U postgres -tA -c "SHOW data_directory;"
/docs/dokuwiki/data/attic/postgresql.1567158357.txt.gz · Last modified: 2019-08-30 11:45:57 by mi
