Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- symspell_3_9=# vacuum analyze verbose search.symspell_dictionary_updates;
- INFO: vacuuming "search.symspell_dictionary_updates"
- INFO: scanned index "symspell_dictionary_updates_tid_idx" to remove 126549937 r
- ow versions
- DETAIL: CPU: user: 24.52 s, system: 5.03 s, elapsed: 368.99 s
- INFO: "symspell_dictionary_updates": removed 126549937 row versions in 2577239
- pages
- DETAIL: CPU: user: 6.41 s, system: 7.53 s, elapsed: 222.36 s
- INFO: index "symspell_dictionary_updates_tid_idx" now contains 1988981 row vers
- ions in 736211 pages
- DETAIL: 126549937 index row versions were removed.
- 726254 index pages have been deleted, 282954 are currently reusable.
- CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.12 s.
- INFO: "symspell_dictionary_updates": found 56947842 removable, 412627 nonremovable row versions in 2585643 out of 3574218 pages
- DETAIL: 379395 dead row versions cannot be removed yet, oldest xmin: 420326402
- There were 684136 unused item pointers.
- Skipped 0 pages due to buffer pins, 988575 frozen pages.
- 0 pages are entirely empty.
- CPU: user: 49.64 s, system: 25.32 s, elapsed: 1064.17 s.
- INFO: "symspell_dictionary_updates": stopping truncate due to conflicting lock
- request
- INFO: vacuuming "pg_toast.pg_toast_1161132600"
- INFO: index "pg_toast_1161132600_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: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s.
- INFO: "pg_toast_1161132600": found 0 removable, 0 nonremovable row versions in
- 0 out of 0 pages
- DETAIL: 0 dead row versions cannot be removed yet, oldest xmin: 420326527
- There were 0 unused item pointers.
- Skipped 0 pages due to buffer pins, 0 frozen pages.
- 0 pages are entirely empty.
- CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s.
- INFO: analyzing "search.symspell_dictionary_updates"
- INFO: "symspell_dictionary_updates": scanned 30000 of 3574218 pages, containing 0 live rows and 18482 dead rows; 0 rows in sample, 0 estimated total rows
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement