vincent178/postgresql.md

Last active August 29, 2015 14:01

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/vincent178/4897cc440658880eeda2.js"></script>
Save vincent178/4897cc440658880eeda2 to your computer and use it in GitHub Desktop.

Download ZIP

postgresql admin commands

Raw

postgresql.md

find the largest table in the postgreSQL database

SELECT relname, relpages FROM pg_class ORDER BY relpages DESC LIMIT toprungsjobs_backup=> SELECT relname, relpages FROM pg_class ORDER BY relpages DESC LIMIT 5;

find size of the postgreSQL table

SELECT pg_size_pretty(pg_relation_size('pg_attribute'));

view the indexes of an existing postgreSQL table

# \d table_name