vvs2

Change label
Query Plan as raw text
Summary
Time Node
Node (ms) Percent
41812.280 100.00% 
 Limit (cost=50763.57..50764.43 rows=347 width=404) (actual time=41805.740..41812.280 rows=501 loops=1)
41811.790 100.00% 
   -> Sort (cost=50763.57..50764.43 rows=347 width=404) (actual time=41805.730..41811.790 rows=502 loops=1)
         Sort Key: gravacao.dt_inicio
37828.120 90.47% 
         -> Hash Join (cost=50672.26..50748.92 rows=347 width=404) (actual time=23995.720..37828.120 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) AND ("outer".id_gravador = "outer".id_gravador_tela))
34779.360 83.18% 
               -> Hash Join (cost=50667.58..50742.51 rows=347 width=341) (actual time=23925.670..34779.360 rows=86168 loops=1)
                     Hash Cond: ("outer".id_site = "inner".id_site)
30872.340 73.84% 
                     -> Merge Join (cost=50664.54..50733.39 rows=347 width=324) (actual time=23925.200..30872.340 rows=86168 loops=1)
                           Merge Cond: ("outer".id_gravador = "inner".id_gravador)
24453.970 58.49% 
                           -> Sort (cost=50664.54..50665.41 rows=347 width=299) (actual time=23924.510..24453.970 rows=86168 loops=1)
                                 Sort Key: gravacao.id_gravador
22225.000 53.15% 
                                 -> Nested Loop (cost=0.0..50649.9 rows=347 width=299) (actual time=1.030..22225.000 rows=86168 loops=1)
1651.790 3.95% 
                                       -> Index Scan using xie_teste_vvs on grav_gravacao gravacao (cost=0.0..7121.77 rows=3636 width=271) (actual time=0.620..1651.790 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))
18177.090 43.47% 
                                       -> Index Scan using xie2grav_gravcanal on grav_gravcanal ggc (cost=0.0..11.93 rows=2 width=28) (actual time=2.300..2.830 rows=13 loops=6423)
                                             Index Cond: (("outer".id_entidade = ggc.id_entidade) AND ("outer".id_gravacao = ggc.id_gravacao))
3111.580 7.44% 
                           -> Index Scan using xpkgrav_gravador on grav_gravador gg (cost=0.0..83.69 rows=4 width=25) (actual time=0.370..3111.580 rows=86170 loops=1)
0.320 0.00% 
                     -> Hash (cost=3.03..3.03 rows=3 width=17) (actual time=0.320..0.320 rows=0 loops=1)
0.310 0.00% 
                           -> Index Scan using xpksite_site on site_site ss (cost=0.0..3.03 rows=3 width=17) (actual time=0.300..0.310 rows=3 loops=1)
69.950 0.17% 
               -> Hash (cost=4.68..4.68 rows=1 width=63) (actual time=69.950..69.950 rows=0 loops=1)
69.930 0.17% 
                     -> Index Scan using xpkgrav_documento on grav_documento gd (cost=0.0..4.68 rows=1 width=63) (actual time=69.920..69.930 rows=1 loops=1)
 Total runtime: 43663.62 msec