Message-ID: <4CAD852F.7050803@nsoft.lt>
Date: Thu, 07 Oct 2010 11:30:39 +0300
From: Julius Tuskenis <julius@nsoft.lt>
Organization: UAB nSoft
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; lt;
	rv:1.9.2.9) Gecko/20100915 Lightning/1.0b2 Thunderbird/3.1.4
MIME-Version: 1.0
To: pgsql-admin@postgresql.org
Subject: Re: query execution time
References: <1e5d6016dca5b8022106577ec316208f@mail.nsoft.lt>
	<4CAB52A0020000250003657E@gw.wicourts.gov>
	<4CAC6168.20608@nsoft.lt>
	<4CAC3B6902000025000365A3@gw.wicourts.gov>
In-Reply-To: <4CAC3B6902000025000365A3@gw.wicourts.gov>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit

  2010.10.06 17:03, Kevin Grittner rašė:
>> Version string:   PostgreSQL 8.3.4 on i686-pc-linux-gnu, compiled
>> by GCC gcc (GCC) 4.1.2 (Gentoo 4.1.2 p1.0.2)
>> https://sites.google.com/site/juliaustestukas/Home
>
> Well, you're showing us a version string for a Linux PostgreSQL
> server, but you link to a screen shot which appears to be a client
> connecting to localhost on some variety of Windows.  And you didn't
> tell us much of anything else.

You are right - we connect to localhost on windows machine because we 
use ssh tunel to the postgresql server on gentoo linux. The server does 
not have GUI, so no pgAdmin too... The DB is used for web application 
writen in PHP. As the DB and WEB servers are on the same machine we can 
rule out the network issues I guess... The query (in the screen shot) 
was found in postgresql server logs as a long lasting query. I will try 
issue the EXPLAIN ANALIZE query from the command line on server machine 
to be 100% sure this is not related to networking.
The behavior described is observed when there is high server usage. 
Using "server status" tool shows several such queries executed suddenly 
and then after some waiting everything goes back to normal. The top 
command on the server shows it has enough of ram (~200Mb free all the 
time).


-- 
Julius Tuskenis
Programavimo skyriaus vadovas
UAB nSoft
mob. +37068233050