Advertisement
Dyrcona

vaccum analyze for miker

Jun 30th, 2022
346
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.34 KB | None | 0 0
  1. symspell_3_9=# vacuum analyze verbose search.symspell_dictionary_updates;
  2. INFO: vacuuming "search.symspell_dictionary_updates"
  3. INFO: scanned index "symspell_dictionary_updates_tid_idx" to remove 126549937 r
  4. ow versions
  5. DETAIL: CPU: user: 24.52 s, system: 5.03 s, elapsed: 368.99 s
  6. INFO: "symspell_dictionary_updates": removed 126549937 row versions in 2577239
  7. pages
  8. DETAIL: CPU: user: 6.41 s, system: 7.53 s, elapsed: 222.36 s
  9. INFO: index "symspell_dictionary_updates_tid_idx" now contains 1988981 row vers
  10. ions in 736211 pages
  11. DETAIL: 126549937 index row versions were removed.
  12. 726254 index pages have been deleted, 282954 are currently reusable.
  13. CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.12 s.
  14. INFO: "symspell_dictionary_updates": found 56947842 removable, 412627 nonremovable row versions in 2585643 out of 3574218 pages
  15. DETAIL: 379395 dead row versions cannot be removed yet, oldest xmin: 420326402
  16. There were 684136 unused item pointers.
  17. Skipped 0 pages due to buffer pins, 988575 frozen pages.
  18. 0 pages are entirely empty.
  19. CPU: user: 49.64 s, system: 25.32 s, elapsed: 1064.17 s.
  20. INFO: "symspell_dictionary_updates": stopping truncate due to conflicting lock
  21. request
  22. INFO: vacuuming "pg_toast.pg_toast_1161132600"
  23. INFO: index "pg_toast_1161132600_index" now contains 0 row versions in 1 pages
  24. DETAIL: 0 index row versions were removed.
  25. 0 index pages have been deleted, 0 are currently reusable.
  26. CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s.
  27. INFO: "pg_toast_1161132600": found 0 removable, 0 nonremovable row versions in
  28. 0 out of 0 pages
  29. DETAIL: 0 dead row versions cannot be removed yet, oldest xmin: 420326527
  30. There were 0 unused item pointers.
  31. Skipped 0 pages due to buffer pins, 0 frozen pages.
  32. 0 pages are entirely empty.
  33. CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s.
  34. INFO: analyzing "search.symspell_dictionary_updates"
  35. 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
  36.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement