| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mark Roberts | 2008-08-07 21:59:46 | Re: DB Analysis |
| Previous Message | Shane Ambler | 2008-08-07 16:51:47 | Re: A couple of basic questions |