Pages

Wednesday, June 29, 2011

PostreSQL -=- Find all row count for every tables

In order to find all row count for every tables in a database, you can type the following SELECT

SELECT schemaname,relname,n_live_tup 
  FROM pg_stat_user_tables 
  ORDER BY n_live_tup DESC;

No comments:

Post a Comment