QUERY ABOUT EXPLAIN ANALYZE - Mailing list pgsql-general

From Savita
Subject QUERY ABOUT EXPLAIN ANALYZE
Date
Msg-id 3DBE1BC1.7D320305@india.hp.com
Whole thread Raw
In response to Re: User functions not displayed by \df  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: QUERY ABOUT EXPLAIN ANALYZE
List 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)
----------------------------------------------------
 

pgsql-general by date:

Previous
From: evertcarton@netscape.net (Evert Carton)
Date:
Subject: Re: LDAP authentication
Next
From: Mario Weilguni
Date:
Subject: Re: QUERY ABOUT EXPLAIN ANALYZE