QUERY ABOUT EXPLAIN ANALYZE

From: Savita <savita(at)india(dot)hp(dot)com>
To: Postgresql General <pgsql-general(at)postgresql(dot)org>
Subject: QUERY ABOUT EXPLAIN ANALYZE
Date: 2002-10-29 05:25:21
Message-ID: 3DBE1BC1.7D320305@india.hp.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I have a query for select statement from a view,inside that query I am calling a
function .

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

I wanted to know why is this variation in time.DOse it means that for the first
time my performance will be low.

Please help me in understanding this correctly.
--
Best Regards
- Savita
----------------------------------------------------
Hewlett Packard (India)
+91 80 2051288 (Phone)
847 1288 (HP Telnet)
----------------------------------------------------

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Mario Weilguni 2002-10-29 07:03:39 Re: QUERY ABOUT EXPLAIN ANALYZE
Previous Message Bruce Momjian 2002-10-29 03:26:40 Re: User functions not displayed by \df