Re: Performance Optimization for Dummies 2 - the SQL

From: Markus Schaber <schabi(at)logix-tt(dot)com>
To: Alex Stapleton <alexs(at)advfn(dot)com>
Cc: Merlin Moncure <mmoncure(at)gmail(dot)com>, Carlo Stonebanks <stonec(dot)register(at)sympatico(dot)ca>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Performance Optimization for Dummies 2 - the SQL
Date: 2006-10-04 12:11:35
Message-ID: 4523A4F7.6020802@logix-tt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hi, Alex,

Alex Stapleton wrote:

>> explain analyze is more helpful because it prints the times.
>
> You can always use the \timing flag in psql ;)

Have you ever tried EXPLAIN ANALYZE?

\timing gives you one total timing, but EXPLAIN ANALYZE gives you
timings for sub-plans, including real row counts etc.

HTH,
Markus

--
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf. | Software Development GIS

Fight against software patents in Europe! www.ffii.org
www.nosoftwarepatents.org

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Dave Dutcher 2006-10-04 12:38:00 Re: PostgreSQL Caching
Previous Message Tobias Brox 2006-10-04 10:59:10 Re: slow queue-like empty table