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

Re: query execution time

From: Julius Tuskenis <julius(at)nsoft(dot)lt>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: query execution time
Date: 2010-10-07 08:30:39
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
  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)
> 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 

Julius Tuskenis
Programavimo skyriaus vadovas
UAB nSoft
mob. +37068233050

In response to

pgsql-admin by date

Next:From: Kiswono PrayogoDate: 2010-10-07 16:58:18
Subject: installation failed for PostgreSQL 9.0.0 in Windows (Visual C++ Runtime Installation error)
Previous:From: Scott MarloweDate: 2010-10-07 07:27:49
Subject: Re: newer release branch

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