#	exclusive	inclusive	rows x	rows	loops	node
1.	451.780	594.441	↓ 2.0	4487	1	→ Nested Loop Left Join (cost=71.22..17234.16 rows=2254 width=117) (actual time=1.653..594.441 rows=4487 loops=1)
2.	7.580	75.356	↓ 2.0	4487	1	→ Nested Loop Left Join (cost=71.22..1040.88 rows=2254 width=113) (actual time=1.339..75.356 rows=4487 loops=1)
3.	5.734	18.419	↓ 2.0	4487	1	→ Hash Left Join (cost=71.22..388.09 rows=2254 width=103) (actual time=1.325..18.419 rows=4487 loops=1) Hash Cond: ((b.r_mci)::text = (anc.r_mci)::text)
4.	1.974	11.439	↓ 2.0	4487	1	→ Nested Loop Left Join (cost=0.00..305.58 rows=2254 width=93) (actual time=0.066..11.439 rows=4487 loops=1)
5.	0.021	0.021	↑ 1.0	1	1	→ Index Scan using tbldependenciasbr_pkey on tbldependenciasbr d (cost=0.00..8.28 rows=1 width=10) (actual time=0.020..0.021 rows=1 loops=1) Index Cond: ((prefdep)::text = '0004'::text)
6.	9.444	9.444	↓ 2.0	4487	1	→ Index Scan using base_atual_r_prefixo_idx on base_atual b (cost=0.00..269.13 rows=2254 width=88) (actual time=0.042..9.444 rows=4487 loops=1) Index Cond: ((b.r_prefixo)::bpchar = (d.prefdep)::bpchar)
7.	0.839	1.246	↑ 1.0	2543	1	→ Hash (cost=39.43..39.43 rows=2543 width=10) (actual time=1.246..1.246 rows=2543 loops=1) Buckets: 1024 Batches: 1 Memory Usage: 105kB
8.	0.407	0.407	↑ 1.0	2543	1	→ Seq Scan on mci_anc_massificado anc (cost=0.00..39.43 rows=2543 width=10) (actual time=0.003..0.407 rows=2543 loops=1)
9.	49.357	49.357	↓ 0.0	0	4487	→ Index Scan using anotacao_cdc_pkey on anotacao_cdc anotacao (cost=0.00..0.28 rows=1 width=10) (actual time=0.011..0.011 rows=0 loops=4487) Index Cond: ((b.r_mci)::text = (anotacao.anot_mci)::text)
10.	67.305	67.305	↓ 0.0	0	4487	→ Index Scan using contatos_realizados_ultimo_pkey on contatos_realizados_ultimo contatos (cost=0.00..3.85 rows=1 width=14) (actual time=0.015..0.015 rows=0 loops=4487) Index Cond: ((contatos.cr_mci)::text = (b.r_mci)::text) Filter: (contatos.cr_data_contato >= '2012-02-11'::date)

Nested Loop Left Join  (cost=71.22..17234.16 rows=2254 width=117) (actual time=1.653..594.441 rows=4487 loops=1)
  ->  Nested Loop Left Join  (cost=71.22..1040.88 rows=2254 width=113) (actual time=1.339..75.356 rows=4487 loops=1)
        ->  Hash Left Join  (cost=71.22..388.09 rows=2254 width=103) (actual time=1.325..18.419 rows=4487 loops=1)
              Hash Cond: ((b.r_mci)::text = (anc.r_mci)::text)
              ->  Nested Loop Left Join  (cost=0.00..305.58 rows=2254 width=93) (actual time=0.066..11.439 rows=4487 loops=1)
                    ->  Index Scan using tbldependenciasbr_pkey on tbldependenciasbr d  (cost=0.00..8.28 rows=1 width=10) (actual time=0.020..0.021 rows=1 loops=1)
                          Index Cond: ((prefdep)::text = '0004'::text)
                    ->  Index Scan using base_atual_r_prefixo_idx on base_atual b  (cost=0.00..269.13 rows=2254 width=88) (actual time=0.042..9.444 rows=4487 loops=1)
                          Index Cond: ((b.r_prefixo)::bpchar = (d.prefdep)::bpchar)
              ->  Hash  (cost=39.43..39.43 rows=2543 width=10) (actual time=1.246..1.246 rows=2543 loops=1)
                    Buckets: 1024  Batches: 1  Memory Usage: 105kB
                    ->  Seq Scan on mci_anc_massificado anc  (cost=0.00..39.43 rows=2543 width=10) (actual time=0.003..0.407 rows=2543 loops=1)
        ->  Index Scan using anotacao_cdc_pkey on anotacao_cdc anotacao  (cost=0.00..0.28 rows=1 width=10) (actual time=0.011..0.011 rows=0 loops=4487)
              Index Cond: ((b.r_mci)::text = (anotacao.anot_mci)::text)
  ->  Index Scan using contatos_realizados_ultimo_pkey on contatos_realizados_ultimo contatos  (cost=0.00..3.85 rows=1 width=14) (actual time=0.015..0.015 rows=0 loops=4487)
        Index Cond: ((contatos.cr_mci)::text = (b.r_mci)::text)
        Filter: (contatos.cr_data_contato >= '2012-02-11'::date)
Total runtime: 595.965 ms

Per node type stats

node type	count	sum of times	% of query
Hash	1	0.839 ms	0.1 %
Hash Left Join	1	5.734 ms	1.0 %
Index Scan	4	126.127 ms	21.2 %
Nested Loop Left Join	3	461.334 ms	77.6 %
Seq Scan	1	0.407 ms	0.1 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
anotacao_cdc	1	49.357 ms	8.3 %
Index Scan	1	49.357 ms	100.0 %
base_atual	1	9.444 ms	1.6 %
Index Scan	1	9.444 ms	100.0 %
contatos_realizados_ultimo	1	67.305 ms	11.3 %
Index Scan	1	67.305 ms	100.0 %
mci_anc_massificado	1	0.407 ms	0.1 %
Seq Scan	1	0.407 ms	100.0 %
tbldependenciasbr	1	0.021 ms	0.0 %
Index Scan	1	0.021 ms	100.0 %

explain.depesz.com

A tool for finding a real cause for slow queries.

Result: mmW

Colorize:

Columns visibility:

Per node type stats

Per table stats