openqa=> vacuum VERBOSE ANALYZE comments ; INFO: vacuuming "public.comments" INFO: launched 0 parallel vacuum workers for index vacuuming (planned: 2) INFO: scanned index "comments_pkey" to remove 343 row versions DETAIL: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s INFO: scanned index "comments_idx_group_id" to remove 343 row versions DETAIL: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.02 s INFO: scanned index "comments_idx_parent_group_id" to remove 343 row versions DETAIL: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.01 s INFO: scanned index "comments_idx_user_id" to remove 343 row versions DETAIL: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.01 s INFO: scanned index "comments_idx_job_id" to remove 343 row versions DETAIL: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.02 s INFO: table "comments": removed 343 dead item identifiers in 79 pages DETAIL: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s INFO: index "comments_pkey" now contains 105830 row versions in 292 pages DETAIL: 254 index row versions were removed. 0 index pages were newly deleted. 0 index pages are currently deleted, of which 0 are currently reusable. CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s. INFO: index "comments_idx_group_id" now contains 105830 row versions in 92 pages DETAIL: 343 index row versions were removed. 0 index pages were newly deleted. 0 index pages are currently deleted, of which 0 are currently reusable. CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s. INFO: index "comments_idx_parent_group_id" now contains 105830 row versions in 93 pages DETAIL: 343 index row versions were removed. 0 index pages were newly deleted. 0 index pages are currently deleted, of which 0 are currently reusable. CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s. INFO: index "comments_idx_user_id" now contains 105830 row versions in 96 pages DETAIL: 343 index row versions were removed. 0 index pages were newly deleted. 0 index pages are currently deleted, of which 0 are currently reusable. CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s. INFO: index "comments_idx_job_id" now contains 105830 row versions in 262 pages DETAIL: 343 index row versions were removed. 0 index pages were newly deleted. 0 index pages are currently deleted, of which 0 are currently reusable. CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s. INFO: table "comments": found 231 removable, 105830 nonremovable row versions in 3629 out of 3629 pages DETAIL: 0 dead row versions cannot be removed yet, oldest xmin: 3942184491 Skipped 0 pages due to buffer pins, 0 frozen pages. CPU: user: 0.04 s, system: 0.02 s, elapsed: 0.25 s. INFO: vacuuming "pg_toast.pg_toast_16434" INFO: table "pg_toast_16434": found 0 removable, 580 nonremovable row versions in 123 out of 123 pages DETAIL: 0 dead row versions cannot be removed yet, oldest xmin: 3942184491 Skipped 0 pages due to buffer pins, 0 frozen pages. CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.02 s. INFO: analyzing "public.comments" INFO: "comments": scanned 3629 of 3629 pages, containing 105830 live rows and 0 dead rows; 30000 rows in sample, 105830 estimated total rows VACUUM openqa=> vacuum VERBOSE ANALYZE developer_sessions ; INFO: vacuuming "public.developer_sessions" INFO: table "developer_sessions": found 9 removable, 636 nonremovable row versions in 5 out of 5 pages DETAIL: 0 dead row versions cannot be removed yet, oldest xmin: 3942201518 Skipped 0 pages due to buffer pins, 0 frozen pages. CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s. INFO: analyzing "public.developer_sessions" INFO: "developer_sessions": scanned 5 of 5 pages, containing 636 live rows and 0 dead rows; 636 rows in sample, 636 estimated total rows VACUUM openqa=> vacuum VERBOSE ANALYZE workers; INFO: vacuuming "public.workers" INFO: table "workers": index scan bypassed: 58 pages from table (1.38% of total) have 1001 dead item identifiers INFO: launched 0 parallel vacuum workers for index cleanup (planned: 2) INFO: table "workers": found 442 removable, 628 nonremovable row versions in 107 out of 4216 pages DETAIL: 127 dead row versions cannot be removed yet, oldest xmin: 3942209346 Skipped 0 pages due to buffer pins, 4106 frozen pages. CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.03 s. INFO: vacuuming "pg_toast.pg_toast_16737" INFO: table "pg_toast_16737": found 0 removable, 0 nonremovable row versions in 0 out of 0 pages DETAIL: 0 dead row versions cannot be removed yet, oldest xmin: 3942209346 Skipped 0 pages due to buffer pins, 0 frozen pages. CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.01 s. INFO: analyzing "public.workers" INFO: "workers": scanned 4216 of 4216 pages, containing 505 live rows and 1136 dead rows; 505 rows in sample, 505 estimated total rows VACUUM openqa=> vacuum VERBOSE ANALYZE gru_dependencies ; INFO: vacuuming "public.gru_dependencies" INFO: table "gru_dependencies": found 0 removable, 0 nonremovable row versions in 0 out of 0 pages DETAIL: 0 dead row versions cannot be removed yet, oldest xmin: 3942221187 Skipped 0 pages due to buffer pins, 0 frozen pages. CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s. INFO: analyzing "public.gru_dependencies" INFO: "gru_dependencies": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows VACUUM openqa=> vacuum VERBOSE ANALYZE job_networks ; INFO: vacuuming "public.job_networks" INFO: scanned index "job_networks_pkey" to remove 8 row versions DETAIL: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s INFO: scanned index "job_networks_idx_job_id" to remove 8 row versions DETAIL: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s INFO: table "job_networks": removed 8 dead item identifiers in 2 pages DETAIL: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s INFO: index "job_networks_pkey" now contains 120 row versions in 5 pages DETAIL: 8 index row versions were removed. 0 index pages were newly deleted. 1 index pages are currently deleted, of which 1 are currently reusable. CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s. INFO: index "job_networks_idx_job_id" now contains 120 row versions in 4 pages DETAIL: 8 index row versions were removed. 0 index pages were newly deleted. 0 index pages are currently deleted, of which 0 are currently reusable. CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s. INFO: table "job_networks": found 8 removable, 120 nonremovable row versions in 2 out of 2 pages DETAIL: 0 dead row versions cannot be removed yet, oldest xmin: 3942231361 Skipped 0 pages due to buffer pins, 0 frozen pages. CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s. INFO: table "job_networks": truncated 2 to 1 pages DETAIL: CPU: user: 0.01 s, system: 0.00 s, elapsed: 0.02 s INFO: vacuuming "pg_toast.pg_toast_16507" INFO: table "pg_toast_16507": found 0 removable, 0 nonremovable row versions in 0 out of 0 pages DETAIL: 0 dead row versions cannot be removed yet, oldest xmin: 3942231361 Skipped 0 pages due to buffer pins, 0 frozen pages. CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s. INFO: analyzing "public.job_networks" INFO: "job_networks": scanned 1 of 1 pages, containing 120 live rows and 0 dead rows; 120 rows in sample, 120 estimated total rows VACUUM openqa=> vacuum VERBOSE ANALYZE screenshot_links ; INFO: vacuuming "public.screenshot_links" INFO: table "screenshot_links": index scan bypassed: 1965 pages from table (0.38% of total) have 79484 dead item identifiers INFO: launched 0 parallel vacuum workers for index cleanup (planned: 1) INFO: table "screenshot_links": found 28260 removable, 96064617 nonremovable row versions in 520906 out of 520906 pages DETAIL: 0 dead row versions cannot be removed yet, oldest xmin: 3942248578 Skipped 0 pages due to buffer pins, 0 frozen pages. CPU: user: 9.46 s, system: 8.42 s, elapsed: 41.27 s. INFO: analyzing "public.screenshot_links" INFO: "screenshot_links": scanned 30000 of 520907 pages, containing 5531640 live rows and 4630 dead rows; 30000 rows in sample, 96049000 estimated total rows VACUUM