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

Re: database not using indexes

From: Craig Ringer <ringerc(at)ringerc(dot)id(dot)au>
To: Silvio Brandani <silvio(dot)brandani(at)tech(dot)sdb(dot)it>
Cc: "Ruslan A(dot) Bondar" <fsat(at)list(dot)ru>, pgsql-admin(at)postgresql(dot)org
Subject: Re: database not using indexes
Date: 2011-11-10 02:43:08
Message-ID: 4EBB3A3C.1090706@ringerc.id.au (view raw or flat)
Thread:
Lists: pgsql-admin
On 10/11/11 01:06, Silvio Brandani wrote:
> Ok,
> 
> the problem was  on a big table on query like this:
> 
> select outmessage0_.out_msg_id as out1_0_
> from edi.out_messages outmessage0_, edi.transaction_set_partners
> transactio1_
> where outmessage0_.transaction_set_partner=transactio1_.trn_set_prtn_id
> and outmessage0_.status_id='TOSND'
> and transactio1_.legacy_sender_id='ALL'
> and transactio1_.legacy_receiver_id='00004542'
> and outmessage0_.transaction_set_id='INTERNAL_USE'
> order by outmessage0_.out_msg_id


Please read:

  http://wiki.postgresql.org/wiki/Guide_to_reporting_problems

and as linked to there, read:

  http://wiki.postgresql.org/wiki/SlowQueryQuestions

then try again including all the information you are asked for. In
particular, you have not included EXPLAIN ANALYZE output or any
information about your PostgreSQL version. Failure to provide that
information makes it difficult or impossible to answer your question,
wasting your time and everyone else's.

We don't link to that document just for fun. It's information that is
important to answer questions properly.

--
Craig Ringer

In response to

pgsql-admin by date

Next:From: Ruslan A. BondarDate: 2011-11-10 05:53:31
Subject: Re: How to deal with corrupted database?
Previous:From: Craig RingerDate: 2011-11-10 02:40:58
Subject: Re: database not using indexes

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