Re: help on time calculation

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 time calculation
Date: 2005-04-07 08:18:32
Message-ID: 4254ECD8.4040705@familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

> 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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message S.Thanga Prakash 2005-04-07 08:45:19 Re: help on explain analyse in psql 7.1.3 (linux)
Previous Message Christopher Kings-Lynne 2005-04-07 07:49:24 Re: help on explain analyse in psql 7.1.3 (linux)