Calcul stats PostgreSQL

for tablename in $(psql -U postgres -h $2 -d $1 -t -c « select table_name as _table from information_schema.tables t where t.table_schema=’sche_admin’ order by _table asc »); do

  echo $tablename

  psql -U postgres -h $2 -d $1 -c « analyze ${tablename}; »

  psql -U postgres -h $2 -d $1 -c « select count(*) ${tablename} from ${tablename}; » >> compte_pgsql.log

done

En // :

vacuumdb –port=$PORT –username=$PG_USER –analyze-only –verbose –jobs=4  $PG_DATABASE