INFO: vacuuming "public.job_modules" INFO: launched 2 parallel vacuum workers for index vacuuming (planned: 2) INFO: scanned index "idx_job_modules_result" to remove 561730 row versions DETAIL: CPU: user: 0.33 s, system: 0.04 s, elapsed: 0.54 s INFO: scanned index "job_modules_idx_job_id" to remove 561730 row versions DETAIL: CPU: user: 0.31 s, system: 0.07 s, elapsed: 0.54 s INFO: scanned index "job_modules_pkey" to remove 561730 row versions DETAIL: CPU: user: 0.35 s, system: 0.21 s, elapsed: 1.09 s INFO: scanned index "job_modules_job_id_name_category_script" to remove 561730 row versions DETAIL: CPU: user: 0.55 s, system: 0.65 s, elapsed: 3.47 s INFO: table "job_modules": removed 561730 dead item identifiers in 8954 pages DETAIL: CPU: user: 0.12 s, system: 0.24 s, elapsed: 1.79 s INFO: index "idx_job_modules_result" now contains 6273662 row versions in 5885 pages DETAIL: 381796 index row versions were removed. 149 index pages were newly deleted. 149 index pages are currently deleted, of which 148 are currently reusable. CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s. INFO: index "job_modules_pkey" now contains 6273662 row versions in 17318 pages DETAIL: 47058 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 "job_modules_job_id_name_category_script" now contains 6273662 row versions in 67291 pages DETAIL: 158692 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 "job_modules_idx_job_id" now contains 6273662 row versions in 5987 pages DETAIL: 172410 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_modules": found 21002 removable, 6273662 nonremovable row versions in 109624 out of 109624 pages DETAIL: 3 dead row versions cannot be removed yet, oldest xmin: 3859822006 Skipped 0 pages due to buffer pins, 0 frozen pages. CPU: user: 1.84 s, system: 1.86 s, elapsed: 10.61 s. INFO: vacuuming "pg_toast.pg_toast_16486" INFO: table "pg_toast_16486": found 0 removable, 0 nonremovable row versions in 0 out of 0 pages DETAIL: 0 dead row versions cannot be removed yet, oldest xmin: 3859822764 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_modules" INFO: "job_modules": scanned 30000 of 109624 pages, containing 1716469 live rows and 4 dead rows; 30000 rows in sample, 6272207 estimated total rows VACUUM openqa=> vacuum VERBOSE ANALYZE comments ; INFO: vacuuming "public.comments" INFO: table "comments": index scan bypassed: 7 pages from table (0.54% of total) have 11 dead item identifiers INFO: launched 1 parallel vacuum worker for index cleanup (planned: 1) INFO: table "comments": found 0 removable, 41352 nonremovable row versions in 1307 out of 1307 pages DETAIL: 0 dead row versions cannot be removed yet, oldest xmin: 3859824363 Skipped 0 pages due to buffer pins, 0 frozen pages. CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.02 s. INFO: vacuuming "pg_toast.pg_toast_16426" INFO: table "pg_toast_16426": found 0 removable, 0 nonremovable row versions in 0 out of 0 pages DETAIL: 0 dead row versions cannot be removed yet, oldest xmin: 3859824363 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.comments" INFO: "comments": scanned 1307 of 1307 pages, containing 41352 live rows and 11 dead rows; 30000 rows in sample, 41352 estimated total rows VACUUM openqa=> vacuum VERBOSE ANALYZE developer_sessions ; INFO: vacuuming "public.developer_sessions" INFO: table "developer_sessions": found 9 removable, 113 nonremovable row versions in 1 out of 1 pages DETAIL: 0 dead row versions cannot be removed yet, oldest xmin: 3859824363 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 1 of 1 pages, containing 113 live rows and 0 dead rows; 113 rows in sample, 113 estimated total rows VACUUM openqa=> vacuum VERBOSE ANALYZE workers; INFO: vacuuming "public.workers" INFO: table "workers": found 0 removable, 2426 nonremovable row versions in 55 out of 55 pages DETAIL: 2299 dead row versions cannot be removed yet, oldest xmin: 3859824363 Skipped 0 pages due to buffer pins, 0 frozen pages. CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s. INFO: vacuuming "pg_toast.pg_toast_16647" INFO: table "pg_toast_16647": found 0 removable, 0 nonremovable row versions in 0 out of 0 pages DETAIL: 0 dead row versions cannot be removed yet, oldest xmin: 3859824363 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.workers" INFO: "workers": scanned 55 of 55 pages, containing 127 live rows and 2299 dead rows; 127 rows in sample, 127 estimated total rows VACUUM openqa=> vacuum VERBOSE ANALYZE gru_dependencies ; INFO: vacuuming "public.gru_dependencies" INFO: scanned index "gru_dependencies_idx_gru_task_id" to remove 21 row versions DETAIL: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s INFO: scanned index "gru_dependencies_pkey" to remove 21 row versions DETAIL: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s INFO: scanned index "gru_dependencies_idx_job_id" to remove 21 row versions DETAIL: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s INFO: table "gru_dependencies": removed 21 dead item identifiers in 1 pages DETAIL: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s INFO: index "gru_dependencies_idx_gru_task_id" now contains 0 row versions in 2 pages DETAIL: 21 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 "gru_dependencies_pkey" now contains 0 row versions in 2 pages DETAIL: 21 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 "gru_dependencies_idx_job_id" now contains 0 row versions in 2 pages DETAIL: 21 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 "gru_dependencies": found 21 removable, 0 nonremovable row versions in 1 out of 1 pages DETAIL: 0 dead row versions cannot be removed yet, oldest xmin: 3859824363 Skipped 0 pages due to buffer pins, 0 frozen pages. CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s. INFO: "gru_dependencies": stopping truncate due to conflicting lock request INFO: analyzing "public.gru_dependencies" INFO: "gru_dependencies": scanned 1 of 1 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 30 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 30 row versions DETAIL: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s INFO: table "job_networks": removed 30 dead item identifiers in 1 pages DETAIL: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s INFO: index "job_networks_pkey" now contains 12 row versions in 2 pages DETAIL: 30 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 "job_networks_idx_job_id" now contains 12 row versions in 2 pages DETAIL: 30 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 30 removable, 12 nonremovable row versions in 1 out of 1 pages DETAIL: 2 dead row versions cannot be removed yet, oldest xmin: 3859824363 Skipped 0 pages due to buffer pins, 0 frozen pages. CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s. INFO: vacuuming "pg_toast.pg_toast_16498" INFO: table "pg_toast_16498": found 0 removable, 0 nonremovable row versions in 0 out of 0 pages DETAIL: 0 dead row versions cannot be removed yet, oldest xmin: 3859824363 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 10 live rows and 2 dead rows; 10 rows in sample, 10 estimated total rows VACUUM openqa=> vacuum VERBOSE ANALYZE screenshot_links ; INFO: vacuuming "public.screenshot_links" INFO: launched 1 parallel vacuum worker for index cleanup (planned: 1) INFO: table "screenshot_links": found 0 removable, 1183040 nonremovable row versions in 6587 out of 261702 pages DETAIL: 0 dead row versions cannot be removed yet, oldest xmin: 3859853496 Skipped 0 pages due to buffer pins, 0 frozen pages. CPU: user: 0.12 s, system: 0.11 s, elapsed: 0.33 s. INFO: analyzing "public.screenshot_links" INFO: "screenshot_links": scanned 30000 of 261702 pages, containing 5504634 live rows and 0 dead rows; 30000 rows in sample, 48019124 estimated total rows VACUUM openqa=> vacuum VERBOSE ANALYZE jobs_assets ; INFO: vacuuming "public.jobs_assets" INFO: launched 2 parallel vacuum workers for index vacuuming (planned: 2) INFO: scanned index "jobs_assets_idx_asset_id" to remove 19204 row versions DETAIL: CPU: user: 0.03 s, system: 0.00 s, elapsed: 0.10 s INFO: scanned index "jobs_assets_idx_job_id" to remove 19204 row versions DETAIL: CPU: user: 0.03 s, system: 0.01 s, elapsed: 0.13 s INFO: scanned index "jobs_assets_job_id_asset_id" to remove 19204 row versions DETAIL: CPU: user: 0.03 s, system: 0.02 s, elapsed: 0.21 s INFO: table "jobs_assets": removed 19204 dead item identifiers in 1839 pages DETAIL: CPU: user: 0.01 s, system: 0.04 s, elapsed: 0.27 s INFO: index "jobs_assets_idx_job_id" now contains 310109 row versions in 638 pages DETAIL: 19204 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 "jobs_assets_job_id_asset_id" now contains 310109 row versions in 1334 pages DETAIL: 19204 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 "jobs_assets_idx_asset_id" now contains 310109 row versions in 361 pages DETAIL: 19204 index row versions were removed. 2 index pages were newly deleted. 2 index pages are currently deleted, of which 2 are currently reusable. CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s. INFO: table "jobs_assets": found 1984 removable, 293909 nonremovable row versions in 2604 out of 2739 pages DETAIL: 0 dead row versions cannot be removed yet, oldest xmin: 3859861777 Skipped 0 pages due to buffer pins, 0 frozen pages. CPU: user: 0.08 s, system: 0.08 s, elapsed: 0.66 s. INFO: analyzing "public.jobs_assets" INFO: "jobs_assets": scanned 2739 of 2739 pages, containing 310109 live rows and 0 dead rows; 30000 rows in sample, 310109 estimated total rows VACUUM openqa=> vacuum VERBOSE ANALYZE jobs; INFO: vacuuming "public.jobs" INFO: launched 2 parallel vacuum workers for index vacuuming (planned: 2) INFO: scanned index "idx_jobs_build_group" to remove 3178 row versions DETAIL: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.02 s INFO: scanned index "idx_jobs_result" to remove 3178 row versions DETAIL: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.02 s INFO: scanned index "idx_jobs_state" to remove 3178 row versions DETAIL: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.01 s INFO: scanned index "jobs_idx_group_id" to remove 3178 row versions DETAIL: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.02 s INFO: scanned index "jobs_idx_scheduled_product_id" to remove 3178 row versions DETAIL: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.03 s INFO: scanned index "idx_jobs_scenario" to remove 3178 row versions DETAIL: CPU: user: 0.01 s, system: 0.01 s, elapsed: 0.05 s INFO: scanned index "jobs_pkey" to remove 3178 row versions DETAIL: CPU: user: 0.01 s, system: 0.00 s, elapsed: 0.02 s INFO: scanned index "jobs_idx_blocked_by_id" to remove 3178 row versions DETAIL: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.02 s INFO: scanned index "jobs_idx_clone_id" to remove 3178 row versions DETAIL: CPU: user: 0.01 s, system: 0.00 s, elapsed: 0.02 s INFO: scanned index "jobs_idx_assigned_worker_id" to remove 3178 row versions DETAIL: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.02 s INFO: index "idx_jobs_build_group" now contains 166417 row versions in 216 pages DETAIL: 2937 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 "idx_jobs_result" now contains 166417 row versions in 178 pages DETAIL: 3023 index row versions were removed. 3 index pages were newly deleted. 17 index pages are currently deleted, of which 14 are currently reusable. CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s. INFO: index "idx_jobs_scenario" now contains 166417 row versions in 535 pages DETAIL: 2635 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 "idx_jobs_state" now contains 166417 row versions in 166 pages DETAIL: 2753 index row versions were removed. 1 index pages were newly deleted. 11 index pages are currently deleted, of which 10 are currently reusable. CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s. INFO: index "jobs_idx_group_id" now contains 166417 row versions in 178 pages DETAIL: 3090 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 "jobs_idx_scheduled_product_id" now contains 166417 row versions in 207 pages DETAIL: 2809 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 "jobs_pkey" now contains 166417 row versions in 477 pages DETAIL: 1280 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 "jobs_idx_clone_id" now contains 166417 row versions in 241 pages DETAIL: 2906 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 "jobs_idx_blocked_by_id" now contains 166417 row versions in 169 pages DETAIL: 3071 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 "jobs_idx_assigned_worker_id" now contains 166417 row versions in 235 pages DETAIL: 3111 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 "jobs": found 1586 removable, 65896 nonremovable row versions in 4060 out of 10908 pages DETAIL: 2 dead row versions cannot be removed yet, oldest xmin: 3860498547 Skipped 0 pages due to buffer pins, 1721 frozen pages. CPU: user: 0.05 s, system: 0.05 s, elapsed: 0.18 s. INFO: vacuuming "pg_toast.pg_toast_16517" INFO: table "pg_toast_16517": found 0 removable, 0 nonremovable row versions in 0 out of 0 pages DETAIL: 0 dead row versions cannot be removed yet, oldest xmin: 3860498560 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.jobs" INFO: "jobs": scanned 10908 of 10908 pages, containing 166417 live rows and 9 dead rows; 30000 rows in sample, 166417 estimated total rows VACUUM