Why does vacuum table is not updating the field last_vacuum of pg_stat_user_tables?
select * from pg_stat_user_tables where relname = 'table1'; -[ RECORD 1 ]-----+------------------------------ relid | 5452445 schemaname | public relname | table1 seq_scan | 54911 seq_tup_read | 373562142 idx_scan | 2773802 idx_tup_fetch | 125909227 n_tup_ins | 889595 n_tup_upd | 530602 n_tup_del | 529037 n_tup_hot_upd | 162199 n_live_tup | 360526 n_dead_tup | 0 *last_vacuum | 2013-06-29 20:04:15.391413-04* last_autovacuum | 2013-05-01 00:55:01.970799-04 last_analyze | 2013-07-15 10:55:40.870926-04 last_autoanalyze | 2013-05-01 06:04:12.905961-04 vacuum_count | 92 autovacuum_count | 248 analyze_count | 94 autoanalyze_count | 560 psql# *vacuum analyze verbose table1;* INFO: vacuuming "public.table1" INFO: index "table1_pkey" now contains 360965 row versions in 1878 pages DETAIL: 0 index row versions were removed. 326 index pages have been deleted, 305 are currently reusable. CPU 0.00s/0.00u sec elapsed 0.00 sec. INFO: "table1": found 0 removable, 1116 nonremovable row versions in 30 out of 2286 pages DETAIL: 0 dead row versions cannot be removed yet. There were 6720 unused item pointers. 0 pages are entirely empty. CPU 0.00s/0.00u sec elapsed 0.00 sec. VACUUM select * from pg_stat_user_tables where relname = 'table1'; -[ RECORD 1 ]-----+------------------------------ relid | 5452445 schemaname | public relname | table1 seq_scan | 54911 seq_tup_read | 373562142 idx_scan | 2773802 idx_tup_fetch | 125909227 n_tup_ins | 889595 n_tup_upd | 530602 n_tup_del | 529037 n_tup_hot_upd | 162199 n_live_tup | 360526 n_dead_tup | 0 *last_vacuum | 2013-06-29 20:04:15.391413-04* last_autovacuum | 2013-05-01 00:55:01.970799-04 last_analyze | 2013-07-15 10:55:40.870926-04 last_autoanalyze | 2013-05-01 06:04:12.905961-04 vacuum_count | 92 autovacuum_count | 248 analyze_count | 94 autoanalyze_count | 560
