From: pginfo <pginfo@t1.unisoftbg.com>
To: pgsql-general <pgsql-general@postgresql.org>
Subject: query optimization
Date: Tue, 15 Oct 2002 09:06:24 +0200
Message-ID: <3DABBE6F.67930574@t1.unisoftbg.com> (raw)
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.
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-general@postgresql.org
Cc: pginfo@t1.unisoftbg.com
Subject: Re: query optimization
In-Reply-To: <3DABBE6F.67930574@t1.unisoftbg.com>
* 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