|
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
|
|
|
