Skip site navigation (1) Skip section navigation (2)

Re: Query performance

From: Grzegorz Jaśkiewicz <gryzman(at)gmail(dot)com>
To: Matthew Wakeling <matthew(at)flymine(dot)org>
Cc: S Arvind <arvindwill(at)gmail(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Query performance
Date: 2009-10-12 13:40:14
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-performance
2009/10/12 Matthew Wakeling <matthew(at)flymine(dot)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 :)


In response to

pgsql-performance by date

Next:From: Michal SzymanskiDate: 2009-10-12 14:14:37
Subject: Performance with sorting and LIMIT on partitioned table
Previous:From: Matthew WakelingDate: 2009-10-12 13:36:59
Subject: Re: Query performance

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group