Re: select query takes 13 seconds to run with index

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