#	exclusive	inclusive	rows x	rows	loops	node
1.	0.031	685.238	↓ 26.0	26	1	→ Nested Loop Left Join (cost=79.96..84.62 rows=1 width=94) (actual time=684.776..685.238 rows=26 loops=1)
2.	0.283	685.155	↓ 26.0	26	1	→ Nested Loop Left Join (cost=79.96..84.09 rows=1 width=95) (actual time=684.767..685.155 rows=26 loops=1) Join Filter: (public.tow._id = szs.ltowar)
3.	1.687	684.768	↓ 26.0	26	1	→ HashAggregate (cost=79.96..80.00 rows=1 width=52) (actual time=684.747..684.768 rows=26 loops=1)
4.	11.203	683.081	↓ 136.0	136	1	→ Nested Loop Left Join (cost=0.00..79.93 rows=1 width=133) (actual time=0.531..683.081 rows=136 loops=1) Join Filter: (spexp._id = sp.lexport)
5.	2.242	671.606	↓ 136.0	136	1	→ Nested Loop Left Join (cost=0.00..77.90 rows=1 width=123) (actual time=0.372..671.606 rows=136 loops=1) Join Filter: (public.tow._id = szs.ltowar)
6.	0.429	668.548	↓ 136.0	136	1	→ Nested Loop Left Join (cost=0.00..73.82 rows=1 width=119) (actual time=0.349..668.548 rows=136 loops=1)
7.	0.461	667.167	↓ 136.0	136	1	→ Nested Loop Left Join (cost=0.00..73.45 rows=1 width=119) (actual time=0.336..667.167 rows=136 loops=1) Join Filter: ((szz._sect)::integer = (psmz._sect)::integer)
8.	0.382	664.802	↓ 136.0	136	1	→ Nested Loop Left Join (cost=0.00..71.01 rows=1 width=106) (actual time=0.317..664.802 rows=136 loops=1) Join Filter: ((psmz._sect)::integer = (maz._sect)::integer)
9.	0.248	662.652	↓ 136.0	136	1	→ Nested Loop Left Join (cost=0.00..69.16 rows=1 width=103) (actual time=0.301..662.652 rows=136 loops=1)
10.	6.403	661.316	↓ 136.0	136	1	→ Nested Loop (cost=0.00..60.87 rows=1 width=92) (actual time=0.291..661.316 rows=136 loops=1) Join Filter: (psms.lma = mas._id)
11.	0.435	5.693	↓ 130.0	130	1	→ Nested Loop Left Join (cost=0.00..29.87 rows=1 width=52) (actual time=0.160..5.693 rows=130 loops=1)
12.	0.290	4.218	↓ 130.0	130	1	→ Nested Loop (cost=0.00..21.59 rows=1 width=41) (actual time=0.142..4.218 rows=130 loops=1)
13.	0.223	0.223	↓ 195.0	195	1	→ Seq Scan on psm psms (cost=0.00..7.41 rows=1 width=14) (actual time=0.018..0.223 rows=195 loops=1) Filter: ((_sect)::integer = 1)
14.	3.705	3.705	↑ 1.0	1	195	→ Index Scan using defidx_sk on sz szs (cost=0.00..14.16 rows=1 width=31) (actual time=0.018..0.019 rows=1 loops=195) Index Cond: (szs._id = psms.lsz) Filter: ((szs.crodzaj = 83) AND ((szs._sect)::integer = 1))
15.	1.040	1.040	↑ 1.0	1	130	→ Index Scan using pkey_sp on sp (cost=0.00..8.27 rows=1 width=29) (actual time=0.008..0.008 rows=1 loops=130) Index Cond: (((sp._sect)::text = (szs._sect)::text) AND (sp._id = szs.ltransakcja))
16.	30.030	649.220	↓ 146.0	146	130	→ Nested Loop Left Join (cost=0.00..30.99 rows=1 width=50) (actual time=0.040..4.994 rows=146 loops=130)
17.	19.110	492.700	↓ 139.0	139	130	→ Nested Loop Left Join (cost=0.00..30.56 rows=1 width=46) (actual time=0.031..3.790 rows=139 loops=130)
18.	19.760	347.100	↓ 139.0	139	130	→ Nested Loop Left Join (cost=0.00..30.13 rows=1 width=46) (actual time=0.022..2.670 rows=139 loops=130)
19.	32.110	182.780	↓ 139.0	139	130	→ Nested Loop Left Join (cost=0.00..21.85 rows=1 width=31) (actual time=0.013..1.406 rows=139 loops=130)
20.	24.180	24.180	↓ 139.0	139	130	→ Seq Scan on ma mas (cost=0.00..13.56 rows=1 width=27) (actual time=0.003..0.186 rows=139 loops=130) Filter: ((ckierunek = 87) AND ((_sect)::integer = 1))
21.	126.490	126.490	↓ 0.0	0	18070	→ Index Scan using pkey_ma on ma mask (cost=0.00..8.27 rows=1 width=19) (actual time=0.007..0.007 rows=0 loops=18070) Index Cond: (((mask._sect)::text = (mas._sect)::text) AND (mask._id = mas.lkorygowany))
22.	144.560	144.560	↑ 1.0	1	18070	→ Index Scan using pkey_ma on ma (cost=0.00..8.27 rows=1 width=15) (actual time=0.008..0.008 rows=1 loops=18070) Index Cond: (((ma._sect)::text = (mas._sect)::text) AND (ma._id = mas._id)) Filter: (ma.ckierunek = 87)
23.	126.490	126.490	↓ 0.0	0	18070	→ Index Scan using defidx_b1 on bp bpk (cost=0.00..0.41 rows=1 width=15) (actual time=0.007..0.007 rows=0 loops=18070) Index Cond: (((bpk._sect)::text = (ma._sect)::text) AND (bpk.lwydanie = ma.lkorygowany))
24.	126.490	126.490	↑ 1.0	1	18070	→ Index Scan using defidx_b1 on bp (cost=0.00..0.41 rows=1 width=27) (actual time=0.007..0.007 rows=1 loops=18070) Index Cond: (((public.bp._sect)::text = (ma._sect)::text) AND (public.bp.lwydanie = ma._id))
25.	1.088	1.088	↑ 1.0	1	136	→ Index Scan using pkey_ma on ma maz (cost=0.00..8.27 rows=1 width=22) (actual time=0.007..0.008 rows=1 loops=136) Index Cond: (((maz._sect)::text = (ma._sect)::text) AND (maz._id = (CASE WHEN (public.bp._id IS NULL) THEN bpk.lprzyjecie ELSE public.bp.lprzyjecie END)))
26.	1.768	1.768	↑ 1.0	1	136	→ Index Scan using defidx_2sm on psm psmz (cost=0.00..1.83 rows=1 width=14) (actual time=0.013..0.013 rows=1 loops=136) Index Cond: (psmz.lma = maz._id)
27.	1.904	1.904	↑ 1.0	1	136	→ Index Scan using defidx_sk on sz szz (cost=0.00..2.42 rows=1 width=27) (actual time=0.014..0.014 rows=1 loops=136) Index Cond: (szz._id = psmz.lsz)
28.	0.952	0.952	↑ 1.0	1	136	→ Index Scan using pkey_za on za (cost=0.00..0.35 rows=1 width=22) (actual time=0.006..0.007 rows=1 loops=136) Index Cond: (((za._sect)::text = (szz._sect)::text) AND (za._id = szz.ltransakcja))
29.	0.816	0.816	↑ 1.0	48	136	→ Seq Scan on tow (cost=0.00..3.48 rows=48 width=8) (actual time=0.001..0.006 rows=48 loops=136)
30.	0.272	0.272	↑ 1.0	9	136	→ Seq Scan on spexp (cost=0.00..1.09 rows=9 width=18) (actual time=0.001..0.002 rows=9 loops=136)
31.	0.104	0.104	↑ 1.0	48	26	→ Seq Scan on tow (cost=0.00..3.48 rows=48 width=19) (actual time=0.001..0.004 rows=48 loops=26)
32.	0.052	0.052	↑ 1.0	1	26	→ Index Scan using pkey_jednmiar on jednmiar jm (cost=0.00..0.52 rows=1 width=7) (actual time=0.002..0.002 rows=1 loops=26) Index Cond: (jm._id = public.tow.ljmsprzedaz)

QUERY PLAN
Nested Loop Left Join  (cost=79.96..84.62 rows=1 width=94) (actual time=684.776..685.238 rows=26 loops=1)
  ->  Nested Loop Left Join  (cost=79.96..84.09 rows=1 width=95) (actual time=684.767..685.155 rows=26 loops=1)
        Join Filter: (public.tow._id = szs.ltowar)
        ->  HashAggregate  (cost=79.96..80.00 rows=1 width=52) (actual time=684.747..684.768 rows=26 loops=1)
              ->  Nested Loop Left Join  (cost=0.00..79.93 rows=1 width=133) (actual time=0.531..683.081 rows=136 loops=1)
                    Join Filter: (spexp._id = sp.lexport)
                    ->  Nested Loop Left Join  (cost=0.00..77.90 rows=1 width=123) (actual time=0.372..671.606 rows=136 loops=1)
                          Join Filter: (public.tow._id = szs.ltowar)
                          ->  Nested Loop Left Join  (cost=0.00..73.82 rows=1 width=119) (actual time=0.349..668.548 rows=136 loops=1)
                                ->  Nested Loop Left Join  (cost=0.00..73.45 rows=1 width=119) (actual time=0.336..667.167 rows=136 loops=1)
                                      Join Filter: ((szz._sect)::integer = (psmz._sect)::integer)
                                      ->  Nested Loop Left Join  (cost=0.00..71.01 rows=1 width=106) (actual time=0.317..664.802 rows=136 loops=1)
                                            Join Filter: ((psmz._sect)::integer = (maz._sect)::integer)
                                            ->  Nested Loop Left Join  (cost=0.00..69.16 rows=1 width=103) (actual time=0.301..662.652 rows=136 loops=1)
                                                  ->  Nested Loop  (cost=0.00..60.87 rows=1 width=92) (actual time=0.291..661.316 rows=136 loops=1)
                                                        Join Filter: (psms.lma = mas._id)
                                                        ->  Nested Loop Left Join  (cost=0.00..29.87 rows=1 width=52) (actual time=0.160..5.693 rows=130 loops=1)
                                                              ->  Nested Loop  (cost=0.00..21.59 rows=1 width=41) (actual time=0.142..4.218 rows=130 loops=1)
                                                                    ->  Seq Scan on psm psms  (cost=0.00..7.41 rows=1 width=14) (actual time=0.018..0.223 rows=195 loops=1)
                                                                          Filter: ((_sect)::integer = 1)
                                                                    ->  Index Scan using defidx_sk on sz szs  (cost=0.00..14.16 rows=1 width=31) (actual time=0.018..0.019 rows=1 loops=195)
                                                                          Index Cond: (szs._id = psms.lsz)
                                                                          Filter: ((szs.crodzaj = 83) AND ((szs._sect)::integer = 1))
                                                              ->  Index Scan using pkey_sp on sp  (cost=0.00..8.27 rows=1 width=29) (actual time=0.008..0.008 rows=1 loops=130)
                                                                    Index Cond: (((sp._sect)::text = (szs._sect)::text) AND (sp._id = szs.ltransakcja))
                                                        ->  Nested Loop Left Join  (cost=0.00..30.99 rows=1 width=50) (actual time=0.040..4.994 rows=146 loops=130)
                                                              ->  Nested Loop Left Join  (cost=0.00..30.56 rows=1 width=46) (actual time=0.031..3.790 rows=139 loops=130)
                                                                    ->  Nested Loop Left Join  (cost=0.00..30.13 rows=1 width=46) (actual time=0.022..2.670 rows=139 loops=130)
                                                                          ->  Nested Loop Left Join  (cost=0.00..21.85 rows=1 width=31) (actual time=0.013..1.406 rows=139 loops=130)
                                                                                ->  Seq Scan on ma mas  (cost=0.00..13.56 rows=1 width=27) (actual time=0.003..0.186 rows=139 loops=130)
                                                                                      Filter: ((ckierunek = 87) AND ((_sect)::integer = 1))
                                                                                ->  Index Scan using pkey_ma on ma mask  (cost=0.00..8.27 rows=1 width=19) (actual time=0.007..0.007 rows=0 loops=18070)
                                                                                      Index Cond: (((mask._sect)::text = (mas._sect)::text) AND (mask._id = mas.lkorygowany))
                                                                          ->  Index Scan using pkey_ma on ma  (cost=0.00..8.27 rows=1 width=15) (actual time=0.008..0.008 rows=1 loops=18070)
                                                                                Index Cond: (((ma._sect)::text = (mas._sect)::text) AND (ma._id = mas._id))
                                                                                Filter: (ma.ckierunek = 87)
                                                                    ->  Index Scan using defidx_b1 on bp bpk  (cost=0.00..0.41 rows=1 width=15) (actual time=0.007..0.007 rows=0 loops=18070)
                                                                          Index Cond: (((bpk._sect)::text = (ma._sect)::text) AND (bpk.lwydanie = ma.lkorygowany))
                                                              ->  Index Scan using defidx_b1 on bp  (cost=0.00..0.41 rows=1 width=27) (actual time=0.007..0.007 rows=1 loops=18070)
                                                                    Index Cond: (((public.bp._sect)::text = (ma._sect)::text) AND (public.bp.lwydanie = ma._id))
                                                  ->  Index Scan using pkey_ma on ma maz  (cost=0.00..8.27 rows=1 width=22) (actual time=0.007..0.008 rows=1 loops=136)
                                                        Index Cond: (((maz._sect)::text = (ma._sect)::text) AND (maz._id = (CASE WHEN (public.bp._id IS NULL) THEN bpk.lprzyjecie ELSE public.bp.lprzyjecie END)))
                                            ->  Index Scan using defidx_2sm on psm psmz  (cost=0.00..1.83 rows=1 width=14) (actual time=0.013..0.013 rows=1 loops=136)
                                                  Index Cond: (psmz.lma = maz._id)
                                      ->  Index Scan using defidx_sk on sz szz  (cost=0.00..2.42 rows=1 width=27) (actual time=0.014..0.014 rows=1 loops=136)
                                            Index Cond: (szz._id = psmz.lsz)
                                ->  Index Scan using pkey_za on za  (cost=0.00..0.35 rows=1 width=22) (actual time=0.006..0.007 rows=1 loops=136)
                                      Index Cond: (((za._sect)::text = (szz._sect)::text) AND (za._id = szz.ltransakcja))
                          ->  Seq Scan on tow  (cost=0.00..3.48 rows=48 width=8) (actual time=0.001..0.006 rows=48 loops=136)
                    ->  Seq Scan on spexp  (cost=0.00..1.09 rows=9 width=18) (actual time=0.001..0.002 rows=9 loops=136)
        ->  Seq Scan on tow  (cost=0.00..3.48 rows=48 width=19) (actual time=0.001..0.004 rows=48 loops=26)
  ->  Index Scan using pkey_jednmiar on jednmiar jm  (cost=0.00..0.52 rows=1 width=7) (actual time=0.002..0.002 rows=1 loops=26)
        Index Cond: (jm._id = public.tow.ljmsprzedaz)
