From: Julius Tuskenis <julius@nsoft.lt>
To: pgsql-admin@postgresql.org
Subject: Re: query execution time
Date: Thu, 07 Oct 2010 11:30:39 +0300
Message-ID: <4CAD852F.7050803@nsoft.lt> (raw)
In-Reply-To: <4CAC3B6902000025000365A3@gw.wicourts.gov>
References: <1e5d6016dca5b8022106577ec316208f@mail.nsoft.lt>
<4CAB52A0020000250003657E@gw.wicourts.gov>
<4CAC6168.20608@nsoft.lt>
<4CAC3B6902000025000365A3@gw.wicourts.gov>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: julius@nsoft.lt
Subject: Re: query execution time
In-Reply-To: <4CAD852F.7050803@nsoft.lt>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox