Re: Query performance - Mailing list pgsql-performance

From Grzegorz Jaśkiewicz
Subject Re: Query performance
Date
Msg-id 2f4958ff0910120640q1f56fcbfg922573a8594320a6@mail.gmail.com
Whole thread Raw
In response to Re: Query performance  (Matthew Wakeling <matthew@flymine.org>)
List pgsql-performance


2009/10/12 Matthew Wakeling <matthew@flymine.org>
This is an EXPLAIN, not an EXPLAIN ANALYSE. If it was an EXPLAIN ANALYSE, it would show how much memory was used, and whether it was a disc sort or an in-memory sort. As it is only an EXPLAIN, the query hasn't actually been run, and we have no information about whether the sort would be performed on disc or not.
 
true, I was looking at it as if it was explain analyze output :)
sorry.

--
GJ

pgsql-performance by date:

Previous
From: Matthew Wakeling
Date:
Subject: Re: Query performance
Next
From: Cédric Villemain
Date:
Subject: Re: Best suiting OS