QUERY ABOUT EXPLAIN ANALYZE
| От | Savita |
|---|---|
| Тема | QUERY ABOUT EXPLAIN ANALYZE |
| Дата | |
| Msg-id | 3DBE1BC1.7D320305@india.hp.com обсуждение исходный текст |
| Ответ на | Re: User functions not displayed by \df (Bruce Momjian <pgman@candle.pha.pa.us>) |
| Ответы |
Re: QUERY ABOUT EXPLAIN ANALYZE
|
| Список | 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 по дате отправления: