Skip site navigation (1) Skip section navigation (2)

Re: Query time

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Laura Castro <laura(at)alfa21(dot)com>
Cc: PostgresSQL ODBC mailing list <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: Query time
Date: 2002-07-30 03:12:50
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-odbc
Using postgresql.conf or SET, you can enable timestamps on the log file,
and 7.2 psql has a \timing command.  Also EXPLAIN ANALYZE query shows

Actually, we should have something that shoots out just the query and
the duration into the log file.  I don't see that capability now.

I see it on the TODO list:

	* Allow logging of query durations


Laura Castro wrote:
>   Hi all,
>   I'm interested in measuring how much time different sql-queries spent,
> but I don't know how to do it in postgresql. Any idea?
>   Perhaps that's a way of analyzing it at some kind of log file or so...
>   Thank you very much in advance.
> 	Laura Castro
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org

  Bruce Momjian                        |
  pgman(at)candle(dot)pha(dot)pa(dot)us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

In response to

  • Query time at 2002-07-26 16:02:57 from Laura Castro

pgsql-odbc by date

Next:From: Graham VickrageDate: 2002-07-31 19:55:11
Subject: Im only getting limited data
Previous:From: Chad R. LarsonDate: 2002-07-29 20:15:50
Subject: Re: The best book

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group