Re: How to get the used time when operate a select query? - Mailing list pgsql-general

From Oskar Berggren
Subject Re: How to get the used time when operate a select query?
Date
Msg-id 3D1AE265.6000502@sgs.o.se
Whole thread Raw
In response to How to get the used time when operate a select query?  (黄春茂 <huang@tanpopo-tane.com>)
Responses Re: How to get the used time when operate a select query?
List pgsql-general
$B2+=ULP wrote:
> How can I  get the time which a select query use?
> thank you!
>
>

If you are using version 7.2 or later, try the command

EXPLAIN ANALYZE <any query>

This will perform the query (even if it is a DELETE FROM <table>!)
and show the actual time.

/Oskar

Ps. You should check what your mail client puts in the from field
of you mail. It is quite unreadable...

--
/----------------------------------------------------------------------\
| Oskar Berggren        beo@sgs.o.se                                   |
| Network and Software Engineer                     SGS Datanätgrupp   |
|                                                   Gothenburg, Sweden |
\----------------------------------------------------------------------/




pgsql-general by date:

Previous
From: 黄春茂
Date:
Subject: How to get the used time when operate a select query?
Next
From: Nadim Bitar
Date:
Subject: Re: Large Objects