Postgres Pro
Downloads
Home   >   mailing lists

Re: help on time calculation - Mailing list pgsql-performance

From Christopher Kings-Lynne
Subject Re: help on time calculation
Date
Msg-id 4254ECD8.4040705@familyhealth.com.au
Whole thread Raw
In response to help on time calculation  ("S.Thanga Prakash" <thanga@midascomm.com>)
List pgsql-performance
Tree view 
>    how to find the time taken by an query/stored procedure?

In psql, use \timing for an approximate time.

> I am using psql 7.1.3 in linux 7.2
>
> how to execute 'explain analyse' in the psql? Is it supported at 7.1.3 ?

Explain analyze is NOT supported in PostgreSQL 7.1.  You really should
upgrade your PostgreSQL to version 8.0.

Chris

pgsql-performance by date:

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