Received: from localhost (unknown [200.46.204.183])
	by developer.postgresql.org (Postfix) with ESMTP id 757AA2E009F
	for <pgsql-general-postgresql.org@developer.postgresql.org>;
	Mon, 26 May 2008 21:43:17 -0300 (ADT)
Received: from developer.postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 96528-01-3
	for <pgsql-general-postgresql.org@developer.postgresql.org>;
	Mon, 26 May 2008 21:42:53 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from mail.emproshunts.com (mail.emproshunts.com [66.64.191.19])
	by developer.postgresql.org (Postfix) with ESMTP id C11BC2E00B2
	for <pgsql-general@postgresql.org>;
	Mon, 26 May 2008 21:14:01 -0300 (ADT)
Received: from [192.168.1.49] by mail.emproshunts.com (GMS
	15.00.3626/KX5895.00.ca7cb0e7) with ESMTP id pgmqhaaa for
	pgsql-general@postgresql.org; Mon, 26 May 2008 20:14:00 -0400
Message-ID: <483B5242.7080703@emproshunts.com>
Date: Mon, 26 May 2008 20:13:54 -0400
From: Justin <justin@emproshunts.com>
User-Agent: Thunderbird 2.0.0.14 (Windows/20080421)
MIME-Version: 1.0
To: Gregory Williamson <Gregory.Williamson@digitalglobe.com>
CC: mark <markkicks@gmail.com>, pgsql-general@postgresql.org
Subject: Re: select query takes 13 seconds to run with index
References: <82fa9e310805261549m2362fbe8sbf18789938fee833@mail.gmail.com>	
	<483B4729.7050402@emproshunts.com>
	<82fa9e310805261632y46f306fdh84e2da62ffbd7873@mail.gmail.com>
	<483B4C74.7000703@emproshunts.com>
	<8B319E5A30FF4A48BE7EEAAF609DB233015E394B@COMAIL01.digitalglobe.com>
In-Reply-To: 
 <8B319E5A30FF4A48BE7EEAAF609DB233015E394B@COMAIL01.digitalglobe.com>
Content-Type: multipart/alternative;
	boundary="------------080401050001020900040508"
X-Originating-IP: [192.168.1.49]
X-DNSBL: 0
X-AntiSpam: Checked for restricted content by Gordano's AntiSpam Software
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200805/959
X-Sequence-Number: 133358

This is a multi-part message in MIME format.
--------------080401050001020900040508
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

 
>
> >
> > 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.

--------------080401050001020900040508
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
  <meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
&nbsp;<br>
<blockquote
 cite="mid:8B319E5A30FF4A48BE7EEAAF609DB233015E394B@COMAIL01.digitalglobe.com"
 type="cite">
  <p><font size="2">&gt;<br>
&gt; How many users are attached to the server at any given time.&nbsp; how
many inserts, deletes<br>
&gt; selects are being done on the server.&nbsp; Its number&nbsp; TPS&nbsp; on the
server.<br>
  <br>
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.<br>
  <br>
HTH,<br>
  <br>
Greg Williamson<br>
Senior DBA<br>
DigitalGlobe<br>
  <br>
  <br>
  </font></p>
</blockquote>
There are several tools to do this process explorer which has to be
down loaded, and performance monitor.&nbsp; The problem with performance
monitor is posgresql keeps spawning new exe which makes reading the
result real a pain. <br>
</body>
</html>

--------------080401050001020900040508--