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 |