Interpreting vacuum verbosity - Mailing list pgsql-general

From Ed L.
Subject Interpreting vacuum verbosity
Date
Msg-id 200405061956.49734.pgsql@bluepolka.net
Whole thread Raw
Responses Re: Interpreting vacuum verbosity
List pgsql-general
If I see VACUUM ANALYZE VERBOSE output like this...

INFO:  --Relation public.foo--
INFO:  Index idx_foo_bar: Pages 219213; Tuples 28007: Deleted 9434.
        CPU 17.05s/4.58u sec elapsed 3227.62 sec.

...am I correct in reading this to say that it took more than 53 minutes
(3227 secs) to get 17 seconds of CPU time?  Is this an indicator of
possible I/O contention?  What else would account for this if my CPUs are
clearly not very busy?

TIA.


pgsql-general by date:

Previous
From: Jan Wieck
Date:
Subject: Re: XID Data Types
Next
From: Tom Lane
Date:
Subject: Re: XID Data Types