Postgres Pro
Downloads
Home   >   mailing lists

Re: investigating slow queries through pg_stat_activity - Mailing list pgsql-performance

From Enrico Weigelt
Subject Re: investigating slow queries through pg_stat_activity
Date
Msg-id 20050703222830.GA2056@nibiru.borg.metux.de
Whole thread Raw
In response to investigating slow queries through pg_stat_activity  (Dan Harris <fbsd@drivefaster.net>)
List pgsql-performance
Tree view 
* Dan Harris <fbsd@drivefaster.net> wrote:

Hi,

> I've got some queries generated by my application that will, for some
> reason, run forever until I kill the pid.  Yet, when I run the
> queries manually to check them out, they usually work fine.

If you can change your application, you could try to encapsulate the
queries into views - this makes logging and tracking down problems
much easier.


cu
--
---------------------------------------------------------------------
 Enrico Weigelt    ==   metux IT service
  phone:     +49 36207 519931         www:       http://www.metux.de/
  fax:       +49 36207 519932         email:     contact@metux.de
---------------------------------------------------------------------
  Realtime Forex/Stock Exchange trading powered by postgresSQL :))
                                            http://www.fxignal.net/
---------------------------------------------------------------------

pgsql-performance by date:

Previous
From: Madison Kelly
Date:
Subject: Re: B-Tree index not being used
Next
From: Enrico Weigelt
Date:
Subject: plain inserts and deletes very slow