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

DB Analysis

From: Arjun Datta <arjun(at)greatgulfhomes(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: DB Analysis
Date: 2008-08-07 18:40:04
Message-ID: 489B4184.7080605@greatgulfhomes.com (view raw or flat)
Thread:
Lists: pgsql-novice
Hi,

I need to analyse a development DB which runs a whole slew of queries.

It is Postgres 8.2 running on Fedora Core 8 2.6.23.1-42 on a 64 bit AMD 
Athlon(tm) 64 X2 Dual Core Processor 5000+ machine with 4GB DDR2 800Mhz RAM.

I need to figure out how long queries take, should take, etc etc.

Can someone point me in the right direction - either a resource that I 
can read and get an idea from or a tool I can run.

For example, if someone is running a piece of code that affects say, 
1000 records in a table, how long should it take ?  Is it possible to 
answer that question ? If so, how would I analyse it ?

-- 
Regards,
 
Arjun Datta

Responses

pgsql-novice by date

Next:From: Mark RobertsDate: 2008-08-07 21:59:46
Subject: Re: DB Analysis
Previous:From: Shane AmblerDate: 2008-08-07 16:51:47
Subject: Re: A couple of basic questions

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