ayaniimi213
10/30/2013 - 1:23 PM

PostgreSQLでレコード数とサイズ（物理容量）を調べる

PostgreSQLでレコード数とサイズ（物理容量）を調べる

count.sql
content_copyfile_download
SELECT
  T2.relname,  
  cast (T2.reltuples as int) as rows,
  (relpages * 8192) as bytes 
 FROM pg_stat_user_tables AS T1 INNER JOIN pg_class AS T2 ON T1.relname = T2.relname 
 ORDER BY T2.relname;