Re: Statistics collection question

From: Richard Broersma Jr <rabroersma(at)yahoo(dot)com>
To: Phoenix Kiula <phoenix(dot)kiula(at)gmail(dot)com>, Alban Hertroys <alban(at)magproductions(dot)nl>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Statistics collection question
Date: 2007-09-03 16:56:28
Message-ID: 205948.60229.qm@web31806.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

--- Phoenix Kiula <phoenix(dot)kiula(at)gmail(dot)com> wrote:
> LOG: duration: 93473.282 ms statement: select t_info, dstats, id
> from trades where t_alias = '17huv' and status = 'Y'
>
> -----------------------
>
> Index Scan using trades_unique_t_alias on trades (cost=0.00..3.41

> Time: 2.990 ms

Thats odd, I wonder why the EXPLAIN ANALYZE time id some much less that the logged select
statement times?

Regards,
Richard Broersma Jr.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Phoenix Kiula 2007-09-03 17:19:04 Re: Statistics collection question
Previous Message Henrik 2007-09-03 16:51:10 Vacuum process idle but hogging memory 8.2.4