Administrace komentářů

QUERY PLAN
-------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Aggregate  (cost=27666.09..27666.11 rows=1 width=4) (actual time=95.882..95.883 rows=1 loops=1)
   ->  Nested Loop  (cost=6.01..27666.09 rows=1 width=4) (actual time=18.954..95.862 rows=22 loops=1)
         ->  Nested Loop  (cost=6.01..27586.29 rows=267 width=8) (actual time=18.472..86.896 rows=2002 loops=1)
               ->  Index Scan using vydejdl_idprodejny_idx on vydejdl vydejdl2_  (cost=0.00..583.21 rows=39 width=4) (actual time=18.391..18.967 rows=122 loops=1)
                     Index Cond: (idprodejny = 317)
                     Filter: (datum >= '2010-03-29 00:00:00+02'::timestamp with time zone)
               ->  Bitmap Heap Scan on vydejpol vydejpol0_  (cost=6.01..689.74 rows=212 width=12) (actual time=0.531..0.546 rows=16 loops=122)
                     Recheck Cond: (vydejpol0_.iddl = vydejdl2_.iddl)
                     Filter: (vydejpol0_.typradku = 'Z'::bpchar)
                     ->  Bitmap Index Scan on vydejpol_iddl  (cost=0.00..5.98 rows=212 width=0) (actual time=0.523..0.523 rows=24 loops=122)
                           Index Cond: (vydejpol0_.iddl = vydejdl2_.iddl)
         ->  Index Scan using pkey_idzbozi on zbozi zbozi1_  (cost=0.00..0.29 rows=1 width=4) (actual time=0.004..0.004 rows=0 loops=2002)
               Index Cond: (zbozi1_.idzbozi = vydejpol0_.idzbozi)
               Filter: (zbozi1_.idzatrid = 53)
 Total runtime: 95.971 ms
(15 rows)

 QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Sort  (cost=3349.08..3349.08 rows=1 width=211) (actual time=9332.918..9332.952 rows=138 loops=1)
   Sort Key: zb.nazevzbozi
   Sort Method:  quicksort  Memory: 49kB
   ->  Nested Loop Left Join  (cost=1834.64..3349.07 rows=1 width=211) (actual time=66.152..9331.983 rows=138 loops=1)
         Join Filter: (zb.idzbozi = zb_cenik.idzbozi)
         ->  Nested Loop Left Join  (cost=1564.44..2993.79 rows=1 width=187) (actual time=53.922..8986.338 rows=138 loops=1)
               ->  Nested Loop Left Join  (cost=1564.44..2993.33 rows=1 width=171) (actual time=53.892..8984.451 rows=138 loops=1)
                     Join Filter: (zb.idzbozi = zs.idzbozi)
                     ->  Nested Loop Left Join  (cost=4.42..269.13 rows=1 width=49) (actual time=13.984..252.988 rows=138 loops=1)
                           Join Filter: (substr((li.klic)::text, 1, 4) = (ra.klic)::text)
                           ->  Nested Loop Left Join  (cost=4.42..177.53 rows=1 width=55) (actual time=13.962..112.700 rows=138 loops=1)
                                 Join Filter: (zn.idzatrid = zna.idznacky)
                                 ->  Nested Loop  (cost=4.42..174.46 rows=1 width=59) (actual time=13.931..109.832 rows=138 loops=1)
                                       ->  Nested Loop  (cost=0.00..89.30 rows=1 width=14) (actual time=0.089..1.148 rows=12 loops=1)
                                             Join Filter: (substr((li.klic)::text, 1, 2) = (zn.klic)::text)
                                             ->  Index Scan using pkey_idzatrid on zatrid zn  (cost=0.00..8.27 rows=1 width=10) (actual time=0.038..0.040 rows=1 loops=1)
                                                   Index Cond: (idzatrid = 1)
                                             ->  Seq Scan on zatrid li  (cost=0.00..80.96 rows=5 width=10) (actual time=0.044..0.654 rows=798 loops=1)
                                                   Filter: (length((li.klic)::text) = 6)
                                       ->  Bitmap Heap Scan on zbozi zb  (cost=4.42..84.88 rows=22 width=53) (actual time=8.969..9.040 rows=12 loops=12)
                                             Recheck Cond: (zb.idzatrid = li.idzatrid)
                                             Filter: (zb.typkarty = 'Z'::bpchar)
                                             ->  Bitmap Index Scan on zbozi_idzatrid_idx  (cost=0.00..4.42 rows=22 width=0) (actual time=8.934..8.934 rows=34 loops=12)
                                                   Index Cond: (zb.idzatrid = li.idzatrid)
                                 ->  Seq Scan on znacky zna  (cost=0.00..3.05 rows=1 width=4) (actual time=0.010..0.018 rows=1 loops=138)
                                       Filter: (zna.idznacky = 1)
                           ->  Seq Scan on zatrid ra  (cost=0.00..75.64 rows=1064 width=6) (actual time=0.006..0.363 rows=1064 loops=138)
                     ->  Hash Left Join  (cost=1560.01..2723.68 rows=23 width=50) (actual time=0.293..58.861 rows=14735 loops=138)
                           Hash Cond: (zs.idstatuszb = sz.idstatuszb)
                           ->  Merge Join  (cost=1556.48..2719.84 rows=23 width=12) (actual time=0.290..42.820 rows=14735 loops=138)
                                 Merge Cond: (zs.idzbozi = zb_statusy.idzbozi)
                                 Join Filter: (zs.zmeneno = (max(zb_statusy.zmeneno)))
                                 ->  Index Scan using zb_statusy_idzbozi on zb_statusy zs  (cost=0.00..782.79 rows=19028 width=12) (actual time=0.012..12.367 rows=19040 loops=138)
                                 ->  Sort  (cost=1556.48..1588.66 rows=12870 width=8) (actual time=0.277..5.505 rows=19040 loops=138)
                                       Sort Key: zb_statusy.idzbozi
                                       Sort Method:  quicksort  Memory: 832kB
                                       ->  HashAggregate  (cost=388.42..549.30 rows=12870 width=8) (actual time=18.613..25.000 rows=14735 loops=1)
                                             ->  Seq Scan on zb_statusy  (cost=0.00..293.28 rows=19028 width=8) (actual time=0.006..6.174 rows=19040 loops=1)
                           ->  Hash  (cost=3.47..3.47 rows=5 width=42) (actual time=0.086..0.086 rows=5 loops=1)
                                 ->  Hash Left Join  (cost=2.35..3.47 rows=5 width=42) (actual time=0.075..0.082 rows=5 loops=1)
                                       Hash Cond: (sz.idkodpopis = ko.idkodpopis)
                                       ->  Seq Scan on statusy_zb sz  (cost=0.00..1.05 rows=5 width=42) (actual time=0.005..0.005 rows=5 loops=1)
                                       ->  Hash  (cost=1.60..1.60 rows=60 width=8) (actual time=0.063..0.063 rows=60 loops=1)
                                             ->  Seq Scan on ikodypopis ko  (cost=0.00..1.60 rows=60 width=8) (actual time=0.007..0.033 rows=60 loops=1)
               ->  Index Scan using zb_ceny_idzbozi on zb_ceny  (cost=0.00..0.45 rows=1 width=20) (actual time=0.011..0.012 rows=1 loops=138)
                     Index Cond: (zb.idzbozi = zb_ceny.idzbozi)
                     Filter: ((zb_ceny.typceny = 1) AND (('now'::text)::date >= zb_ceny.platiod) AND (('now'::text)::date <= COALESCE(zb_ceny.platido, '2100-01-01'::date)))
         ->  HashAggregate  (cost=270.20..324.64 rows=1361 width=8) (actual time=0.072..1.643 rows=2980 loops=138)
               ->  Seq Scan on zb_cenik  (cost=0.00..217.23 rows=3027 width=8) (actual time=0.013..4.594 rows=5964 loops=1)
                     Filter: (('2011-03-30'::date >= platiod) AND ('2011-03-30'::date <= COALESCE(platido, '2100-01-01'::date)))
 Total runtime: 9333.427 ms
(51 rows)