Postgres Pro
Downloads
Home   >   mailing lists

Re: QUERY ABOUT EXPLAIN ANALYZE - Mailing list pgsql-general

From Mario Weilguni
Subject Re: QUERY ABOUT EXPLAIN ANALYZE
Date
Msg-id 200210290803.39898.mweilguni@sime.com
Whole thread Raw
In response to QUERY ABOUT EXPLAIN ANALYZE  (Savita <savita@india.hp.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Savita
Date:
Subject: QUERY ABOUT EXPLAIN ANALYZE
Next
From: Christoph Dalitz
Date:
Subject: Re: supplying password to psql on command line?