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