Re: Autoanalyze of the autovacuum daemon ...

> relname | last_autoanalyse | reltuples | relpages |
> n_tup_ins + n_tup_upd + n_tup_del
>
> | (from pg_stat_all_tables) | | | (from
> | pg_stat_all_tables)
>
> table1 | 2012-10-15 21:12:04.362647+02 | 2.53296e+06 | 50789 | 28542483
> table2 | 2012-10-15 18:27:30.181583+02 | 2.57144e+06 | 54833 | 31127737
> table3 | 2012-10-15 13:13:09.569758+02 | 2.58646e+06 | 63208 | 27167944
> table4 | 2012-10-15 12:05:39.094652+02 | 2.58655e+06 | 63181 | 27160409
> table5 | 2012-10-15 12:05:32.347738+02 | 2.58611e+06 | 57272 | 27171661
> table6 | 2012-10-15 10:43:40.558078+02 | 2.57925e+06 | 63145 | 27155875
> table7 | 2012-10-15 10:40:25.469625+02 | 2.59551e+06 | 57254 | 27161876
> table8 | 2012-10-15 10:25:10.776152+02 | 2.56987e+06 | 63147 | 27177907
> table9 | 2012-10-15 09:30:17.407181+02 | 2.5923e+06 | 57231 | 27152953
> table10 | 2012-10-15 08:29:25.427207+02 | 2.56237e+06 | 63085 | 31770581
> table11 | 2012-10-15 08:26:14.550742+02 | 2.56503e+06 | 63065 | 31769609
> table12 | 2012-10-15 06:39:01.737914+02 | 2.57833e+06 | 63023 | 31767543
> table13 | 2012-10-15 06:35:36.43683+02 | 2.57217e+06 | 63047 | 31759954
> table14 | 2012-10-15 05:08:02.858623+02 | 2.59068e+06 | 57119 | 27154555
> table15 | 2012-10-15 04:40:48.695142+02 | 2.57449e+06 | 63002 | 31768034
> table16 | 2012-10-10 07:51:49.625226+02 | 2.48584e+06 | 54014 | 22110223
> table17 | 2012-10-09 10:03:36.649331+02 | 2.58047e+06 | 63742 | 23423257
> table18 | 2012-10-09 10:02:13.549362+02 | 2.57854e+06 | 63585 | 23364035
> table19 | 2012-10-09 09:18:55.447895+02 | 2.58851e+06 | 63516 | 23375180

So that an auto-ANALYZE should run each 2.5-3 hours.
If it does not proceed, check that you do not have some process still doing
manual maintenance or DDL on those tables, they might lock the table and kill
autovacuum
(check the pg_stat_activity, and set log_autovacuum_min_duration=0 to track
all job done by autovacuum)

--
Cédric Villemain +33 (0)6 20 30 22 52
http://2ndQuadrant.fr/
PostgreSQL: Support 24x7 - Développement, Expertise et Formation