Total runtime: 686.062 ms

Per node type stats

node type	count	sum of times	% of query
HashAggregate	1	1.687 ms	0.2 %
Index Scan	11	534.539 ms	78.0 %
Nested Loop	2	6.693 ms	1.0 %
Nested Loop Left Join	13	116.724 ms	17.0 %
Seq Scan	5	25.595 ms	3.7 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
bp	2	252.980 ms	36.9 %
Index Scan	2	252.980 ms	100.0 %
jednmiar	1	0.052 ms	0.0 %
Index Scan	1	0.052 ms	100.0 %
ma	4	296.318 ms	43.2 %
Index Scan	3	272.138 ms	91.8 %
Seq Scan	1	24.180 ms	8.2 %
psm	2	1.991 ms	0.3 %
Index Scan	1	1.768 ms	88.8 %
Seq Scan	1	0.223 ms	11.2 %
sp	1	1.040 ms	0.2 %
Index Scan	1	1.040 ms	100.0 %
spexp	1	0.272 ms	0.0 %
Seq Scan	1	0.272 ms	100.0 %
sz	2	5.609 ms	0.8 %
Index Scan	2	5.609 ms	100.0 %
tow	2	0.920 ms	0.1 %
Seq Scan	2	0.920 ms	100.0 %
za	1	0.952 ms	0.1 %
Index Scan	1	0.952 ms	100.0 %

explain.depesz.com

A tool for finding a real cause for slow queries.

Result: YO4 : rentownosc

Colorize:

Columns visibility:

Per node type stats

Per table stats