Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 3F9EE476121 for ; Tue, 15 Oct 2002 04:01:14 -0400 (EDT) Received: from jobs1.unisoftbg.com (unknown [194.12.229.208]) by postgresql.org (Postfix) with SMTP id CB97147607E for ; Tue, 15 Oct 2002 04:01:08 -0400 (EDT) Received: (qmail 944 invoked from network); 15 Oct 2002 14:28:57 -0000 Received: from unisoft.unisoftbg.com (HELO t1.unisoftbg.com) (194.12.229.193) by 0 with SMTP; 15 Oct 2002 14:28:57 -0000 Message-ID: <3DABBE6F.67930574@t1.unisoftbg.com> Date: Tue, 15 Oct 2002 09:06:24 +0200 From: pginfo X-Mailer: Mozilla 4.03 [en] (Win95; I) MIME-Version: 1.0 To: pgsql-general Subject: query optimization Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200210/664 X-Sequence-Number: 31662 Hi, By running a relative complex query I get very slow response from postgresql. The query is and the explain analyze are: testsklad19=# explain analyze select N.IDS,N.IDS_NUM,N.IDS_SLU,N.IDS_SKLAD,SK.MNAME AS SKNAME,N.ZAPR,N.NOMNUM,NOM.NUM,N.NOMNAME,NOM.MNAME AS NOMNAME,N.PART,N.SERIENNUM,N.IZV,N.KOL,N.IDS_MED,N.MED,N.IDS_MED_MAIN,N.MED_MAIN,N.OTN_MED,N.CENA,N.VAL,N.KURS,N.CENADDS,N.DDS,N.CENA_LV,N.CENA_LVDDS,N.TOT,N.DTO,N.PTO,N.ORDER_NUM,N.IDS_DOC2,NOM.OSN_MED,NOM.DOP1_MED,NOM.DOP2_MED,NOM.OTN_DOP1_MED,NOM.OTN_DOP2_MED,N.DTON ,N.OFFIC,N.DATE_IZL,N.IZL,N.OTCH_CENA,N.CENAMITALV,N.CENATAKSILV,N.CENATRANSLV,N.CENA,N.CENAZASTRLV from A_SKLAD N left outer join A_LOCATION SK ON ( N.IDS_SKLAD=SK.IDS ) left outer join A_NOMEN NOM ON ( N.IDS_NUM = NOM.IDS ) where N.FID = 0 AND N.IDS_DOC = 'SOF_500' ORDER BY N.ORDER_NUM ; NOTICE: QUERY PLAN: Sort (cost=37.44..37.44 rows=1 width=1118) (actual time=12140.96..12141.02 rows=48 loops=1) -> Nested Loop (cost=0.00..37.43 rows=1 width=1118) (actual time=115.02..12138.57 rows=48 loops=1) -> Nested Loop (cost=0.00..33.42 rows=1 width=886) (actual time=0.58..20.77 rows=48 loops=1) -> Index Scan using i_sklad_ids_doc on a_sklad n (cost=0.00..28.58 rows=1 width=760) (actual time=0.36..8.59 rows=48 loops=1) -> Index Scan using a_location_pkey on a_location sk (cost=0.00..4.82 rows=1 width=126) (actual time=0.09..0.12 rows=1 loops=48) -> Seq Scan on a_nomen nom (cost=0.00..3.45 rows=45 width=232) (actual time=0.03..165.45 rows=6702 loops=48) Total runtime: 12142.07 msec EXPLAIN How can I detect the problem? Exist any info or docs about how to interpred the analyze results? Many thanks in advance, Ivan.