explain.depesz.com

PostgreSQL's explain analyze made readable

Result: fLV

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.826 4,804.162 ↑ 14.1 130 1

Nested Loop Left Join (cost=176,395.14..1,392,615.69 rows=1,838 width=1,382) (actual time=4,500.529..4,804.162 rows=130 loops=1)

  • Output: "*SELECT* 2".artikl_sifra, "*SELECT* 2".is_pasiven, "*SELECT* 2".redoven, "*SELECT* 2".generikanaziv, "*SELECT* 2".artiklnaziv, "*SELECT* 2".komnaziv, "*SELECT* 2".kom_dobavuvac, ((((((COALESCE("*SELECT* 2".rok_godina, '0'::numeric))::text || '/'::text) || (COALESCE("*SELECT* 2".rok_mesec, '0'::numeric))::text) || ' - '::text) || (COALESCE("*SELECT* 2".serija, ''::character varying))::text)), (make_date((NULLIF("*SELECT* 2".rok_godina, '0'::numeric))::integer, CASE WHEN ("*SELECT* 2".rok_godina <> '0'::numeric) THEN LEAST(12, (GREATEST("*SELECT* 2".rok_mesec, '1'::numeric))::integer) ELSE (NULLIF(NULLIF("*SELECT* 2".rok_mesec, '0'::numeric), '99'::numeric))::integer END, 1)), (max("*SELECT* 2".prodazna)), (sum((((("*SELECT* 2".in_vl_iz)::numeric * ((0)::numeric)) * ((("*SELECT* 2".faktor)::integer))::numeric) * ("*SELECT* 2".vlijae)::numeric))), (sum((((("*SELECT* 2".in_vl_iz)::numeric * "*SELECT* 2".kolicinaizlez) * ((("*SELECT* 2".faktor)::integer))::numeric) * ("*SELECT* 2".vlijae)::numeric))), (sum((((((0)::numeric) - "*SELECT* 2".kolicinaizlez) * ((("*SELECT* 2".faktor)::integer))::numeric) * ("*SELECT* 2".vlijae)::numeric))), ((- sum((((((("*SELECT* 2".status <> 'Z'::"char"))::integer)::numeric * (((0)::numeric) - "*SELECT* 2".kolicinaizlez)) * ((("*SELECT* 2".faktor)::integer))::numeric) * ("*SELECT* 2".vlijae)::numeric)))), (sum(((((("*SELECT* 2".in_vl_iz)::numeric * "*SELECT* 2".nabavna) * ((0)::numeric)) / ("*SELECT* 2".parcinja)::numeric) * ((("*SELECT* 2".faktor)::integer))::numeric))), (sum(((((("*SELECT* 2".in_vl_iz)::numeric * "*SELECT* 2".prodazna) * "*SELECT* 2".kolicinaizlez) / ("*SELECT* 2".parcinja)::numeric) * ((("*SELECT* 2".faktor)::integer))::numeric))), "*SELECT* 2".parcinja, "*SELECT* 2".asortiman_id, svc.nabavna, svc.prodazna, svc.maloprodazna, CASE WHEN (svc.nabavna = '0'::numeric) THEN '0'::numeric ELSE (((svc.prodazna - svc.nabavna) / svc.nabavna) * '100'::numeric) END, CASE WHEN (svc.fakturna = '0'::numeric) THEN '0'::numeric ELSE (((svc.prodazna - svc.fakturna) / svc.fakturna) * '100'::numeric) END
  • Buffers: shared hit=353176
2. 36.480 4,499.136 ↑ 14.1 130 1

HashAggregate (cost=175,733.20..175,866.45 rows=1,838 width=1,380) (actual time=4,498.068..4,499.136 rows=130 loops=1)

  • Output: "*SELECT* 2".artikl_sifra, "*SELECT* 2".is_pasiven, "*SELECT* 2".redoven, "*SELECT* 2".generikanaziv, "*SELECT* 2".artiklnaziv, "*SELECT* 2".komnaziv, "*SELECT* 2".kom_dobavuvac, (((((COALESCE("*SELECT* 2".rok_godina, '0'::numeric))::text || '/'::text) || (COALESCE("*SELECT* 2".rok_mesec, '0'::numeric))::text) || ' - '::text) || (COALESCE("*SELECT* 2".serija, ''::character varying))::text), make_date((NULLIF("*SELECT* 2".rok_godina, '0'::numeric))::integer, CASE WHEN ("*SELECT* 2".rok_godina <> '0'::numeric) THEN LEAST(12, (GREATEST("*SELECT* 2".rok_mesec, '1'::numeric))::integer) ELSE (NULLIF(NULLIF("*SELECT* 2".rok_mesec, '0'::numeric), '99'::numeric))::integer END, 1), max("*SELECT* 2".prodazna), sum((((("*SELECT* 2".in_vl_iz)::numeric * ((0)::numeric)) * ((("*SELECT* 2".faktor)::integer))::numeric) * ("*SELECT* 2".vlijae)::numeric)), sum((((("*SELECT* 2".in_vl_iz)::numeric * "*SELECT* 2".kolicinaizlez) * ((("*SELECT* 2".faktor)::integer))::numeric) * ("*SELECT* 2".vlijae)::numeric)), sum((((((0)::numeric) - "*SELECT* 2".kolicinaizlez) * ((("*SELECT* 2".faktor)::integer))::numeric) * ("*SELECT* 2".vlijae)::numeric)), (- sum((((((("*SELECT* 2".status <> 'Z'::"char"))::integer)::numeric * (((0)::numeric) - "*SELECT* 2".kolicinaizlez)) * ((("*SELECT* 2".faktor)::integer))::numeric) * ("*SELECT* 2".vlijae)::numeric))), sum(((((("*SELECT* 2".in_vl_iz)::numeric * "*SELECT* 2".nabavna) * ((0)::numeric)) / ("*SELECT* 2".parcinja)::numeric) * ((("*SELECT* 2".faktor)::integer))::numeric)), sum(((((("*SELECT* 2".in_vl_iz)::numeric * "*SELECT* 2".prodazna) * "*SELECT* 2".kolicinaizlez) / ("*SELECT* 2".parcinja)::numeric) * ((("*SELECT* 2".faktor)::integer))::numeric)), "*SELECT* 2".parcinja, "*SELECT* 2".asortiman_id, "*SELECT* 2".rok_godina, "*SELECT* 2".rok_mesec, "*SELECT* 2".serija
  • Group Key: "*SELECT* 2".artikl_sifra, "*SELECT* 2".is_pasiven, "*SELECT* 2".redoven, "*SELECT* 2".parcinja, "*SELECT* 2".komnaziv, "*SELECT* 2".kom_dobavuvac, "*SELECT* 2".generikanaziv, "*SELECT* 2".artiklnaziv, "*SELECT* 2".asortiman_id, "*SELECT* 2".rok_godina, "*SELECT* 2".rok_mesec, "*SELECT* 2".serija
  • Buffers: shared hit=117664
3. 0.000 4,462.656 ↑ 2.3 3,971 1

Gather (cost=6,064.97..174,286.09 rows=9,188 width=1,247) (actual time=135.826..4,462.656 rows=3,971 loops=1)

  • Output: ((0)::numeric), "*SELECT* 2".kolicinaizlez, "*SELECT* 2".nabavna, "*SELECT* 2".prodazna, (("*SELECT* 2".faktor)::integer), "*SELECT* 2".artikl_sifra, "*SELECT* 2".redoven, "*SELECT* 2".datum_ddo, "*SELECT* 2".status, "*SELECT* 2".sta_izlez_id, "*SELECT* 2".parcinja, "*SELECT* 2".is_pasiven, "*SELECT* 2".artiklnaziv, "*SELECT* 2".komnaziv, "*SELECT* 2".kom_dobavuvac, "*SELECT* 2".generikanaziv, "*SELECT* 2".asortiman_id, "*SELECT* 2".rok_godina, "*SELECT* 2".rok_mesec, "*SELECT* 2".serija, "*SELECT* 2".vlijae, "*SELECT* 2".in_vl_iz
  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared hit=117664
4. 0.000 4,471.231 ↑ 6.9 1,324 3

Parallel Append (cost=5,064.97..172,367.29 rows=9,188 width=1,247) (actual time=646.829..4,471.231 rows=1,324 loops=3)

  • Buffers: shared hit=117664
  • Worker 0: actual time=1680.627..4483.823 rows=1013 loops=1
  • Buffers: shared hit=56006
  • Worker 1: actual time=125.956..4482.213 rows=1493 loops=1
  • Buffers: shared hit=31704
5. 1.165 3,457.998 ↑ 7.7 936 3

Subquery Scan on *SELECT* 2 (cost=50,959.66..131,072.99 rows=7,233 width=166) (actual time=668.728..3,457.998 rows=936 loops=3)

  • Output: 0, "*SELECT* 2".kolicinaizlez, "*SELECT* 2".nabavna, "*SELECT* 2".prodazna, "*SELECT* 2".faktor, "*SELECT* 2".artikl_sifra, "*SELECT* 2".redoven, "*SELECT* 2".datum_ddo, "*SELECT* 2".status, "*SELECT* 2".sta_izlez_id, "*SELECT* 2".parcinja, "*SELECT* 2".is_pasiven, "*SELECT* 2".artiklnaziv, "*SELECT* 2".komnaziv, "*SELECT* 2".kom_dobavuvac, "*SELECT* 2".generikanaziv, "*SELECT* 2".asortiman_id, "*SELECT* 2".rok_godina, "*SELECT* 2".rok_mesec, "*SELECT* 2".serija, "*SELECT* 2".vlijae, "*SELECT* 2".in_vl_iz
  • Buffers: shared hit=86392
  • Worker 0: actual time=1680.626..4483.511 rows=1013 loops=1
  • Buffers: shared hit=56006
  • Worker 1: actual time=168.299..2959.715 rows=909 loops=1
  • Buffers: shared hit=15365
6. 1,324.919 3,456.833 ↑ 3.2 936 3

Hash Left Join (cost=50,959.66..130,964.49 rows=3,014 width=136) (actual time=668.725..3,456.833 rows=936 loops=3)

  • Output: 0, sta_izlez.kolicina, sta_izlez.nabavna, sta_izlez.prodazna, sta_izlez.faktor, sta_izlez.artikl_sifra, tip_dokument.redoven, dok_izlez.datum_ddo, dok_izlez.status, sta_izlez.sta_izlez_id, CASE tip_dokument.redoven WHEN 'F'::"char" THEN COALESCE(NULLIF(lekovi.izdava_parcinja, 0), 1) ELSE (artikli.parcinja)::integer END, (artikli.oznaka_k_r = 'P'::"char"), artikli.naziv, kom.naziv, kom_d.naziv, generici.naziv, artikli.asortiman_id, sta_izlez.rok_godina, sta_izlez.rok_mesec, sta_izlez.serija, sta_izlez.vlijae, ((dok_izlez.datum_ddo >= '2018-01-01'::date))::integer
  • Inner Unique: true
  • Hash Cond: (artikli.generika_id = generici.generika_id)
  • Filter: (((artikli.naziv)::text ~~* 'ceti%'::text) OR ((artikli.sifra)::text ~~* 'ceti%'::text) OR ((kom.naziv)::text ~~* 'ceti%'::text) OR ((generici.naziv)::text ~~* 'ceti%'::text))
  • Rows Removed by Filter: 328158
  • Buffers: shared hit=86392
  • Worker 0: actual time=1680.623..4482.358 rows=1013 loops=1
  • Buffers: shared hit=56006
  • Worker 1: actual time=168.296..2958.655 rows=909 loops=1
  • Buffers: shared hit=15365
7. 157.888 2,131.359 ↓ 1.0 329,094 3

Hash Left Join (cost=50,920.99..130,033.80 rows=322,558 width=126) (actual time=451.467..2,131.359 rows=329,094 loops=3)

  • Output: sta_izlez.kolicina, sta_izlez.nabavna, sta_izlez.prodazna, sta_izlez.faktor, sta_izlez.artikl_sifra, sta_izlez.sta_izlez_id, sta_izlez.rok_godina, sta_izlez.rok_mesec, sta_izlez.serija, sta_izlez.vlijae, dok_izlez.datum_ddo, dok_izlez.status, tip_dokument.redoven, artikli.parcinja, artikli.oznaka_k_r, artikli.naziv, artikli.asortiman_id, artikli.sifra, artikli.generika_id, lekovi.izdava_parcinja, kom.naziv, kom_d.naziv
  • Inner Unique: true
  • Hash Cond: ((artikli.komitent_sifra)::text = (kom_d.sifra)::text)
  • Buffers: shared hit=86362
  • Worker 0: actual time=1191.298..3143.332 rows=331748 loops=1
  • Buffers: shared hit=55996
  • Worker 1: actual time=127.342..1632.036 rows=339027 loops=1
  • Buffers: shared hit=15355
8. 173.424 1,972.543 ↓ 1.0 329,094 3

Hash Left Join (cost=50,843.27..129,108.47 rows=322,558 width=117) (actual time=450.522..1,972.543 rows=329,094 loops=3)

  • Output: sta_izlez.kolicina, sta_izlez.nabavna, sta_izlez.prodazna, sta_izlez.faktor, sta_izlez.artikl_sifra, sta_izlez.sta_izlez_id, sta_izlez.rok_godina, sta_izlez.rok_mesec, sta_izlez.serija, sta_izlez.vlijae, dok_izlez.datum_ddo, dok_izlez.status, tip_dokument.redoven, artikli.parcinja, artikli.oznaka_k_r, artikli.naziv, artikli.asortiman_id, artikli.sifra, artikli.komitent_sifra, artikli.generika_id, lekovi.izdava_parcinja, kom.naziv
  • Inner Unique: true
  • Hash Cond: ((artikli.proizvoditel_kom_sifra)::text = (kom.sifra)::text)
  • Buffers: shared hit=86260
  • Worker 0: actual time=1190.338..2986.477 rows=331748 loops=1
  • Buffers: shared hit=55962
  • Worker 1: actual time=126.347..1473.798 rows=339027 loops=1
  • Buffers: shared hit=15321
9. 148.979 1,798.150 ↓ 1.0 329,094 3

Hash Left Join (cost=50,765.56..128,183.14 rows=322,558 width=108) (actual time=449.533..1,798.150 rows=329,094 loops=3)

  • Output: sta_izlez.kolicina, sta_izlez.nabavna, sta_izlez.prodazna, sta_izlez.faktor, sta_izlez.artikl_sifra, sta_izlez.sta_izlez_id, sta_izlez.rok_godina, sta_izlez.rok_mesec, sta_izlez.serija, sta_izlez.vlijae, dok_izlez.datum_ddo, dok_izlez.status, tip_dokument.redoven, artikli.parcinja, artikli.oznaka_k_r, artikli.naziv, artikli.asortiman_id, artikli.sifra, artikli.proizvoditel_kom_sifra, artikli.komitent_sifra, artikli.generika_id, lekovi.izdava_parcinja
  • Inner Unique: true
  • Hash Cond: (artikli.fzo_sifra = lekovi.lek_id)
  • Buffers: shared hit=86158
  • Worker 0: actual time=1189.260..2810.378 rows=331748 loops=1
  • Buffers: shared hit=55928
  • Worker 1: actual time=125.370..1299.787 rows=339027 loops=1
  • Buffers: shared hit=15287
10. 264.405 1,647.739 ↓ 1.0 329,094 3

Parallel Hash Join (cost=50,643.57..127,214.29 rows=322,558 width=108) (actual time=448.069..1,647.739 rows=329,094 loops=3)

  • Output: sta_izlez.kolicina, sta_izlez.nabavna, sta_izlez.prodazna, sta_izlez.faktor, sta_izlez.artikl_sifra, sta_izlez.sta_izlez_id, sta_izlez.rok_godina, sta_izlez.rok_mesec, sta_izlez.serija, sta_izlez.vlijae, dok_izlez.datum_ddo, dok_izlez.status, tip_dokument.redoven, artikli.parcinja, artikli.oznaka_k_r, artikli.naziv, artikli.asortiman_id, artikli.sifra, artikli.fzo_sifra, artikli.proizvoditel_kom_sifra, artikli.komitent_sifra, artikli.generika_id
  • Inner Unique: true
  • Hash Cond: ((sta_izlez.artikl_sifra)::text = (artikli.sifra)::text)
  • Buffers: shared hit=85993
  • Worker 0: actual time=1187.768..2662.200 rows=331748 loops=1
  • Buffers: shared hit=55873
  • Worker 1: actual time=123.910..1148.476 rows=339027 loops=1
  • Buffers: shared hit=15232
11. 531.689 1,359.912 ↓ 1.0 329,094 3

Parallel Hash Join (cost=48,724.56..124,448.51 rows=322,558 width=48) (actual time=424.239..1,359.912 rows=329,094 loops=3)

  • Output: sta_izlez.kolicina, sta_izlez.nabavna, sta_izlez.prodazna, sta_izlez.faktor, sta_izlez.artikl_sifra, sta_izlez.sta_izlez_id, sta_izlez.rok_godina, sta_izlez.rok_mesec, sta_izlez.serija, sta_izlez.vlijae, dok_izlez.datum_ddo, dok_izlez.status, tip_dokument.redoven
  • Hash Cond: ((sta_izlez.dok_izlez_id = dok_izlez.dok_izlez_id) AND ((sta_izlez.interna_id)::text = (dok_izlez.interna_id)::text))
  • Buffers: shared hit=84882
  • Worker 0: actual time=1116.361..2329.401 rows=331748 loops=1
  • Buffers: shared hit=54762
  • Worker 1: actual time=123.884..884.340 rows=339027 loops=1
  • Buffers: shared hit=15232
12. 464.945 464.945 ↑ 1.2 1,033,692 3

Parallel Seq Scan on public.sta_izlez (cost=0.00..65,801.15 rows=1,292,115 width=48) (actual time=0.008..464.945 rows=1,033,692 loops=3)

  • Output: sta_izlez.kolicina, sta_izlez.nabavna, sta_izlez.prodazna, sta_izlez.faktor, sta_izlez.artikl_sifra, sta_izlez.sta_izlez_id, sta_izlez.rok_godina, sta_izlez.rok_mesec, sta_izlez.serija, sta_izlez.vlijae, sta_izlez.dok_izlez_id, sta_izlez.interna_id
  • Buffers: shared hit=52880
  • Worker 0: actual time=0.010..592.488 rows=1331148 loops=1
  • Buffers: shared hit=22760
  • Worker 1: actual time=0.007..407.877 rows=895056 loops=1
  • Buffers: shared hit=15232
13. 0.000 363.278 ↑ 1.0 168,701 3

Parallel Hash (cost=46,183.89..46,183.89 rows=169,378 width=12) (actual time=363.278..363.278 rows=168,701 loops=3)

  • Output: dok_izlez.datum_ddo, dok_izlez.status, dok_izlez.dok_izlez_id, dok_izlez.interna_id, tip_dokument.redoven
  • Buckets: 524288 Batches: 1 Memory Usage: 28160kB
  • Buffers: shared hit=31988
  • Worker 0: actual time=1089.832..1089.832 rows=506102 loops=1
  • Buffers: shared hit=31988
  • Worker 1: actual time=0.000..0.000 rows=0 loops=1
14. 151.287 892.564 ↓ 3.0 506,102 1

Hash Join (cost=2.42..46,183.89 rows=169,378 width=12) (actual time=430.192..892.564 rows=506,102 loops=1)

  • Output: dok_izlez.datum_ddo, dok_izlez.status, dok_izlez.dok_izlez_id, dok_izlez.interna_id, tip_dokument.redoven
  • Inner Unique: true
  • Hash Cond: ((dok_izlez.tip_dokument_id)::text = (tip_dokument.tip_dokument_id)::text)
  • Buffers: shared hit=31988
  • Worker 0: actual time=430.192..892.564 rows=506102 loops=1
  • Buffers: shared hit=31988
15. 741.220 741.220 ↓ 2.3 506,115 1

Parallel Seq Scan on public.dok_izlez (cost=0.00..45,556.97 rows=224,855 width=14) (actual time=430.085..741.220 rows=506,115 loops=1)

  • Output: dok_izlez.datum_ddo, dok_izlez.status, dok_izlez.dok_izlez_id, dok_izlez.interna_id, dok_izlez.tip_dokument_id
  • Filter: ((dok_izlez.datum_ddo <= '2018-11-19'::date) AND (date_part('YEAR'::text, (dok_izlez.datum_ddo)::timestamp without time zone) >= '2018'::double precision))
  • Rows Removed by Filter: 1122324
  • Buffers: shared hit=31987
  • Worker 0: actual time=430.085..741.220 rows=506115 loops=1
  • Buffers: shared hit=31987
16. 0.015 0.057 ↑ 1.0 55 1

Hash (cost=1.73..1.73 rows=55 width=4) (actual time=0.057..0.057 rows=55 loops=1)

  • Output: tip_dokument.redoven, tip_dokument.tip_dokument_id
  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
  • Buffers: shared hit=1
  • Worker 0: actual time=0.057..0.057 rows=55 loops=1
  • Buffers: shared hit=1
17. 0.042 0.042 ↑ 1.0 55 1

Seq Scan on public.tip_dokument (cost=0.00..1.73 rows=55 width=4) (actual time=0.028..0.042 rows=55 loops=1)

  • Output: tip_dokument.redoven, tip_dokument.tip_dokument_id
  • Filter: tip_dokument.vlijae
  • Rows Removed by Filter: 18
  • Buffers: shared hit=1
  • Worker 0: actual time=0.028..0.042 rows=55 loops=1
  • Buffers: shared hit=1
18. 0.000 23.422 ↑ 1.8 22,062 3

Parallel Hash (cost=1,432.34..1,432.34 rows=38,934 width=60) (actual time=23.422..23.422 rows=22,062 loops=3)

  • Output: artikli.parcinja, artikli.oznaka_k_r, artikli.naziv, artikli.asortiman_id, artikli.sifra, artikli.fzo_sifra, artikli.proizvoditel_kom_sifra, artikli.komitent_sifra, artikli.generika_id
  • Buckets: 131072 Batches: 1 Memory Usage: 6912kB
  • Buffers: shared hit=1043
  • Worker 0: actual time=70.265..70.265 rows=66187 loops=1
  • Buffers: shared hit=1043
  • Worker 1: actual time=0.001..0.001 rows=0 loops=1
19. 29.041 29.041 ↓ 1.7 66,187 1

Parallel Seq Scan on public.artikli (cost=0.00..1,432.34 rows=38,934 width=60) (actual time=0.018..29.041 rows=66,187 loops=1)

  • Output: artikli.parcinja, artikli.oznaka_k_r, artikli.naziv, artikli.asortiman_id, artikli.sifra, artikli.fzo_sifra, artikli.proizvoditel_kom_sifra, artikli.komitent_sifra, artikli.generika_id
  • Buffers: shared hit=1043
  • Worker 0: actual time=0.018..29.041 rows=66187 loops=1
  • Buffers: shared hit=1043
20. 0.678 1.432 ↑ 1.0 2,977 3

Hash (cost=84.77..84.77 rows=2,977 width=8) (actual time=1.432..1.432 rows=2,977 loops=3)

  • Output: lekovi.izdava_parcinja, lekovi.lek_id
  • Buckets: 4096 Batches: 1 Memory Usage: 149kB
  • Buffers: shared hit=165
  • Worker 0: actual time=1.449..1.449 rows=2977 loops=1
  • Buffers: shared hit=55
  • Worker 1: actual time=1.421..1.421 rows=2977 loops=1
  • Buffers: shared hit=55
21. 0.754 0.754 ↑ 1.0 2,977 3

Seq Scan on public.lekovi (cost=0.00..84.77 rows=2,977 width=8) (actual time=0.017..0.754 rows=2,977 loops=3)

  • Output: lekovi.izdava_parcinja, lekovi.lek_id
  • Buffers: shared hit=165
  • Worker 0: actual time=0.033..0.780 rows=2977 loops=1
  • Buffers: shared hit=55
  • Worker 1: actual time=0.009..0.751 rows=2977 loops=1
  • Buffers: shared hit=55
22. 0.530 0.969 ↑ 1.0 1,943 3

Hash (cost=53.43..53.43 rows=1,943 width=21) (actual time=0.969..0.969 rows=1,943 loops=3)

  • Output: kom.naziv, kom.sifra
  • Buckets: 2048 Batches: 1 Memory Usage: 120kB
  • Buffers: shared hit=102
  • Worker 0: actual time=1.053..1.053 rows=1943 loops=1
  • Buffers: shared hit=34
  • Worker 1: actual time=0.951..0.951 rows=1943 loops=1
  • Buffers: shared hit=34
23. 0.439 0.439 ↑ 1.0 1,943 3

Seq Scan on public.komitenti kom (cost=0.00..53.43 rows=1,943 width=21) (actual time=0.013..0.439 rows=1,943 loops=3)

  • Output: kom.naziv, kom.sifra
  • Buffers: shared hit=102
  • Worker 0: actual time=0.024..0.488 rows=1943 loops=1
  • Buffers: shared hit=34
  • Worker 1: actual time=0.007..0.404 rows=1943 loops=1
  • Buffers: shared hit=34
24. 0.525 0.928 ↑ 1.0 1,943 3

Hash (cost=53.43..53.43 rows=1,943 width=21) (actual time=0.928..0.928 rows=1,943 loops=3)

  • Output: kom_d.naziv, kom_d.sifra
  • Buckets: 2048 Batches: 1 Memory Usage: 120kB
  • Buffers: shared hit=102
  • Worker 0: actual time=0.936..0.936 rows=1943 loops=1
  • Buffers: shared hit=34
  • Worker 1: actual time=0.977..0.977 rows=1943 loops=1
  • Buffers: shared hit=34
