Re: QUERY ABOUT EXPLAIN ANALYZE

From: Mario Weilguni <mweilguni(at)sime(dot)com>
To: Savita <savita(at)india(dot)hp(dot)com>, Postgresql General <pgsql-general(at)postgresql(dot)org>
Subject: Re: QUERY ABOUT EXPLAIN ANALYZE
Date: 2002-10-29 07:03:39
Message-ID: 200210290803.39898.mweilguni@sime.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Am Dienstag, 29. Oktober 2002 06:25 schrieb Savita:
> When I used EXPLAIN ANALYZE for the first time in the query I get
> total time=541.00msec
> second time
> total time=10.00msec
> third time
> total time=0.00msec

Explain analyze actually performs the query and times it, so what you see are buffering/caching effects. Thats ok.

Regards,
Mario Weilguni

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Christoph Dalitz 2002-10-29 07:52:12 Re: supplying password to psql on command line?
Previous Message Savita 2002-10-29 05:25:21 QUERY ABOUT EXPLAIN ANALYZE