> Shared buffers is probably too high.  How much memory in this machine?
> Is there anything else running aside from PostgreSQL?  What does top say
> about cached / buffered data (number)

I was using the 25% of RAM guideline posted recently.  The machine has
1.5gig but it also has a couple other java applications running on it
including tomcat.

  1:56pm  up 6 days,  2:58,  6 users,  load average: 2.60, 2.07, 1.78
193 processes: 191 sleeping, 2 running, 0 zombie, 0 stopped
CPU0 states: 14.0% user,  9.0% system,  0.0% nice, 75.1% idle
CPU1 states: 31.0% user,  0.1% system,  0.0% nice, 67.0% idle
CPU2 states:  5.0% user,  0.1% system,  0.1% nice, 93.0% idle
CPU3 states:  0.0% user,  0.1% system,  0.1% nice, 98.0% idle
Mem:  1547572K av, 1537848K used,    9724K free,       0K shrd,   25104K
buff
Swap: 1044216K av,   51352K used,  992864K free                 1245460K
cached

  PID USER     PRI  NI  SIZE  RSS SHARE STAT %CPU %MEM   TIME COMMAND
10184 veriguar   9   0 94760  83M  2612 S    36.5  5.5  13:29 java
 8990 postgres  17   0 54864  53M 53096 R    11.5  3.5   0:00 postmaster
 8988 veriguar  11   0  1164 1164   836 R     1.9  0.0   0:00 top
10161 veriguar  13   5 69504  60M  2600 S N   0.9  3.9  13:11 java
10206 veriguar  13   5 27952  23M  2580 S N   0.9  1.5   7:21 java
10699 postgres   9   0 31656  30M 30396 S     0.9  2.0   0:02 postmaster

             total       used       free     shared    buffers     cached
Mem:       1547572    1532024      15548          0      23820    1239024
-/+ buffers/cache:     269180    1278392
Swap:      1044216      51368     992848

> I see you reduced the random_page_cost to 1.5.  Why did you do this (how
> is your disk subsystem configured)?

Someone suggested I lower it to 1.5 or 1.0, not sure what the reasoning was.
The disks are both SCSI 10,000 RPM.  My data directory is on one disk by
itself, and the pg_xlog is on the other disk as well as the operating system
and everything else.  I was told it's best to have them on seperate disks,
however I'm wondering because my system only has two disks and the one with
the operating system isn't big enough to hold my database therefore I must
put my DB on the 2nd disk and if pg_xlog is to be separate, it has to be
with the OS & Java apps.

> Standard questions, did you VACUUM? Regularly?  Want to try again and
> send us the output from VACUUM VERBOSE?

I vacuum the monitor table every 5 minutes and I do a vacuum full analyze
every night at midnight (cron job).
I just did a vacuum verbose, output is attached.

> Sounds like you created a ton of test data, then removed a bunch?  Did
> you REINDEX that table?

I haven't deleted any of the data, I've been continuously adding new data.
I added about 6 million rows at once, and they all had the same date.  Since
then my application has been stress testing over about 2 weeks now so
there's now 7693057 rows in monitorstatusx and monitorstatusitemx as well as
the necessary rows for the join tables.

> During normal use, what is your query spread like?  Mostly selects with
> some inserts?  Any updates or deletes?  How often to updates or deletes
> come in, and how many rows do they effect?

There is a query on monitorx by datex every 10 seconds (monitors are updated
every 5 minutes, so every 10 seconds I get the monitors that are due for an
update).  Each monitor is then saved with its status field modified, and a
new status item is inserted.  This happens every 5 minutes.  There are 8-16
monitors being run in parallel, although typically it's 8 or less.  This is
the main application.  The reporting application does a few queries but
nothing major except the query that is the subject of this email.  It's the
reporting app that is slow due to this one big query.  Finally the web app
executes the same query as the reporting app, except there is a lot less
data to be returned since it's only for the current day.

> >                            ->  Index Scan using
> monitorstatusxmonitori on
> > monitorstatusx ms  (cost=0.00..5996.18 rows=163 width=84) (actual
> > time=4383.38..14936.39 rows=225 loops=1)
> >                                  Index Cond: ("outer".jdoidx =
> ms.monitorx)
> >                                  Filter: ((datex >= '2003-07-01
> > 00:00:00'::timestamp without time zone) AND (datex <= '2003-07-01
> > 23:59:59'::timestamp without time zone))
>
> The above index scan is taking a vast majority of the time (nearly 15
> seconds of the 16 second total -- stop thinking about sorts!)..  What
> happened to the index on monitorx and datex?

I just did

reindex table monitorstatux;

which didn't help, in fact query times went up.  I then did

create index monitorstatus_monitor_date_i on monitorstatusx(monitorx,
datex);

and this seemed to help a little:


QUERY PLAN
----------------------------------------------------------------------------
----------------------------------------------------------------------------
----------------------------------------------------------------
 Sort  (cost=1133.13..1133.38 rows=98 width=827) (actual
time=9754.06..9754.25 rows=226 loops=1)
   Sort Key: ms.datex
   ->  Nested Loop  (cost=0.00..1129.90 rows=98 width=827) (actual
time=50.81..9753.17 rows=226 loops=1)
         ->  Nested Loop  (cost=0.00..833.47 rows=98 width=162) (actual
time=50.74..7149.28 rows=226 loops=1)
               ->  Nested Loop  (cost=0.00..537.04 rows=98 width=146)
(actual time=50.67..4774.45 rows=226 loops=1)
                     ->  Nested Loop  (cost=0.00..240.44 rows=98 width=130)
(actual time=50.61..1515.10 rows=226 loops=1)
                           ->  Index Scan using monitorx_id_index on
monitorx mx  (cost=0.00..3.45 rows=1 width=46) (actual time=0.09..0.11
rows=1 loops=1)
                                 Index Cond: (idx =
'M-TEST_170-TEST_00_10560857890510173779233'::character varying)
                           ->  Index Scan using monitorstatus_monitor_date_i
on monitorstatusx ms  (cost=0.00..234.93 rows=165 width=84) (actual
time=50.51..1513.21 rows=226 loops=1)
                                 Index Cond: (("outer".jdoidx = ms.monitorx)
AND (ms.datex >= '2003-07-01 00:00:00'::timestamp without time zone) AND
(ms.datex <= '2003-07-01 23:59:59'::timestamp without time zone))
                     ->  Index Scan using monitorstatus_stjdoidb742c9b3i on
monitorstatus_statusitemsx mssisx  (cost=0.00..3.01 rows=1 width=16) (actual
time=14.40..14.41 rows=1 loops=226)
                           Index Cond: ("outer".jdoidx = mssisx.jdoidx)
               ->  Index Scan using monitorstatusitejdoid7db0befci on
monitorstatusitemlistd8ea58a5x litem  (cost=0.00..3.01 rows=1 width=16)
(actual time=10.49..10.49 rows=1 loops=226)
                     Index Cond: ("outer".statusitemsx = litem.jdoidx)
         ->  Index Scan using monitorstatusitemx_pkey on monitorstatusitemx
msi  (cost=0.00..3.01 rows=1 width=665) (actual time=11.50..11.50 rows=1
loops=226)
               Index Cond: ("outer".statusitemlistx = msi.jdoidx)
 Total runtime: 9754.64 msec
(17 rows)

Before I guess the index with monitorx,datex didn't do much because all the
data had the same date.  But now that I have over 2 weeks of real data, it
makes a difference.

Thanks,
Michael
LOG:  query: vacuum verbose;
INFO:  --Relation pg_catalog.pg_description--
LOG:  statement: vacuum verbose;
INFO:  Pages 12: Changed 0, Empty 0; Tup 1390: Vac 0, Keep 0, UnUsed 1.
        Total CPU 0.00s/0.00u sec elapsed 0.11 sec.
LOG:  statement: vacuum verbose;
INFO:  --Relation pg_toast.pg_toast_16416--
LOG:  statement: vacuum verbose;
INFO:  Pages 0: Changed 0, Empty 0; Tup 0: Vac 0, Keep 0, UnUsed 0.
        Total CPU 0.00s/0.00u sec elapsed 0.00 sec.
LOG:  statement: vacuum verbose;
INFO:  --Relation pg_catalog.pg_group--
LOG:  statement: vacuum verbose;
INFO:  Pages 0: Changed 0, Empty 0; Tup 0: Vac 0, Keep 0, UnUsed 0.
        Total CPU 0.00s/0.00u sec elapsed 0.00 sec.
LOG:  statement: vacuum verbose;
INFO:  --Relation pg_toast.pg_toast_1261--
LOG:  statement: vacuum verbose;
INFO:  Pages 0: Changed 0, Empty 0; Tup 0: Vac 0, Keep 0, UnUsed 0.
        Total CPU 0.00s/0.00u sec elapsed 0.00 sec.
LOG:  statement: vacuum verbose;
INFO:  --Relation pg_catalog.pg_proc--
LOG:  statement: vacuum verbose;
INFO:  Pages 58: Changed 0, Empty 0; Tup 1492: Vac 0, Keep 0, UnUsed 165.
        Total CPU 0.00s/0.01u sec elapsed 0.13 sec.
LOG:  statement: vacuum verbose;
INFO:  --Relation pg_toast.pg_toast_1255--
LOG:  statement: vacuum verbose;
INFO:  Pages 0: Changed 0, Empty 0; Tup 0: Vac 0, Keep 0, UnUsed 0.
        Total CPU 0.00s/0.00u sec elapsed 0.00 sec.
LOG:  statement: vacuum verbose;
INFO:  --Relation pg_catalog.pg_rewrite--
LOG:  statement: vacuum verbose;
INFO:  Pages 4: Changed 0, Empty 0; Tup 29: Vac 0, Keep 0, UnUsed 0.
        Total CPU 0.00s/0.00u sec elapsed 0.00 sec.
LOG:  statement: vacuum verbose;
INFO:  --Relation pg_toast.pg_toast_16410--
LOG:  statement: vacuum verbose;
INFO:  Pages 4: Changed 0, Empty 0; Tup 16: Vac 0, Keep 0, UnUsed 1.
        Total CPU 0.00s/0.00u sec elapsed 0.03 sec.
LOG:  statement: vacuum verbose;
INFO:  --Relation pg_catalog.pg_type--
LOG:  statement: vacuum verbose;
INFO:  Pages 4: Changed 0, Empty 0; Tup 195: Vac 0, Keep 0, UnUsed 2.
        Total CPU 0.00s/0.00u sec elapsed 0.02 sec.
LOG:  statement: vacuum verbose;
INFO:  --Relation pg_catalog.pg_attribute--
LOG:  statement: vacuum verbose;
INFO:  Pages 19: Changed 0, Empty 0; Tup 1140: Vac 0, Keep 0, UnUsed 19.
        Total CPU 0.00s/0.00u sec elapsed 0.05 sec.
LOG:  statement: vacuum verbose;
INFO:  --Relation pg_catalog.pg_class--
LOG:  statement: vacuum verbose;
INFO:  Pages 4: Changed 0, Empty 0; Tup 180: Vac 0, Keep 0, UnUsed 32.
        Total CPU 0.00s/0.00u sec elapsed 0.00 sec.
LOG:  statement: vacuum verbose;
INFO:  --Relation pg_catalog.pg_inherits--
LOG:  statement: vacuum verbose;
INFO:  Pages 0: Changed 0, Empty 0; Tup 0: Vac 0, Keep 0, UnUsed 0.
        Total CPU 0.00s/0.00u sec elapsed 0.00 sec.
LOG:  statement: vacuum verbose;
INFO:  --Relation pg_catalog.pg_index--
LOG:  statement: vacuum verbose;
INFO:  Pages 3: Changed 0, Empty 0; Tup 94: Vac 0, Keep 0, UnUsed 3.
        Total CPU 0.00s/0.00u sec elapsed 0.00 sec.
LOG:  statement: vacuum verbose;
INFO:  --Relation pg_catalog.pg_operator--
LOG:  statement: vacuum verbose;
INFO:  Pages 13: Changed 0, Empty 0; Tup 643: Vac 0, Keep 0, UnUsed 0.
        Total CPU 0.00s/0.00u sec elapsed 0.00 sec.
LOG:  statement: vacuum verbose;
INFO:  --Relation pg_catalog.pg_opclass--
LOG:  statement: vacuum verbose;
INFO:  Pages 1: Changed 0, Empty 0; Tup 51: Vac 0, Keep 0, UnUsed 0.
        Total CPU 0.00s/0.00u sec elapsed 0.00 sec.
LOG:  statement: vacuum verbose;
INFO:  --Relation pg_catalog.pg_am--
LOG:  statement: vacuum verbose;
INFO:  Pages 1: Changed 0, Empty 0; Tup 4: Vac 0, Keep 0, UnUsed 0.
        Total CPU 0.00s/0.00u sec elapsed 0.00 sec.
LOG:  statement: vacuum verbose;
INFO:  --Relation pg_catalog.pg_amop--
LOG:  statement: vacuum verbose;
INFO:  Pages 1: Changed 0, Empty 0; Tup 180: Vac 0, Keep 0, UnUsed 0.
        Total CPU 0.00s/0.00u sec elapsed 0.00 sec.
LOG:  statement: vacuum verbose;
INFO:  --Relation pg_catalog.pg_amproc--
LOG:  statement: vacuum verbose;
INFO:  Pages 1: Changed 0, Empty 0; Tup 57: Vac 0, Keep 0, UnUsed 0.
        Total CPU 0.00s/0.00u sec elapsed 0.00 sec.
LOG:  statement: vacuum verbose;
INFO:  --Relation pg_catalog.pg_language--
LOG:  statement: vacuum verbose;
INFO:  Pages 1: Changed 0, Empty 0; Tup 3: Vac 0, Keep 0, UnUsed 3.
        Total CPU 0.00s/0.00u sec elapsed 0.02 sec.
LOG:  statement: vacuum verbose;
INFO:  --Relation pg_catalog.pg_largeobject--
LOG:  statement: vacuum verbose;
INFO:  Pages 0: Changed 0, Empty 0; Tup 0: Vac 0, Keep 0, UnUsed 0.
        Total CPU 0.00s/0.00u sec elapsed 0.00 sec.
LOG:  statement: vacuum verbose;
INFO:  --Relation pg_catalog.pg_aggregate--
LOG:  statement: vacuum verbose;
INFO:  Pages 1: Changed 0, Empty 0; Tup 60: Vac 0, Keep 0, UnUsed 0.
        Total CPU 0.00s/0.00u sec elapsed 0.02 sec.
LOG:  statement: vacuum verbose;
INFO:  --Relation pg_catalog.pg_trigger--
LOG:  statement: vacuum verbose;
INFO:  Pages 1: Changed 0, Empty 0; Tup 2: Vac 0, Keep 0, UnUsed 0.
        Total CPU 0.00s/0.00u sec elapsed 0.00 sec.
LOG:  statement: vacuum verbose;
INFO:  --Relation pg_catalog.pg_listener--
LOG:  statement: vacuum verbose;
INFO:  Pages 0: Changed 0, Empty 0; Tup 0: Vac 0, Keep 0, UnUsed 0.
        Total CPU 0.00s/0.00u sec elapsed 0.00 sec.
LOG:  statement: vacuum verbose;
INFO:  --Relation pg_catalog.pg_cast--
LOG:  statement: vacuum verbose;
INFO:  Pages 2: Changed 0, Empty 0; Tup 174: Vac 0, Keep 0, UnUsed 0.
        Total CPU 0.00s/0.00u sec elapsed 0.01 sec.
LOG:  statement: vacuum verbose;
INFO:  --Relation pg_catalog.pg_namespace--
LOG:  statement: vacuum verbose;
INFO:  Pages 1: Changed 0, Empty 0; Tup 4: Vac 0, Keep 0, UnUsed 0.
        Total CPU 0.00s/0.00u sec elapsed 0.00 sec.
LOG:  statement: vacuum verbose;
INFO:  --Relation pg_catalog.pg_shadow--
LOG:  statement: vacuum verbose;
INFO:  Pages 1: Changed 0, Empty 0; Tup 1: Vac 0, Keep 0, UnUsed 1.
        Total CPU 0.00s/0.00u sec elapsed 0.00 sec.
LOG:  statement: vacuum verbose;
INFO:  --Relation pg_toast.pg_toast_1260--
LOG:  statement: vacuum verbose;
INFO:  Pages 0: Changed 0, Empty 0; Tup 0: Vac 0, Keep 0, UnUsed 0.
        Total CPU 0.00s/0.00u sec elapsed 0.00 sec.
LOG:  statement: vacuum verbose;
INFO:  --Relation pg_catalog.pg_conversion--
LOG:  statement: vacuum verbose;
INFO:  Pages 2: Changed 0, Empty 0; Tup 114: Vac 0, Keep 0, UnUsed 0.
        Total CPU 0.00s/0.00u sec elapsed 0.02 sec.
LOG:  statement: vacuum verbose;
INFO:  --Relation pg_catalog.pg_depend--
LOG:  statement: vacuum verbose;
INFO:  Pages 21: Changed 0, Empty 0; Tup 2903: Vac 0, Keep 0, UnUsed 8.
        Total CPU 0.00s/0.00u sec elapsed 0.10 sec.
LOG:  statement: vacuum verbose;
INFO:  --Relation pg_catalog.pg_attrdef--
LOG:  statement: vacuum verbose;
INFO:  Pages 0: Changed 0, Empty 0; Tup 0: Vac 0, Keep 0, UnUsed 0.
        Total CPU 0.00s/0.00u sec elapsed 0.00 sec.
LOG:  statement: vacuum verbose;
INFO:  --Relation pg_toast.pg_toast_16384--
LOG:  statement: vacuum verbose;
INFO:  Pages 0: Changed 0, Empty 0; Tup 0: Vac 0, Keep 0, UnUsed 0.
        Total CPU 0.00s/0.00u sec elapsed 0.00 sec.
LOG:  statement: vacuum verbose;
INFO:  --Relation pg_catalog.pg_constraint--
LOG:  statement: vacuum verbose;
INFO:  Pages 1: Changed 0, Empty 0; Tup 9: Vac 0, Keep 0, UnUsed 1.
        Total CPU 0.00s/0.00u sec elapsed 0.01 sec.
LOG:  statement: vacuum verbose;
INFO:  --Relation pg_toast.pg_toast_16386--
LOG:  statement: vacuum verbose;
INFO:  Pages 0: Changed 0, Empty 0; Tup 0: Vac 0, Keep 0, UnUsed 0.
        Total CPU 0.00s/0.00u sec elapsed 0.00 sec.
LOG:  statement: vacuum verbose;
INFO:  --Relation pg_catalog.pg_database--
LOG:  statement: vacuum verbose;
INFO:  Pages 1: Changed 0, Empty 0; Tup 3: Vac 0, Keep 0, UnUsed 4.
        Total CPU 0.00s/0.00u sec elapsed 0.00 sec.
LOG:  statement: vacuum verbose;
INFO:  --Relation pg_toast.pg_toast_1262--
LOG:  statement: vacuum verbose;
INFO:  Pages 0: Changed 0, Empty 0; Tup 0: Vac 0, Keep 0, UnUsed 0.
        Total CPU 0.01s/0.00u sec elapsed 0.00 sec.
LOG:  statement: vacuum verbose;
INFO:  --Relation public.customeraccountx--
LOG:  statement: vacuum verbose;
INFO:  Pages 14: Changed 0, Empty 0; Tup 589: Vac 0, Keep 0, UnUsed 16.
        Total CPU 0.00s/0.00u sec elapsed 0.08 sec.
LOG:  statement: vacuum verbose;
INFO:  --Relation pg_toast.pg_toast_17044--
LOG:  statement: vacuum verbose;
INFO:  Pages 0: Changed 0, Empty 0; Tup 0: Vac 0, Keep 0, UnUsed 0.
        Total CPU 0.00s/0.00u sec elapsed 0.00 sec.
LOG:  statement: vacuum verbose;
INFO:  --Relation public.monitorx--
LOG:  statement: vacuum verbose;
INFO:  Index monitorx_pkey: Pages 1200; Tuples 1662: Deleted 2.
        CPU 0.01s/0.00u sec elapsed 0.01 sec.
LOG:  statement: vacuum verbose;
INFO:  Index monitorxstatusi: Pages 10636; Tuples 1662: Deleted 2.
        CPU 0.04s/0.06u sec elapsed 0.09 sec.
LOG:  statement: vacuum verbose;
INFO:  Index monitorx_id_index: Pages 4252; Tuples 1662: Deleted 2.
        CPU 0.02s/0.01u sec elapsed 0.03 sec.
LOG:  statement: vacuum verbose;
INFO:  Index monitorx_nextdate_enabled_index: Pages 7715; Tuples 1662: Deleted 2.
        CPU 0.03s/0.02u sec elapsed 0.05 sec.
LOG:  statement: vacuum verbose;
INFO:  Removed 2 tuples in 2 pages.
        CPU 0.00s/0.00u sec elapsed 0.00 sec.
LOG:  statement: vacuum verbose;
INFO:  Pages 141: Changed 1, Empty 0; Tup 1662: Vac 2, Keep 160, UnUsed 2342.
        Total CPU 0.10s/0.09u sec elapsed 0.19 sec.
LOG:  statement: vacuum verbose;
INFO:  --Relation pg_toast.pg_toast_17006--
LOG:  statement: vacuum verbose;
INFO:  Pages 0: Changed 0, Empty 0; Tup 0: Vac 0, Keep 0, UnUsed 0.
        Total CPU 0.00s/0.00u sec elapsed 0.00 sec.
LOG:  statement: vacuum verbose;
INFO:  --Relation public.monitorstatusx--
LOG:  statement: vacuum verbose;
INFO:  Pages 165468: Changed 122, Empty 0; Tup 7693113: Vac 0, Keep 0, UnUsed 11.
        Total CPU 7.86s/1.35u sec elapsed 245.53 sec.
LOG:  statement: vacuum verbose;
INFO:  --Relation pg_toast.pg_toast_16995--
LOG:  statement: vacuum verbose;
INFO:  Pages 0: Changed 0, Empty 0; Tup 0: Vac 0, Keep 0, UnUsed 0.
        Total CPU 0.00s/0.00u sec elapsed 0.00 sec.
LOG:  statement: vacuum verbose;
INFO:  --Relation public.monitorgroup_monitorsx--
LOG:  statement: vacuum verbose;
INFO:  Pages 10: Changed 0, Empty 0; Tup 1503: Vac 0, Keep 0, UnUsed 47.
        Total CPU 0.00s/0.00u sec elapsed 0.48 sec.
LOG:  statement: vacuum verbose;
INFO:  --Relation pg_catalog.pg_statistic--
LOG:  statement: vacuum verbose;
INFO:  Index pg_statistic_relid_att_index: Pages 33; Tuples 242: Deleted 2839.
        CPU 0.00s/0.00u sec elapsed 0.15 sec.
LOG:  statement: vacuum verbose;
INFO:  Removed 2839 tuples in 149 pages.
        CPU 0.00s/0.03u sec elapsed 0.02 sec.
LOG:  statement: vacuum verbose;
INFO:  Pages 151: Changed 11, Empty 0; Tup 242: Vac 2839, Keep 0, UnUsed 57.
        Total CPU 0.06s/0.03u sec elapsed 2.11 sec.
LOG:  statement: vacuum verbose;
INFO:  --Relation pg_toast.pg_toast_16408--
LOG:  statement: vacuum verbose;
INFO:  Pages 0: Changed 0, Empty 0; Tup 0: Vac 0, Keep 0, UnUsed 0.
        Total CPU 0.00s/0.00u sec elapsed 0.00 sec.
LOG:  statement: vacuum verbose;
INFO:  --Relation public.monitor_monitorlocationsx--
LOG:  statement: vacuum verbose;
INFO:  Pages 14: Changed 0, Empty 0; Tup 2089: Vac 0, Keep 0, UnUsed 19.
        Total CPU 0.00s/0.00u sec elapsed 0.00 sec.
LOG:  statement: vacuum verbose;
INFO:  --Relation public.monitorgroupx--
LOG:  statement: vacuum verbose;
INFO:  Pages 14: Changed 0, Empty 0; Tup 589: Vac 0, Keep 0, UnUsed 18.
        Total CPU 0.00s/0.00u sec elapsed 0.36 sec.
LOG:  statement: vacuum verbose;
INFO:  --Relation public.companycontactx--
LOG:  statement: vacuum verbose;
INFO:  Pages 14: Changed 0, Empty 0; Tup 589: Vac 0, Keep 0, UnUsed 9.
        Total CPU 0.00s/0.00u sec elapsed 0.22 sec.
LOG:  statement: vacuum verbose;
INFO:  --Relation pg_toast.pg_toast_17030--
LOG:  statement: vacuum verbose;
INFO:  Pages 0: Changed 0, Empty 0; Tup 0: Vac 0, Keep 0, UnUsed 0.
        Total CPU 0.00s/0.00u sec elapsed 0.00 sec.
LOG:  statement: vacuum verbose;
INFO:  --Relation public.monitorstatusitemx--
LOG:  statement: vacuum verbose;
 INFO:  Pages 174853: Changed 2521, Empty 0; Tup 7691779: Vac 0, Keep 0, UnUsed 1.
        Total CPU 7.99s/1.25u sec elapsed 270.45 sec.
LOG:  statement: vacuum verbose;
INFO:  --Relation pg_toast.pg_toast_17037--
LOG:  statement: vacuum verbose;
INFO:  Pages 0: Changed 0, Empty 0; Tup 0: Vac 0, Keep 0, UnUsed 0.
        Total CPU 0.00s/0.00u sec elapsed 0.00 sec.
LOG:  statement: vacuum verbose;
INFO:  --Relation public.addressx--
LOG:  statement: vacuum verbose;
INFO:  Pages 10: Changed 0, Empty 0; Tup 589: Vac 0, Keep 0, UnUsed 0.
        Total CPU 0.00s/0.00u sec elapsed 0.07 sec.
LOG:  statement: vacuum verbose;
INFO:  --Relation pg_toast.pg_toast_17014--
LOG:  statement: vacuum verbose;
INFO:  Pages 0: Changed 0, Empty 0; Tup 0: Vac 0, Keep 0, UnUsed 0.
        Total CPU 0.00s/0.00u sec elapsed 0.00 sec.
LOG:  statement: vacuum verbose;
INFO:  --Relation public.monitorstatusitemlistx--
LOG:  statement: vacuum verbose;
INFO:  Pages 122108: Changed 1763, Empty 0; Tup 7692430: Vac 0, Keep 0, UnUsed 0.
        Total CPU 5.95s/1.07u sec elapsed 186.32 sec.
LOG:  statement: vacuum verbose;
INFO:  --Relation public.companyx--
LOG:  statement: vacuum verbose;
INFO:  Pages 10: Changed 0, Empty 0; Tup 589: Vac 0, Keep 0, UnUsed 0.
        Total CPU 0.00s/0.00u sec elapsed 0.03 sec.
LOG:  statement: vacuum verbose;
INFO:  --Relation public.monitorstatusitemlistd8ea58a5x--
LOG:  statement: vacuum verbose;
INFO:  Pages 45258: Changed 655, Empty 0; Tup 7692657: Vac 0, Keep 0, UnUsed 0.
        Total CPU 2.08s/0.67u sec elapsed 53.04 sec.
LOG:  statement: vacuum verbose;
INFO:  --Relation public.monitorstatus_statusitemsx--
LOG:  statement: vacuum verbose;
INFO:  Pages 56572: Changed 812, Empty 0; Tup 7692865: Vac 0, Keep 0, UnUsed 0.
        Total CPU 2.58s/0.75u sec elapsed 72.08 sec.
LOG:  statement: vacuum verbose;
INFO:  --Relation public.companycontact_rncies9688bceax--
LOG:  statement: vacuum verbose;
INFO:  Pages 1: Changed 0, Empty 0; Tup 10: Vac 0, Keep 0, UnUsed 0.
        Total CPU 0.00s/0.00u sec elapsed 0.00 sec.
LOG:  statement: vacuum verbose;
LOG:  duration: 851.708818 sec
VACUUM
veriguard=#
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to [EMAIL PROTECTED] so that your
      message can get through to the mailing list cleanly

Reply via email to