Postgres Pro
Downloads
Home   >   mailing lists

Re: very slow query - Mailing list pgsql-general

From A. Kretschmer
Subject Re: very slow query
Date
Msg-id 20071212125835.GD4656@a-kretschmer.de
Whole thread Raw
In response to Re: very slow query  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
Responses Re: very slow query
List pgsql-general
Tree view 
am  Wed, dem 12.12.2007, um 12:44:09 +0000 mailte Ashish Karalkar folgendes:
>     > Do you have an index on "mobile"? Can you show us the table definition
>     > and the output from EXPLAIN ANALYSE?
>     >
>     > no index on mobile
>
>     Seq Scan on sms_new ... Filter: (mobile = 919820920858::bigint)
>     (cost=0.00..5027902.00
>
>
>     Can you see the problem?
>
>     So i will have to create index on mobile is taht so?

Try it.


Andreas
--
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47150,   D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID:   0x3FFF606C, privat 0x7F4584DA   http://wwwkeys.de.pgp.net

pgsql-general by date:

Previous
From: "Lawrence Oluyede"
Date:
Subject: Re: Possible bug in PostgreSQL 8.3beta4 (postgres process segfaults)
Next
From: Richard Broersma Jr
Date:
Subject: Southern California Linux Expo