Thursday, April 4, 2013

PostgreSQL commands

Top 10 largest relations in database:

SELECT relname, relpages FROM pg_class ORDER BY relpages DESC LIMIT 10;

Useful links

No comments:

Post a Comment