Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- INFO: vacuuming "public.test_table"
- INFO: "test_table": removed 74 row versions in 19 pages
- INFO: "test_table": found 74 removable, 3931 nonremovable row versions in 250 out of 3045 pages
- DETAIL: 0 dead row versions cannot be removed yet.
- There were 539 unused item pointers.
- 0 pages are entirely empty.
- CPU 0.00s/0.00u sec elapsed 0.00 sec.
- INFO: vacuuming "pg_toast.pg_toast_65811"
- INFO: index "pg_toast_65811_index" now contains 0 row versions in 1 pages
- DETAIL: 0 index row versions were removed.
- 0 index pages have been deleted, 0 are currently reusable.
- CPU 0.00s/0.00u sec elapsed 0.00 sec.
- INFO: "pg_toast_65811": found 0 removable, 0 nonremovable row versions in 0 out of 0 pages
- DETAIL: 0 dead row versions cannot be removed yet.
- There were 0 unused item pointers.
- 0 pages are entirely empty.
- CPU 0.00s/0.00u sec elapsed 0.00 sec.
- INFO: analyzing "public.test_table"
- INFO: "test_table": scanned 3045 of 3045 pages, containing 50165 live rows and 0 dead rows; 30000 rows in sample, 50165 estimated total rows
- ---
- INFO: vacuuming "public.test_table"
- INFO: "test_table": found 0 removable, 3857 nonremovable row versions in 245 out of 3045 pages
- DETAIL: 0 dead row versions cannot be removed yet.
- There were 580 unused item pointers.
- 0 pages are entirely empty.
- CPU 0.00s/0.00u sec elapsed 0.00 sec.
- INFO: "test_table": truncated 3045 to 3042 pages
- DETAIL: CPU 0.00s/0.00u sec elapsed 0.00 sec.
- INFO: vacuuming "pg_toast.pg_toast_65811"
- INFO: index "pg_toast_65811_index" now contains 0 row versions in 1 pages
- DETAIL: 0 index row versions were removed.
- 0 index pages have been deleted, 0 are currently reusable.
- CPU 0.00s/0.00u sec elapsed 0.00 sec.
- INFO: "pg_toast_65811": found 0 removable, 0 nonremovable row versions in 0 out of 0 pages
- DETAIL: 0 dead row versions cannot be removed yet.
- There were 0 unused item pointers.
- 0 pages are entirely empty.
- CPU 0.00s/0.00u sec elapsed 0.00 sec.
- INFO: analyzing "public.test_table"
- INFO: "test_table": scanned 3042 of 3042 pages, containing 50165 live rows and 0 dead rows; 30000 rows in sample, 50165 estimated total rows
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement