Interpreting vacuum verbosity

From: "Ed L(dot)" <pgsql(at)bluepolka(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Interpreting vacuum verbosity
Date: 2004-05-07 03:35:29
Message-ID: 200405061956.49734.pgsql@bluepolka.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2004-05-07 03:39:42 Re: XID Data Types
Previous Message Jan Wieck 2004-05-07 03:12:02 Re: XID Data Types