Search Postgresql Archives

last_vacuum field in not updated

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi,
I am using Postgresql 9.2 where I have a table "table1". I used vacuum command in that table, but last_vacuum column of pg_stat_user_tables has not been updated.
Any idea for it?

 \d table1
            Table "public.table1"
      Column      |   Type   |     Modifiers      
------------------+----------+--------------------
 batterysessionid | integer  | not null
 processedflag    | smallint | not null default 0
Indexes:
    "table1_pkey" PRIMARY KEY, btree (batterysessionid)

qualitycore=# select * from pg_stat_user_tables  where last_vacuum = '2013-07-28 20:04:34.821115-04';
-[ RECORD 1 ]-----+------------------------------
relid             | 5452445
schemaname        | public
relname           | table1
seq_scan          | 55394
seq_tup_read      | 458097965
idx_scan          | 3056888
idx_tup_fetch     | 345092348
n_tup_ins         | 1023618
n_tup_upd         | 643602
n_tup_del         | 642037
n_tup_hot_upd     | 175225
n_live_tup        | 381549
n_dead_tup        | 77130
last_vacuum       | 2013-07-28 20:04:34.821115-04
last_autovacuum   | 2013-05-01 00:55:01.970799-04
last_analyze      | 2013-07-28 20:04:34.903569-04
last_autoanalyze  | 2013-05-01 06:04:12.905961-04
vacuum_count      | 93
autovacuum_count  | 248
analyze_count     | 95
autoanalyze_count | 560

qualitycore=# vacuum  table1;
VACUUM
qualitycore=# vacuum  verbose table1;
INFO:  vacuuming "public.table1"
INFO:  index "table1_pkey" now contains 381973 row versions in 1878 pages
DETAIL:  0 index row versions were removed.
104 index pages have been deleted, 103 are currently reusable.
CPU 0.00s/0.00u sec elapsed 0.00 sec.
INFO:  "table1": found 0 removable, 1120 nonremovable row versions in 10 out of 2286 pages
DETAIL:  0 dead row versions cannot be removed yet.
There were 1538 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 last_vacuum = '2013-07-28 20:04:34.821115-04';
-[ RECORD 1 ]-----+------------------------------
relid             | 5452445
schemaname        | public
relname           | table1
seq_scan          | 55394
seq_tup_read      | 458097965
idx_scan          | 3056888
idx_tup_fetch     | 345092348
n_tup_ins         | 1023618
n_tup_upd         | 643602
n_tup_del         | 642037
n_tup_hot_upd     | 175225
n_live_tup        | 381549
n_dead_tup        | 77130
last_vacuum       | 2013-07-28 20:04:34.821115-04
last_autovacuum   | 2013-05-01 00:55:01.970799-04
last_analyze      | 2013-07-28 20:04:34.903569-04
last_autoanalyze  | 2013-05-01 06:04:12.905961-04
vacuum_count      | 93
autovacuum_count  | 248
analyze_count     | 95
autoanalyze_count | 560

Please let me know.

Thanks.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux