Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Wed, 04 Oct 2006 14:11:35 +0200
- Message-id: <4523A4F7(dot)6020802(at)logix-tt(dot)com>
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
- References:
- Performance Optimization for Dummies 2 - the SQL
- From: Carlo Stonebanks
- Re: Performance Optimization for Dummies 2 - the SQL
- From: Merlin Moncure
- Re: Performance Optimization for Dummies 2 - the SQL
- From: Alex Stapleton
- Performance Optimization for Dummies 2 - the SQL
- Prev by Date: Re: slow queue-like empty table
- Next by Date: Re: PostgreSQL Caching
- Previous by thread: Re: Performance Optimization for Dummies 2 - the SQL
- Next by thread: Re: Performance Optimization for Dummies 2 - the SQL
- Indexes: