Postgres Pro
Downloads
Home   >   mailing lists

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

From Christopher Kings-Lynne
Subject Re: help on explain analyse in psql 7.1.3 (linux)
Date
Msg-id 4254E604.90006@familyhealth.com.au
Whole thread Raw
In response to help on explain analyse in psql 7.1.3 (linux)  ("S.Thanga Prakash" <thanga@midascomm.com>)
Responses Re: help on explain analyse in psql 7.1.3 (linux)
Re: help on explain analyse in psql 7.1.3 (linux)
Re: help on explain analyse in psql 7.1.3 (linux)
List pgsql-performance
Tree view 
> I didn't find option analyse in explain command..
>
> how to get time taken by SQL procedure/query?

Explain analyze was added in 7.2 - you really need to upgrade...

You can use \timing in psql to get an approximation...

Chris

pgsql-performance by date:

Previous
From: "S.Thanga Prakash"
Date:
Subject: help on explain analyse in psql 7.1.3 (linux)
Next
From: "S.Thanga Prakash"
Date:
Subject: help on time calculation