Postgres Pro
Downloads
Home   >   mailing lists

Re: help on explain analyse in psql 7.1.3 (linux) - Mailing list pgsql-performance

From Greg Sabino Mullane
Subject Re: help on explain analyse in psql 7.1.3 (linux)
Date
Msg-id 6f7d87109a48cd84c74dda77a17f87b0@biglumber.com
Whole thread Raw
In response to Re: help on explain analyse in psql 7.1.3 (linux)  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
List pgsql-performance
Tree view 
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


Christopher Kings-Lynne wrote:
> Explain analyze was added in 7.2 - you really need to upgrade...
>
> You can use \timing in psql to get an approximation...

Actually, \timing was not added until 7.2 either! So, the
original poster really, really needs to upgrade... :)

- --
Greg Sabino Mullane greg@turnstep.com
PGP Key: 0x14964AC8 200504072129
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8

-----BEGIN PGP SIGNATURE-----

iD8DBQFCVd69vJuQZxSWSsgRAvRHAJ9T1uxfWEnHSNI/+iiiHiJ2I1IGUgCggMYb
tjDwzfseK3aDAKHI5Ko1S/Q=
=AvKY
-----END PGP SIGNATURE-----

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Recognizing range constraints (was Re: Plan for relatively simple query seems to be very inefficient)
Next
From: "Greg Sabino Mullane"
Date:
Subject: Re: COPY Hacks (WAS: RE: Postgresql vs SQLserver for this application ?)