Re: Help on my database performance

Dear Manfred:

Thank you so much for your response. vacuum full anaylze works!
explain analyze select count(*) from tfd_catalog ;
NOTICE: QUERY PLAN:

explain analyze select count(*) from tfd_catalog ;
NOTICE: QUERY PLAN:

Aggregate (cost=15986.02..15986.02 rows=1 width=0) (actual
time=1089.99..1089.9
9 rows=1 loops=1)
-> Seq Scan on tfd_catalog (cost=0.00..15582.82 rows=161282 width=0)
(actual
time=0.11..833.41 rows=161282 loops=1)
Total runtime: 1090.51 msec

EXPLAIN -> Seq Scan on tfd_catalog (cost=0.00..15582.82 rows=161282
width=0) (actual
time=0.11..833.41 rows=161282 loops=1)
Total runtime: 1090.51 msec

Could you tell me what does "Aggregate (cost=15986.02..15986.02 rows=1
width=0) (actual time=1089.99..1089.99 rows=1 loops=1)" mean? It does not
show in my previous report.

I appreicate it.

Josh