Re: Help on my database performance - Mailing list pgsql-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