25. 0.403 0.403 ↑ 1.0 1,943 3

Seq Scan on public.komitenti kom_d (cost=0.00..53.43 rows=1,943 width=21) (actual time=0.008..0.403 rows=1,943 loops=3)

  • Output: kom_d.naziv, kom_d.sifra
  • Buffers: shared hit=102
  • Worker 0: actual time=0.006..0.391 rows=1943 loops=1
  • Buffers: shared hit=34
  • Worker 1: actual time=0.009..0.416 rows=1943 loops=1
  • Buffers: shared hit=34
26. 0.317 0.555 ↑ 1.0 1,274 3

Hash (cost=22.74..22.74 rows=1,274 width=22) (actual time=0.555..0.555 rows=1,274 loops=3)

  • Output: generici.naziv, generici.generika_id
  • Buckets: 2048 Batches: 1 Memory Usage: 86kB
  • Buffers: shared hit=30
  • Worker 0: actual time=0.570..0.571 rows=1274 loops=1
  • Buffers: shared hit=10
  • Worker 1: actual time=0.566..0.566 rows=1274 loops=1
  • Buffers: shared hit=10
27. 0.238 0.238 ↑ 1.0 1,274 3

Seq Scan on public.generici (cost=0.00..22.74 rows=1,274 width=22) (actual time=0.014..0.238 rows=1,274 loops=3)

  • Output: generici.naziv, generici.generika_id
  • Buffers: shared hit=30
  • Worker 0: actual time=0.025..0.241 rows=1274 loops=1
  • Buffers: shared hit=10
  • Worker 1: actual time=0.008..0.231 rows=1274 loops=1
  • Buffers: shared hit=10
28. 0.576 1,519.065 ↑ 3.4 581 2

Subquery Scan on *SELECT* 1 (cost=5,064.97..41,248.36 rows=1,955 width=196) (actual time=129.929..1,519.065 rows=581 loops=2)

  • Output: "*SELECT* 1".kolicinavlez, 0, "*SELECT* 1".nabavna, "*SELECT* 1".prodazna, "*SELECT* 1".faktor, "*SELECT* 1".artikl_sifra, "*SELECT* 1".redoven, "*SELECT* 1".datum_ddo, "*SELECT* 1".status, "*SELECT* 1".sta_vlez_id, "*SELECT* 1".parcinja, "*SELECT* 1".is_pasiven, "*SELECT* 1".artiklnaziv, "*SELECT* 1".komnaziv, "*SELECT* 1".kom_dobavuvac, "*SELECT* 1".generikanaziv, "*SELECT* 1".asortiman_id, "*SELECT* 1".rok_godina, "*SELECT* 1".rok_mesec, "*SELECT* 1".serija, "*SELECT* 1".vlijae, "*SELECT* 1".in_vl_iz
  • Buffers: shared hit=31272
  • Worker 1: actual time=125.955..1521.850 rows=584 loops=1
  • Buffers: shared hit=16339
29. 540.804 1,518.489 ↑ 1.4 581 2

Hash Left Join (cost=5,064.97..41,223.93 rows=815 width=168) (actual time=129.924..1,518.489 rows=581 loops=2)

  • Output: (sta_vlez.kolicina * (CASE tip_dokument_1.redoven WHEN 'F'::"char" THEN CASE WHEN (lekovi_1.izdava_parcinja > 0) THEN lekovi_1.pakovanje ELSE 1 END ELSE (artikli_1.parcinja)::integer END)::numeric), 0, sta_vlez.nabavna, sta_vlez.prodazna, sta_vlez.faktor, sta_vlez.artikl_sifra, tip_dokument_1.redoven, dok_vlez.datum_ddo, dok_vlez.status, sta_vlez.sta_vlez_id, CASE tip_dokument_1.redoven WHEN 'F'::"char" THEN COALESCE(NULLIF(lekovi_1.pakovanje, 0), 1) ELSE (artikli_1.parcinja)::integer END, (artikli_1.oznaka_k_r = 'P'::"char"), artikli_1.naziv, kom_1.naziv, kom_d_1.naziv, generici_1.naziv, artikli_1.asortiman_id, sta_vlez.rok_godina, sta_vlez.rok_mesec, sta_vlez.serija, sta_vlez.vlijae, ((dok_vlez.datum_ddo >= '2018-01-01'::date))::integer
  • Inner Unique: true
  • Hash Cond: (artikli_1.generika_id = generici_1.generika_id)
  • Filter: (((artikli_1.naziv)::text ~~* 'ceti%'::text) OR ((artikli_1.sifra)::text ~~* 'ceti%'::text) OR ((kom_1.naziv)::text ~~* 'ceti%'::text) OR ((generici_1.naziv)::text ~~* 'ceti%'::text))
  • Rows Removed by Filter: 135102
  • Buffers: shared hit=31272
  • Worker 1: actual time=125.950..1521.220 rows=584 loops=1
  • Buffers: shared hit=16339
30. 66.008 976.949 ↓ 1.6 135,683 2

Hash Left Join (cost=5,026.31..40,934.02 rows=87,163 width=135) (actual time=124.609..976.949 rows=135,683 loops=2)

  • Output: sta_vlez.kolicina, sta_vlez.nabavna, sta_vlez.prodazna, sta_vlez.faktor, sta_vlez.artikl_sifra, sta_vlez.sta_vlez_id, sta_vlez.rok_godina, sta_vlez.rok_mesec, sta_vlez.serija, sta_vlez.vlijae, dok_vlez.datum_ddo, dok_vlez.status, tip_dokument_1.redoven, artikli_1.parcinja, artikli_1.oznaka_k_r, artikli_1.naziv, artikli_1.asortiman_id, artikli_1.sifra, artikli_1.generika_id, lekovi_1.izdava_parcinja, lekovi_1.pakovanje, kom_1.naziv, kom_d_1.naziv
  • Inner Unique: true
  • Hash Cond: ((artikli_1.komitent_sifra)::text = (kom_d_1.sifra)::text)
  • Buffers: shared hit=31252
  • Worker 1: actual time=116.499..977.795 rows=138080 loops=1
  • Buffers: shared hit=16329
31. 75.214 906.849 ↓ 1.6 135,683 2

Hash Left Join (cost=4,948.59..40,627.26 rows=87,163 width=126) (actual time=120.492..906.849 rows=135,683 loops=2)

  • Output: sta_vlez.kolicina, sta_vlez.nabavna, sta_vlez.prodazna, sta_vlez.faktor, sta_vlez.artikl_sifra, sta_vlez.sta_vlez_id, sta_vlez.rok_godina, sta_vlez.rok_mesec, sta_vlez.serija, sta_vlez.vlijae, dok_vlez.datum_ddo, dok_vlez.status, tip_dokument_1.redoven, artikli_1.parcinja, artikli_1.oznaka_k_r, artikli_1.naziv, artikli_1.asortiman_id, artikli_1.sifra, artikli_1.komitent_sifra, artikli_1.generika_id, lekovi_1.izdava_parcinja, lekovi_1.pakovanje, kom_1.naziv
  • Inner Unique: true
  • Hash Cond: ((artikli_1.proizvoditel_kom_sifra)::text = (kom_1.sifra)::text)
  • Buffers: shared hit=31184
  • Worker 1: actual time=115.451..911.027 rows=138080 loops=1
  • Buffers: shared hit=16295
32. 66.578 830.656 ↓ 1.6 135,683 2

Hash Left Join (cost=4,870.87..40,320.49 rows=87,163 width=117) (actual time=119.494..830.656 rows=135,683 loops=2)

  • Output: sta_vlez.kolicina, sta_vlez.nabavna, sta_vlez.prodazna, sta_vlez.faktor, sta_vlez.artikl_sifra, sta_vlez.sta_vlez_id, sta_vlez.rok_godina, sta_vlez.rok_mesec, sta_vlez.serija, sta_vlez.vlijae, dok_vlez.datum_ddo, dok_vlez.status, tip_dokument_1.redoven, artikli_1.parcinja, artikli_1.oznaka_k_r, artikli_1.naziv, artikli_1.asortiman_id, artikli_1.sifra, artikli_1.proizvoditel_kom_sifra, artikli_1.komitent_sifra, artikli_1.generika_id, lekovi_1.izdava_parcinja, lekovi_1.pakovanje
  • Inner Unique: true
  • Hash Cond: (artikli_1.fzo_sifra = lekovi_1.lek_id)
  • Buffers: shared hit=31116
  • Worker 1: actual time=114.387..834.388 rows=138080 loops=1
  • Buffers: shared hit=16261
33. 128.814 762.477 ↓ 1.6 135,683 2

Parallel Hash Join (cost=4,748.89..39,969.66 rows=87,163 width=113) (actual time=117.841..762.477 rows=135,683 loops=2)

  • Output: sta_vlez.kolicina, sta_vlez.nabavna, sta_vlez.prodazna, sta_vlez.faktor, sta_vlez.artikl_sifra, sta_vlez.sta_vlez_id, sta_vlez.rok_godina, sta_vlez.rok_mesec, sta_vlez.serija, sta_vlez.vlijae, dok_vlez.datum_ddo, dok_vlez.status, tip_dokument_1.redoven, artikli_1.parcinja, artikli_1.oznaka_k_r, artikli_1.naziv, artikli_1.asortiman_id, artikli_1.sifra, artikli_1.fzo_sifra, artikli_1.proizvoditel_kom_sifra, artikli_1.komitent_sifra, artikli_1.generika_id
  • Inner Unique: true
  • Hash Cond: ((sta_vlez.artikl_sifra)::text = (artikli_1.sifra)::text)
  • Buffers: shared hit=31006
  • Worker 1: actual time=112.518..763.509 rows=138080 loops=1
  • Buffers: shared hit=16206
34. 64.701 593.043 ↓ 1.6 135,683 2

Hash Join (cost=2,829.88..37,821.84 rows=87,163 width=53) (actual time=69.928..593.043 rows=135,683 loops=2)

  • Output: sta_vlez.kolicina, sta_vlez.nabavna, sta_vlez.prodazna, sta_vlez.faktor, sta_vlez.artikl_sifra, sta_vlez.sta_vlez_id, sta_vlez.rok_godina, sta_vlez.rok_mesec, sta_vlez.serija, sta_vlez.vlijae, dok_vlez.datum_ddo, dok_vlez.status, tip_dokument_1.redoven
  • Inner Unique: true
  • Hash Cond: ((dok_vlez.tip_dokument_id)::text = (tip_dokument_1.tip_dokument_id)::text)
  • Buffers: shared hit=29895
  • Worker 1: actual time=68.166..598.216 rows=138080 loops=1
  • Buffers: shared hit=15589
35. 182.477 528.259 ↓ 1.0 136,384 2

Parallel Hash Join (cost=2,827.21..37,454.23 rows=132,054 width=55) (actual time=69.829..528.259 rows=136,384 loops=2)

  • Output: sta_vlez.kolicina, sta_vlez.nabavna, sta_vlez.prodazna, sta_vlez.faktor, sta_vlez.artikl_sifra, sta_vlez.sta_vlez_id, sta_vlez.rok_godina, sta_vlez.rok_mesec, sta_vlez.serija, sta_vlez.vlijae, dok_vlez.datum_ddo, dok_vlez.status, dok_vlez.tip_dokument_id
  • Inner Unique: true
  • Hash Cond: ((sta_vlez.dok_vlez_id = dok_vlez.dok_vlez_id) AND ((sta_vlez.interna_id)::text = (dok_vlez.interna_id)::text))
  • Buffers: shared hit=29890
  • Worker 1: actual time=68.038..534.543 rows=138807 loops=1
  • Buffers: shared hit=15585
36. 324.567 324.567 ↓ 1.2 525,718 2

Parallel Seq Scan on public.sta_vlez (cost=0.00..32,326.99 rows=438,099 width=53) (actual time=0.006..324.567 rows=525,718 loops=2)

  • Output: sta_vlez.kolicina, sta_vlez.nabavna, sta_vlez.prodazna, sta_vlez.faktor, sta_vlez.artikl_sifra, sta_vlez.sta_vlez_id, sta_vlez.rok_godina, sta_vlez.rok_mesec, sta_vlez.serija, sta_vlez.vlijae, sta_vlez.dok_vlez_id, sta_vlez.interna_id
  • Buffers: shared hit=27946
  • Worker 1: actual time=0.007..342.149 rows=551114 loops=1
  • Buffers: shared hit=14650
37. 4.809 21.215 ↑ 1.2 9,299 2

Parallel Hash (cost=2,661.78..2,661.78 rows=11,029 width=14) (actual time=21.215..21.215 rows=9,299 loops=2)

  • Output: dok_vlez.datum_ddo, dok_vlez.status, dok_vlez.dok_vlez_id, dok_vlez.interna_id, dok_vlez.tip_dokument_id
  • Buckets: 32768 Batches: 1 Memory Usage: 1312kB
  • Buffers: shared hit=1930
  • Worker 1: actual time=21.230..21.230 rows=8217 loops=1
  • Buffers: shared hit=921
38. 16.406 16.406 ↑ 1.2 9,299 2

Parallel Seq Scan on public.dok_vlez (cost=0.00..2,661.78 rows=11,029 width=14) (actual time=0.800..16.406 rows=9,299 loops=2)

  • Output: dok_vlez.datum_ddo, dok_vlez.status, dok_vlez.dok_vlez_id, dok_vlez.interna_id, dok_vlez.tip_dokument_id
  • Filter: ((dok_vlez.datum_ddo <= '2018-11-19'::date) AND (date_part('YEAR'::text, (dok_vlez.datum_ddo)::timestamp without time zone) >= '2018'::double precision))
  • Rows Removed by Filter: 21802
  • Buffers: shared hit=1930
  • Worker 1: actual time=0.807..16.078 rows=8217 loops=1
  • Buffers: shared hit=921
39. 0.013 0.083 ↑ 1.0 52 2

Hash (cost=2.00..2.00 rows=53 width=4) (actual time=0.083..0.083 rows=52 loops=2)

  • Output: tip_dokument_1.redoven, tip_dokument_1.tip_dokument_id
  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
  • Buffers: shared hit=5
  • Worker 1: actual time=0.105..0.105 rows=52 loops=1
  • Buffers: shared hit=4
40. 0.070 0.070 ↑ 1.0 52 2

Seq Scan on public.tip_dokument tip_dokument_1 (cost=0.00..2.00 rows=53 width=4) (actual time=0.047..0.070 rows=52 loops=2)

  • Output: tip_dokument_1.redoven, tip_dokument_1.tip_dokument_id
  • Filter: (tip_dokument_1.vlijae AND ((tip_dokument_1.tip_dokument_id)::text <> ALL ('{Z1,Z2,Z3}'::text[])))
  • Rows Removed by Filter: 21
  • Buffers: shared hit=5
  • Worker 1: actual time=0.067..0.091 rows=52 loops=1
  • Buffers: shared hit=4
41. 25.953 40.620 ↑ 1.2 33,094 2

Parallel Hash (cost=1,432.34..1,432.34 rows=38,934 width=60) (actual time=40.620..40.620 rows=33,094 loops=2)

  • Output: artikli_1.parcinja, artikli_1.oznaka_k_r, artikli_1.naziv, artikli_1.asortiman_id, artikli_1.sifra, artikli_1.fzo_sifra, artikli_1.proizvoditel_kom_sifra, artikli_1.komitent_sifra, artikli_1.generika_id
  • Buckets: 131072 Batches: 1 Memory Usage: 6912kB
  • Buffers: shared hit=1043
  • Worker 1: actual time=44.160..44.160 rows=34772 loops=1
  • Buffers: shared hit=549
42. 14.667 14.667 ↑ 1.2 33,094 2

Parallel Seq Scan on public.artikli artikli_1 (cost=0.00..1,432.34 rows=38,934 width=60) (actual time=0.011..14.667 rows=33,094 loops=2)

  • Output: artikli_1.parcinja, artikli_1.oznaka_k_r, artikli_1.naziv, artikli_1.asortiman_id, artikli_1.sifra, artikli_1.fzo_sifra, artikli_1.proizvoditel_kom_sifra, artikli_1.komitent_sifra, artikli_1.generika_id
  • Buffers: shared hit=1043
  • Worker 1: actual time=0.012..14.724 rows=34772 loops=1
  • Buffers: shared hit=549
43. 0.753 1.601 ↑ 1.0 2,977 2

Hash (cost=84.77..84.77 rows=2,977 width=12) (actual time=1.601..1.601 rows=2,977 loops=2)

  • Output: lekovi_1.izdava_parcinja, lekovi_1.pakovanje, lekovi_1.lek_id
  • Buckets: 4096 Batches: 1 Memory Usage: 160kB
  • Buffers: shared hit=110
  • Worker 1: actual time=1.777..1.777 rows=2977 loops=1
  • Buffers: shared hit=55
44. 0.848 0.848 ↑ 1.0 2,977 2

Seq Scan on public.lekovi lekovi_1 (cost=0.00..84.77 rows=2,977 width=12) (actual time=0.018..0.848 rows=2,977 loops=2)

  • Output: lekovi_1.izdava_parcinja, lekovi_1.pakovanje, lekovi_1.lek_id
  • Buffers: shared hit=110
  • Worker 1: actual time=0.026..0.933 rows=2977 loops=1
  • Buffers: shared hit=55
45. 0.493 0.979 ↑ 1.0 1,943 2

Hash (cost=53.43..53.43 rows=1,943 width=21) (actual time=0.979..0.979 rows=1,943 loops=2)

  • Output: kom_1.naziv, kom_1.sifra
  • Buckets: 2048 Batches: 1 Memory Usage: 120kB
  • Buffers: shared hit=68
  • Worker 1: actual time=1.034..1.034 rows=1943 loops=1
  • Buffers: shared hit=34
46. 0.486 0.486 ↑ 1.0 1,943 2

Seq Scan on public.komitenti kom_1 (cost=0.00..53.43 rows=1,943 width=21) (actual time=0.020..0.486 rows=1,943 loops=2)

  • Output: kom_1.naziv, kom_1.sifra
  • Buffers: shared hit=68
  • Worker 1: actual time=0.032..0.538 rows=1943 loops=1
  • Buffers: shared hit=34
47. 0.550 4.092 ↑ 1.0 1,943 2

Hash (cost=53.43..53.43 rows=1,943 width=21) (actual time=4.092..4.092 rows=1,943 loops=2)

  • Output: kom_d_1.naziv, kom_d_1.sifra
  • Buckets: 2048 Batches: 1 Memory Usage: 120kB
  • Buffers: shared hit=68
  • Worker 1: actual time=1.019..1.019 rows=1943 loops=1
  • Buffers: shared hit=34
48. 3.542 3.542 ↑ 1.0 1,943 2

Seq Scan on public.komitenti kom_d_1 (cost=0.00..53.43 rows=1,943 width=21) (actual time=0.008..3.542 rows=1,943 loops=2)

  • Output: kom_d_1.naziv, kom_d_1.sifra
  • Buffers: shared hit=68
  • Worker 1: actual time=0.009..0.474 rows=1943 loops=1
  • Buffers: shared hit=34
49. 0.395 0.736 ↑ 1.0 1,274 2

Hash (cost=22.74..22.74 rows=1,274 width=22) (actual time=0.736..0.736 rows=1,274 loops=2)

  • Output: generici_1.naziv, generici_1.generika_id
  • Buckets: 2048 Batches: 1 Memory Usage: 86kB
  • Buffers: shared hit=20
  • Worker 1: actual time=0.644..0.644 rows=1274 loops=1
  • Buffers: shared hit=10
50. 0.341 0.341 ↑ 1.0 1,274 2

Seq Scan on public.generici generici_1 (cost=0.00..22.74 rows=1,274 width=22) (actual time=0.031..0.341 rows=1,274 loops=2)

  • Output: generici_1.naziv, generici_1.generika_id
  • Buffers: shared hit=20
  • Worker 1: actual time=0.024..0.288 rows=1274 loops=1
  • Buffers: shared hit=10
51. 0.130 304.200 ↑ 1.0 1 130

Subquery Scan on svc (cost=661.94..661.96 rows=1 width=34) (actual time=2.338..2.340 rows=1 loops=130)

  • Output: svc.fakturna, svc.nabavna, svc.prodazna, svc.maloprodazna, svc.artikl_sifra, dok_vlez_1.datum_ddo, tip_dokument_2.pozitiven, sta_vlez_1.modified
  • Filter: (("*SELECT* 2".artikl_sifra)::text = (svc.artikl_sifra)::text)
  • Buffers: shared hit=235512
52. 0.520 304.070 ↑ 1.0 1 130

Limit (cost=661.94..661.94 rows=1 width=47) (actual time=2.337..2.339 rows=1 loops=130)

  • Output: sta_vlez_1.fakturna, sta_vlez_1.nabavna, sta_vlez_1.prodazna, sta_vlez_1.maloprodazna, sta_vlez_1.artikl_sifra, dok_vlez_1.datum_ddo, tip_dokument_2.pozitiven, sta_vlez_1.modified
  • Buffers: shared hit=235512
53. 10.530 303.550 ↑ 8.0 1 130

Sort (cost=661.94..661.96 rows=8 width=47) (actual time=2.335..2.335 rows=1 loops=130)

  • Output: sta_vlez_1.fakturna, sta_vlez_1.nabavna, sta_vlez_1.prodazna, sta_vlez_1.maloprodazna, sta_vlez_1.artikl_sifra, dok_vlez_1.datum_ddo, tip_dokument_2.pozitiven, sta_vlez_1.modified
  • Sort Key: dok_vlez_1.datum_ddo DESC, tip_dokument_2.pozitiven DESC, sta_vlez_1.modified DESC
  • Sort Method: top-N heapsort Memory: 25kB
  • Buffers: shared hit=235512
54. 13.390 293.020 ↓ 25.6 205 130

Hash Join (cost=7.23..661.90 rows=8 width=47) (actual time=0.148..2.254 rows=205 loops=130)

  • Output: sta_vlez_1.fakturna, sta_vlez_1.nabavna, sta_vlez_1.prodazna, sta_vlez_1.maloprodazna, sta_vlez_1.artikl_sifra, dok_vlez_1.datum_ddo, tip_dokument_2.pozitiven, sta_vlez_1.modified
  • Inner Unique: true
  • Hash Cond: ((dok_vlez_1.tip_dokument_id)::text = (tip_dokument_2.tip_dokument_id)::text)
  • Buffers: shared hit=235512
55. 1.403 276.770 ↓ 8.9 455 130

Nested Loop (cost=5.15..659.68 rows=51 width=49) (actual time=0.118..2.129 rows=455 loops=130)

  • Output: sta_vlez_1.fakturna, sta_vlez_1.nabavna, sta_vlez_1.prodazna, sta_vlez_1.maloprodazna, sta_vlez_1.artikl_sifra, sta_vlez_1.modified, dok_vlez_1.datum_ddo, dok_vlez_1.tip_dokument_id
  • Inner Unique: true
  • Buffers: shared hit=235382
56. 90.220 97.890 ↓ 8.1 455 130

Bitmap Heap Scan on public.sta_vlez sta_vlez_1 (cost=4.86..222.04 rows=56 width=48) (actual time=0.111..0.753 rows=455 loops=130)

  • Output: sta_vlez_1.fakturna, sta_vlez_1.nabavna, sta_vlez_1.prodazna, sta_vlez_1.maloprodazna, sta_vlez_1.artikl_sifra, sta_vlez_1.modified, sta_vlez_1.dok_vlez_id, sta_vlez_1.interna_id
  • Recheck Cond: ((sta_vlez_1.artikl_sifra)::text = ("*SELECT* 2".artikl_sifra)::text)
  • Heap Blocks: exact=57184
  • Buffers: shared hit=57799
57. 7.670 7.670 ↓ 8.1 455 130

Bitmap Index Scan on sta_vlez_art_serija_vlijae_index (cost=0.00..4.85 rows=56 width=0) (actual time=0.059..0.059 rows=455 loops=130)

  • Index Cond: ((sta_vlez_1.artikl_sifra)::text = ("*SELECT* 2".artikl_sifra)::text)
  • Buffers: shared hit=615
58. 177.477 177.477 ↑ 1.0 1 59,159

Index Scan using dok_vlez_pkey on public.dok_vlez dok_vlez_1 (cost=0.29..7.81 rows=1 width=13) (actual time=0.003..0.003 rows=1 loops=59,159)

  • Output: dok_vlez_1.datum_ddo, dok_vlez_1.dok_vlez_id, dok_vlez_1.interna_id, dok_vlez_1.tip_dokument_id
  • Index Cond: ((dok_vlez_1.dok_vlez_id = sta_vlez_1.dok_vlez_id) AND ((dok_vlez_1.interna_id)::text = (sta_vlez_1.interna_id)::text))
  • Filter: (dok_vlez_1.datum_ddo <= now())
  • Buffers: shared hit=177583
59. 0.910 2.860 ↓ 1.1 14 130

Hash (cost=1.91..1.91 rows=13 width=4) (actual time=0.022..0.022 rows=14 loops=130)

  • Output: tip_dokument_2.pozitiven, tip_dokument_2.tip_dokument_id
  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=130
60. 1.950 1.950 ↓ 1.1 14 130

Seq Scan on public.tip_dokument tip_dokument_2 (cost=0.00..1.91 rows=13 width=4) (actual time=0.006..0.015 rows=14 loops=130)

  • Output: tip_dokument_2.pozitiven, tip_dokument_2.tip_dokument_id
  • Filter: (tip_dokument_2.vlijae_cena AND (tip_dokument_2.redoven = "*SELECT* 2".redoven))
  • Rows Removed by Filter: 59
  • Buffers: shared hit=130