X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id CC22FD1C9E1 for ; Thu, 31 Jul 2003 20:14:29 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 75816-08 for ; Thu, 31 Jul 2003 17:13:25 -0300 (ADT) Received: from main.gmane.org (main.gmane.org [80.91.224.249]) by svr1.postgresql.org (Postfix) with ESMTP id DEAB7D1C9DA for ; Thu, 31 Jul 2003 17:14:27 -0300 (ADT) Received: from list by main.gmane.org with local (Exim 3.35 #1 (Debian)) id 19iJlx-00050T-00 for ; Thu, 31 Jul 2003 22:11:37 +0200 X-Injected-Via-Gmane: http://gmane.org/ To: pgsql-performance@postgresql.org Received: from news by main.gmane.org with local (Exim 3.35 #1 (Debian)) id 19iJjM-0004nL-00 for ; Thu, 31 Jul 2003 22:08:56 +0200 From: "Jianshuo Niu" Subject: Re: Help on my database performance Date: Thu, 31 Jul 2003 16:08:11 -0400 Lines: 32 Message-ID: References: <97qiivonvj5brg9q7ale1033fp53rupi54@4ax.com> X-Complaints-To: usenet@main.gmane.org X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2800.1158 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200307/505 X-Sequence-Number: 2798 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