Re: postgresql query runtime

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Radhya sahal" <rad_cs_2006(at)yahoo(dot)com>
Cc: "pgsql-performance group" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: postgresql query runtime
Date: 2011-10-11 21:43:00
Message-ID: 4E9472140200002500041E48@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Radhya sahal <rad_cs_2006(at)yahoo(dot)com> wrote:

> how i can read query runtime if i want to run query from java ?

Personally, I capture System.currentTimeInMillis() before and after
the query, and subtract. In our framework, we have a monitor class
to encapsulate that.

-Kevin

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message bricklen 2011-10-11 23:22:06 Re: Rapidly finding maximal rows
Previous Message Radhya sahal 2011-10-11 21:29:23 Re: postgresql query runtime