From: Tom Lane <tgl@sss.pgh.pa.us>
To: Richard Huxton <dev@archonet.com>
Cc: soni de <soni.de@gmail.com>
Cc: Joshua D. Drake <jd@commandprompt.com>
Cc: Rajesh Kumar Mallah <mallah.rajesh@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Takes too long to fetch the data from database
Date: Tue, 11 Apr 2006 09:45:36 -0400
Message-ID: <7301.1144763136@sss.pgh.pa.us> (raw)
In-Reply-To: <443B821D.2000005@archonet.com>
References: <9f2e40a90604100021n1cb694d0lb95f318f800f33ee@mail.gmail.com>
<a97c77030604100858h4ef89e92sa6ecdd0aca735edb@mail.gmail.com>
<443AA1D4.9010308@commandprompt.com>
<9f2e40a90604110005o101fe98enec2f8ac8f757c770@mail.gmail.com>
<443B821D.2000005@archonet.com>
Richard Huxton <dev@archonet.com> writes:
> soni de wrote:
>> NOTICE: QUERY PLAN:
>> Sort (cost=17.13..17.13 rows=1 width=16) (actual time=619140.18..619140.29rows
>> =288 loops=1)
>> -> Index Scan using lan_pkey on lan (cost=0.00..17.12 rows=1 width=16)
>> (actual time=7564.44..619121.61 rows=288 loops=1)
>>
>> Total runtime: 619140.76 msec
> OK - there is clearly something wrong here when you take 10 minutes to
> fetch 288 rows from an index.
> I'm guessing you have a *lot* of dead rows in there.
Yeah. The other small problem here is that EXPLAIN output hasn't looked
like that since PG 7.2 (unless Soni has just omitted the index-condition
lines). I'd recommend updating to something modern.
regards, tom lane
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: tgl@sss.pgh.pa.us, dev@archonet.com, soni.de@gmail.com, jd@commandprompt.com, mallah.rajesh@gmail.com
Subject: Re: Takes too long to fetch the data from database
In-Reply-To: <7301.1144763136@sss.pgh.pa.us>
* 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