From: Justin <justin@emproshunts.com>
To: Gregory Williamson <Gregory.Williamson@digitalglobe.com>
Cc: mark <markkicks@gmail.com>
Cc: pgsql-general@postgresql.org
Subject: Re: select query takes 13 seconds to run with index
Date: Mon, 26 May 2008 20:13:54 -0400
Message-ID: <483B5242.7080703@emproshunts.com> (raw)
In-Reply-To: <8B319E5A30FF4A48BE7EEAAF609DB233015E394B@COMAIL01.digitalglobe.com>
References: <82fa9e310805261549m2362fbe8sbf18789938fee833@mail.gmail.com>
<483B4729.7050402@emproshunts.com>
<82fa9e310805261632y46f306fdh84e2da62ffbd7873@mail.gmail.com>
<483B4C74.7000703@emproshunts.com>
<8B319E5A30FF4A48BE7EEAAF609DB233015E394B@COMAIL01.digitalglobe.com>
>
> >
> > How many users are attached to the server at any given time. how
> many inserts, deletes
> > selects are being done on the server. Its number TPS on the server.
>
> On Windoze I don't know; on *NIX variants the utility "top" can show
> useful information on load and active processes; iostat or vmstat can
> give detailed looks over time (use period of between 1 and 5 seconds
> maybe and discard the first row as nonsense); they show disk i/o and
> context switching, etc.
>
> HTH,
>
> Greg Williamson
> Senior DBA
> DigitalGlobe
>
>
There are several tools to do this process explorer which has to be down
loaded, and performance monitor. The problem with performance monitor
is posgresql keeps spawning new exe which makes reading the result real
a pain.
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-performance@postgresql.org
Cc: justin@emproshunts.com, Gregory.Williamson@digitalglobe.com, markkicks@gmail.com, pgsql-general@postgresql.org
Subject: Re: select query takes 13 seconds to run with index
In-Reply-To: <483B5242.7080703@emproshunts.com>
* 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