pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Jianshuo Niu <jniu@wc-group.com>
To: pgsql-performance@postgresql.org
Subject: Re: Help on my database performance
Date: Thu, 31 Jul 2003 16:08:11 -0400
Message-ID: <bgbt0n$i01$1@main.gmane.org> (raw)
References: <bgbbaa$bvt$1@main.gmane.org>
	<97qiivonvj5brg9q7ale1033fp53rupi54@4ax.com>

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






view thread (4+ messages)  latest in thread

Message-ID: <bgbt0n$i01$1@main.gmane.org>
Permalink:  ../bgbt0n$i01$1@main.gmane.org/
Also on:    postgresql.org/message-id/bgbt0n$i01$1@main.gmane.org

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-performance@postgresql.org
  Cc: jniu@wc-group.com
  Subject: Re: Help on my database performance
  In-Reply-To: <bgbt0n$i01$1@main.gmane.org>
  References: <bgbbaa$bvt$1@main.gmane.org> <97qiivonvj5brg9q7ale1033fp53rupi54@4ax.com> <bgbt0n$i01$1@main.gmane.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox