DB‎ > ‎Postgres‎ > ‎

Check Postgres vacuum status

Thank you for visiting this page, this page has been update in another link How to check postgresql vacuum status


Quick overall vacuum status
# select relname, last_autoanalyze, last_autovacuum, last_vacuum, n_dead_tup from pg_stat_all_tables where n_dead_tup >0;
            relname            |       last_autoanalyze        |        last_autovacuum        |          last_vacuum          | n_dead_tup
-------------------------------+-------------------------------+-------------------------------+-------------------------------+------------
 lsfilerequests                | 2013-11-05 10:46:34.958263-08 | 2013-11-05 08:30:41.948894-08 | 2013-08-07 12:37:25.764722-07 |     577380
 putrequests                   | 2013-11-05 10:57:38.12804-08  | 2013-11-05 12:17:02.32787-08  | 2013-08-07 12:37:49.29728-07  |      20643
 lsrequests                    | 2013-11-05 12:19:08.716982-08 | 2013-11-05 12:17:49.382912-08 | 2013-08-07 12:37:35.921224-07 |      73121
 databasechangeloglock         |                               | 2013-10-25 09:07:51.198639-07 | 2013-08-07 12:37:13.204864-07 |          3
 putfilerequests               | 2013-11-05 12:21:05.988933-08 | 2013-11-05 09:53:04.372295-08 | 2013-08-07 12:37:45.845014-07 |     195913
 bringonlinerequests_protocols | 2013-11-05 11:38:25.409797-08 | 2013-11-05 07:28:03.998587-08 | 2013-08-07 12:38:51.977732-07 |        212
 srmlinkgroup                  | 2013-11-05 13:27:11.035507-08 | 2013-11-05 13:25:10.477932-08 | 2013-08-07 12:37:50.054837-07 |         27
 bringonlinerequests           | 2013-11-05 06:51:01.462639-08 | 2013-11-05 07:56:03.21122-08  | 2013-08-07 12:37:09.888681-07 |         92
 getrequests                   | 2013-11-05 08:58:39.241901-08 | 2013-11-04 13:14:26.891044-08 | 2013-08-07 12:37:14.294586-07 |     146659
 sequence                      |                               | 2013-10-25 09:07:51.57442-07  | 2013-08-07 12:37:50.051834-07 |          1
 srmspacefile                  | 2013-11-05 12:54:44.556415-08 | 2013-11-05 12:53:31.658895-08 | 2013-08-07 12:38:45.759246-07 |     149918
 srmspacemanagernextid         | 2013-11-01 23:56:08.791917-07 | 2013-11-01 23:56:08.79156-07  | 2013-08-07 12:37:50.139811-07 |         46
 pins                          | 2013-11-05 13:27:10.572394-08 | 2013-11-05 13:27:09.310669-08 | 2013-08-07 12:37:36.388938-07 |         75
 srmnextrequestid              | 2013-11-05 13:14:09.239744-08 | 2013-11-05 13:11:09.277379-08 | 2013-08-07 12:37:50.052318-07 |         39
 bringonlinefilerequests       | 2013-11-05 08:48:05.614156-08 | 2013-11-05 08:49:07.170892-08 | 2013-08-07 12:38:51.810451-07 |        423
 srmdogwatchevent              | 2013-09-30 12:45:57.737698-07 | 2013-10-25 09:07:52.276313-07 | 2013-08-07 12:37:50.059714-07 |         44
 srmspace                      | 2013-11-05 13:25:17.22365-08  | 2013-11-05 10:36:33.828165-08 | 2013-08-07 12:37:50.180998-07 |        743
 getfilerequests               | 2013-11-05 13:17:28.930209-08 | 2013-11-05 06:29:56.06292-08  | 2013-08-07 12:37:12.679561-07 |      76320
 pg_class                      | 2013-07-22 10:03:09.115077-07 | 2013-10-25 09:07:50.27487-07  | 2013-08-07 12:37:09.691778-07 |          3
 pg_attribute                  | 2013-07-22 09:58:09.571204-07 | 2013-10-15 05:57:15.561512-07 | 2013-08-07 12:37:09.861205-07 |         14
 pg_statistic                  |                               | 2013-11-05 09:45:05.766461-08 | 2013-08-07 12:37:09.687705-07 |        334
 getrequests_protocols         | 2013-11-05 06:10:02.183332-08 | 2013-11-02 19:23:44.754274-07 | 2013-08-07 12:37:27.760032-07 |     224133




Comments