explain.depesz.com

A tool for finding a real cause for slow queries.

Result: YO4 : rentownosc

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# 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)