Re: help on explain analyse in psql 7.1.3 (linux)

From: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
To: thanga(at)midascomm(dot)com
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: help on explain analyse in psql 7.1.3 (linux)
Date: 2005-04-07 07:49:24
Message-ID: 4254E604.90006@familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

> 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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Christopher Kings-Lynne 2005-04-07 08:18:32 Re: help on time calculation
Previous Message S.Thanga Prakash 2005-04-07 07:44:51 help on time calculation