gistfile1.txt

gis=# vacuum verbose byosm
gis-# ;
INFO:  vacuuming "public.byosm"
INFO:  "byosm": found 0 removable, 5847697 nonremovable row versions in 184163 out of 184163 pages
DETAIL:  0 dead row versions cannot be removed yet, oldest xmin: 2196
There were 0 unused item pointers.
Skipped 0 pages due to buffer pins, 0 frozen pages.
0 pages are entirely empty.
CPU: user: 0.95 s, system: 0.98 s, elapsed: 20.81 s.
INFO:  vacuuming "pg_toast.pg_toast_53381945"
INFO:  index "pg_toast_53381945_index" now contains 46503 row versions in 129 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_53381945": found 0 removable, 46503 nonremovable row versions in 10570 out of 10570 pages
DETAIL:  0 dead row versions cannot be removed yet, oldest xmin: 2197
There were 0 unused item pointers.
Skipped 0 pages due to buffer pins, 0 frozen pages.
0 pages are entirely empty.
CPU: user: 0.01 s, system: 0.01 s, elapsed: 0.03 s.
VACUUM
gis=# vacuum verbose byosm
;
INFO:  vacuuming "public.byosm"
INFO:  "byosm": found 0 removable, 8 nonremovable row versions in 1 out of 184163 pages
DETAIL:  0 dead row versions cannot be removed yet, oldest xmin: 2197
There were 0 unused item pointers.
Skipped 0 pages due to buffer pins, 184162 frozen pages.
0 pages are entirely empty.
CPU: user: 0.01 s, system: 0.00 s, elapsed: 0.01 s.
INFO:  vacuuming "pg_toast.pg_toast_53381945"
INFO:  "pg_toast_53381945": found 0 removable, 4 nonremovable row versions in 1 out of 10570 pages
DETAIL:  0 dead row versions cannot be removed yet, oldest xmin: 2197
There were 0 unused item pointers.
Skipped 0 pages due to buffer pins, 10569 frozen pages.
0 pages are entirely empty.
CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s.
VACUUM