Skip site navigation (1) Skip section navigation (2)

Re: sloooow query

From: "Marie G(dot) Tuite" <marie(dot)tuite(at)edisonaffiliates(dot)com>
To: <josh(at)agliodbs(dot)com>, <pgsql-performance(at)postgresql(dot)org>
Subject: Re: sloooow query
Date: 2002-10-07 20:34:11
Message-ID: IGELKLINGDMODABPOOFECEBECJAA.marie.tuite@edisonaffiliates.com (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-performance
> What happens if you run VACUUM FULL VERBOSE on the Bad database?  Does it
> report lots of rows taken up?

I ran the vacuum for selected tables.  It looks fine, I think, but I amn't
always sure what I am reading in output.

project=# vacuum full verbose classes;
NOTICE:  --Relation classes--
NOTICE:  Pages 5: Changed 0, reaped 2, Empty 0, New 0; Tup 332: Vac 0,
Keep/VTL 0/0, UnUsed 33, MinLen 93, MaxLen 117; Re-using: Free/Avail. Space
3020/2832; EndEmpty/Avail. Pages 0/1.
        CPU 0.00s/0.00u sec elapsed 0.00 sec.
NOTICE:  Index class_pkey: Pages 5; Tuples 332: Deleted 0.
        CPU 0.00s/0.00u sec elapsed 0.00 sec.
NOTICE:  Rel classes: Pages: 5 --> 5; Tuple(s) moved: 0.
        CPU 0.00s/0.00u sec elapsed 0.00 sec.
NOTICE:  --Relation pg_toast_595650--
NOTICE:  Pages 0: Changed 0, reaped 0, Empty 0, New 0; Tup 0: Vac 0,
Keep/VTL 0/0, UnUsed 0, MinLen 0, MaxLen 0; Re-using: Free/Avail. Space 0/0;
EndEmpty/Avail. Pages 0/0.
        CPU 0.00s/0.00u sec elapsed 0.00 sec.
NOTICE:  Index pg_toast_595650_idx: Pages 1; Tuples 0.
        CPU 0.00s/0.00u sec elapsed 0.00 sec.
VACUUM
project=# vacuum full verbose bm_publications;
NOTICE:  --Relation bm_publications--
NOTICE:  Pages 2: Changed 0, reaped 1, Empty 0, New 0; Tup 284: Vac 0,
Keep/VTL 0/0, UnUsed 6, MinLen 52, MaxLen 52; Re-using: Free/Avail. Space
416/416; EndEmpty/Avail. Pages 0/2.
        CPU 0.00s/0.00u sec elapsed 0.00 sec.
NOTICE:  Index bm_publications_pkey: Pages 4; Tuples 284: Deleted 0.
        CPU 0.00s/0.00u sec elapsed 0.00 sec.
NOTICE:  Rel bm_publications: Pages: 2 --> 2; Tuple(s) moved: 0.
        CPU 0.00s/0.01u sec elapsed 0.00 sec.
VACUUM
project=# vacuum full verbose user_common;
NOTICE:  --Relation user_common--
NOTICE:  Pages 21: Changed 0, reaped 19, Empty 0, New 0; Tup 1045: Vac 0,
Keep/VTL 0/0, UnUsed 103, MinLen 117, MaxLen 221; Re-using: Free/Avail.
Space 4080/2968; EndEmpty/Avail. Pages 0/2.
        CPU 0.00s/0.00u sec elapsed 0.00 sec.
NOTICE:  Index user_common_pkey: Pages 20; Tuples 1045: Deleted 0.
        CPU 0.01s/0.00u sec elapsed 0.00 sec.
NOTICE:  Rel user_common: Pages: 21 --> 21; Tuple(s) moved: 0.
        CPU 0.00s/0.00u sec elapsed 0.00 sec.
NOTICE:  --Relation pg_toast_474892--
NOTICE:  Pages 0: Changed 0, reaped 0, Empty 0, New 0; Tup 0: Vac 0,
Keep/VTL 0/0, UnUsed 0, MinLen 0, MaxLen 0; Re-using: Free/Avail. Space 0/0;
EndEmpty/Avail. Pages 0/0.
        CPU 0.00s/0.00u sec elapsed 0.00 sec.
NOTICE:  Index pg_toast_474892_idx: Pages 1; Tuples 0.
        CPU 0.00s/0.00u sec elapsed 0.00 sec.
VACUUM
project=# vacuum full verbose bm_subscriptions_rlt;
NOTICE:  --Relation bm_subscriptions_rlt--
NOTICE:  Pages 1: Changed 0, reaped 1, Empty 0, New 0; Tup 114: Vac 0,
Keep/VTL 0/0, UnUsed 1, MinLen 57, MaxLen 57; Re-using: Free/Avail. Space
872/872; EndEmpty/Avail. Pages 0/1.
        CPU 0.00s/0.00u sec elapsed 0.00 sec.
NOTICE:  Index bm_subscriptions_rlt_pkey: Pages 2; Tuples 114: Deleted 0.
        CPU 0.00s/0.00u sec elapsed 0.00 sec.
NOTICE:  Rel bm_subscriptions_rlt: Pages: 1 --> 1; Tuple(s) moved: 0.
        CPU 0.00s/0.00u sec elapsed 0.00 sec.
VACUUM
project=#



In response to

Responses

pgsql-performance by date

Next:From: Josh BerkusDate: 2002-10-07 20:44:31
Subject: Re: sloooow query
Previous:From: Justin CliftDate: 2002-10-07 20:15:35
Subject: Re: sloooow query

pgsql-general by date

Next:From: Tom LaneDate: 2002-10-07 20:40:36
Subject: Re: PLTCL return_null crash...
Previous:From: Justin CliftDate: 2002-10-07 20:21:10
Subject: Re: firstest doubts...

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group