pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Chris Hoover <revoohc@sermonaudio.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-performance@postgresql.org
Subject: Re: Help with performance problems
Date: Mon, 26 Apr 2004 13:20:56 -0400
Message-ID: <200404261320.56455.revoohc@sermonaudio.com> (raw)
In-Reply-To: <6865.1082775504@sss.pgh.pa.us>
References: <200404230931.17850.revoohc@sermonaudio.com>
	<6865.1082775504@sss.pgh.pa.us>

Ok, I was able to run a vacuumdb -f -v on my largest db over the weekend.  
However, I am having trouble reading the results of the table portion.  Here 
area a couple of tables, what should I be looking at.  First table is the key 
table to the db, and the second is the largest table in the db.  

Thanks Chris

INFO:  --Relation public.clmhdr--
INFO:  Pages 32191: Changed 0, reaped 5357, Empty 0, New 0; Tup 339351: Vac 
48358, Keep/VTL 0/0, UnUsed 129, MinLen 560, MaxLen 696; Re-using: Free/Av
ail. Space 42011004/32546120; EndEmpty/Avail. Pages 0/5310.
        CPU 0.53s/0.09u sec elapsed 0.61 sec.
INFO:  Index clmhdr_pkey: Pages 1429; Tuples 339351: Deleted 48358.
        CPU 0.06s/0.28u sec elapsed 4.54 sec.
INFO:  Index clmhdr_hdr_user_id_idx: Pages 1711; Tuples 339351: Deleted 48358.
        CPU 0.09s/0.31u sec elapsed 2.40 sec.
INFO:  Index clmhdr_hdr_clm_status_idx: Pages 1237; Tuples 339351: Deleted 
48358.
        CPU 0.03s/0.26u sec elapsed 1.66 sec.
INFO:  Index clmhdr_hdr_create_dt_idx: Pages 1475; Tuples 339351: Deleted 
48358.
        CPU 0.05s/0.24u sec elapsed 1.96 sec.
INFO:  Index clmhdr_inv_idx: Pages 1429; Tuples 339351: Deleted 48358.
        CPU 0.08s/0.22u sec elapsed 1.20 sec.
INFO:  Index clmhdr_userid_status_idx: Pages 2161; Tuples 339351: Deleted 
48358.
        CPU 0.05s/0.18u sec elapsed 3.02 sec.
INFO:  Rel clmhdr: Pages: 32191 --> 28247; Tuple(s) moved: 8257.
        CPU 0.37s/1.81u sec elapsed 16.24 sec.
INFO:  Index clmhdr_pkey: Pages 1429; Tuples 339351: Deleted 8257.
        CPU 0.00s/0.03u sec elapsed 0.03 sec.
INFO:  Index clmhdr_hdr_user_id_idx: Pages 1743; Tuples 339351: Deleted 8257.
        CPU 0.00s/0.05u sec elapsed 0.04 sec.
INFO:  Index clmhdr_hdr_clm_status_idx: Pages 1265; Tuples 339351: Deleted 
8257.
        CPU 0.00s/0.04u sec elapsed 0.03 sec.
INFO:  Index clmhdr_hdr_create_dt_idx: Pages 1503; Tuples 339351: Deleted 
8257.
        CPU 0.00s/0.04u sec elapsed 0.12 sec.
INFO:  Index clmhdr_inv_idx: Pages 1429; Tuples 339351: Deleted 8257.
        CPU 0.00s/0.04u sec elapsed 0.03 sec.
INFO:  Index clmhdr_userid_status_idx: Pages 2203; Tuples 339351: Deleted 
8257.
        CPU 0.01s/0.03u sec elapsed 0.04 sec.

INFO:  --Relation public.sent837--
INFO:  Pages 463552: Changed 0, reaped 6690, Empty 0, New 0; Tup 27431539: Vac 
204348, Keep/VTL 0/0, UnUsed 2801, MinLen 107, MaxLen 347; Re-using: 
Free/Avail. Space 54541468/34925860; EndEmpty/Avail. Pages 0/70583.
        CPU 10.68s/2.18u sec elapsed 188.32 sec.
INFO:  Index sent837_pkey: Pages 124424; Tuples 27431539: Deleted 204348.
        CPU 4.24s/3.45u sec elapsed 144.79 sec.
INFO:  Rel sent837: Pages: 463552 --> 459954; Tuple(s) moved: 91775.
        CPU 1.12s/9.36u sec elapsed 20.13 sec.
INFO:  Index sent837_pkey: Pages 124424; Tuples 27431539: Deleted 91775.
        CPU 3.51s/2.03u sec elapsed 6.13 sec.




view thread (14+ messages)

Message-ID: <200404261320.56455.revoohc@sermonaudio.com>
Permalink:  ../200404261320.56455.revoohc@sermonaudio.com/
Also on:    postgresql.org/message-id/200404261320.56455.revoohc@sermonaudio.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: revoohc@sermonaudio.com, tgl@sss.pgh.pa.us
  Subject: Re: Help with performance problems
  In-Reply-To: <200404261320.56455.revoohc@sermonaudio.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox