vvs4

Change label
Query Plan as raw text
Summary
Time Node
Node (ms) Percent
79469.530 100.00% 
 Limit (cost=56613.18..56614.17 rows=396 width=424) (actual time=79467.940..79469.530 rows=501 loops=1)
79469.040 100.00% 
   -> Sort (cost=56613.18..56614.17 rows=397 width=424) (actual time=79467.930..79469.040 rows=502 loops=1)
         Sort Key: gravacao.dt_inicio
75934.060 95.55% 
         -> Hash Join (cost=56511.38..56596.06 rows=397 width=424) (actual time=60230.070..75934.060 rows=86168 loops=1)
               Hash Cond: ("outer".id_gravador_tela = "inner".id_gravador)
73303.570 92.24% 
               -> Hash Join (cost=56422.35..56504.99 rows=397 width=403) (actual time=60190.580..73303.570 rows=86168 loops=1)
                     Hash Cond: ("outer".id_gravacao = "inner".id_gravacao)
                     Join Filter: (("outer".id_canal = "inner".id_canal) AND ("outer".id_entidade = "inner".id_entidade) AND ("outer".id_operador = "inner".id_operador))
69612.600 87.60% 
                     -> Hash Join (cost=56417.67..56498.33 rows=397 width=340) (actual time=60087.710..69612.600 rows=86168 loops=1)
                           Hash Cond: ("outer".id_site = "inner".id_site)
66007.380 83.06% 
                           -> Merge Join (cost=56414.63..56488.34 rows=397 width=323) (actual time=60027.040..66007.380 rows=86168 loops=1)
                                 Merge Cond: ("outer".id_gravador = "inner".id_gravador)
60528.050 76.17% 
                                 -> Sort (cost=56414.63..56415.62 rows=397 width=298) (actual time=60026.360..60528.050 rows=86168 loops=1)
                                       Sort Key: gravacao.id_gravador
58649.130 73.80% 
                                       -> Nested Loop (cost=0.0..56397.51 rows=397 width=298) (actual time=189.030..58649.130 rows=86168 loops=1)
4148.930 5.22% 
                                             -> Index Scan using xie_teste_vvs on grav_gravacao gravacao (cost=0.0..9328.53 rows=4343 width=270) (actual time=142.050..4148.930 rows=6423 loops=1)
                                                   Index Cond: ((dt_inicio >= '2008-09-25 00:00:00'::timestamp without time zone) AND (dt_inicio <= '2008-09-25 23:59:59'::timestamp without time zone))
52283.220 65.79% 
                                             -> Index Scan using xie2grav_gravcanal on grav_gravcanal ggc (cost=0.0..10.81 rows=2 width=28) (actual time=4.230..8.140 rows=13 loops=6423)
                                                   Index Cond: (("outer".id_entidade = ggc.id_entidade) AND ("outer".id_gravacao = ggc.id_gravacao))
2296.980 2.89% 
                                 -> Index Scan using xpkgrav_gravador on grav_gravador gg (cost=0.0..89.02 rows=4 width=25) (actual time=0.370..2296.980 rows=86170 loops=1)
60.540 0.08% 
                           -> Hash (cost=3.03..3.03 rows=3 width=17) (actual time=60.540..60.540 rows=0 loops=1)
60.520 0.08% 
                                 -> Index Scan using xpksite_site on site_site ss (cost=0.0..3.03 rows=3 width=17) (actual time=60.490..60.520 rows=3 loops=1)
102.750 0.13% 
                     -> Hash (cost=4.68..4.68 rows=1 width=63) (actual time=102.750..102.750 rows=0 loops=1)
102.730 0.13% 
                           -> Index Scan using xpkgrav_documento on grav_documento gd (cost=0.0..4.68 rows=1 width=63) (actual time=102.710..102.730 rows=1 loops=1)
39.380 0.05% 
               -> Hash (cost=89.02..89.02 rows=4 width=21) (actual time=39.380..39.380 rows=0 loops=1)
39.330 0.05% 
                     -> Index Scan using xpkgrav_gravador on grav_gravador ggt (cost=0.0..89.02 rows=4 width=21) (actual time=0.610..39.330 rows=4 loops=1)
 Total runtime: 85479.01 msec