Home > mailing lists

Re: Query timing - Mailing list pgsql-general

From	A. Kretschmer
Subject	Re: Query timing
Date	March 5, 2007 05:00:43
Msg-id	20070305060036.GA12369@a-kretschmer.de Whole thread Raw
In response to	Query timing (Naz Gassiep <naz@mira.net>)
List	pgsql-general

Tree view

am  Mon, dem 05.03.2007, um 15:28:29 +1100 mailte Naz Gassiep folgendes:
> Using EXPLAIN ANALYZE I can get the execution time of a query. Is there
> a command I can use to get the execution time without the planning

Within psql, the command-line-interface, you can use \timing to switch
on/off reporting the execution time.


Andreas
--
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47150,   D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID:   0x3FFF606C, privat 0x7F4584DA   http://wwwkeys.de.pgp.net

pgsql-general by date:

From: "Joshua D. Drake"
Date: 05 March 2007, 03:56:41
Subject: Re: Postgres Replication

From: Tino Wildenhain
Date: 05 March 2007, 05:14:41
Subject: Re: date format

Re: Query timing - Mailing list pgsql-general

Previous

Next