#	exclusive	inclusive	rows x	rows	loops	node
1.	15.670	116.247	↑ 1.1	661	1	→ Nested Loop Left Join (cost=837.73..14807.43 rows=704 width=116) (actual time=15.057..116.247 rows=661 loops=1)
2.	0.849	93.306	↑ 1.1	661	1	→ Nested Loop Left Join (cost=837.73..14191.70 rows=704 width=116) (actual time=14.916..93.306 rows=661 loops=1)
3.	1.942	69.322	↑ 1.1	661	1	→ Hash Left Join (cost=837.73..7998.38 rows=704 width=104) (actual time=14.814..69.322 rows=661 loops=1) Hash Cond: ((pm.cd_mci)::text = (anot_cad.anot_mci)::text)
4.	1.418	52.921	↑ 1.1	661	1	→ Nested Loop Left Join (cost=22.87..7168.55 rows=704 width=94) (actual time=0.313..52.921 rows=661 loops=1)
5.	0.478	1.267	↑ 1.1	661	1	→ Nested Loop (cost=22.87..1215.66 rows=704 width=65) (actual time=0.261..1.267 rows=661 loops=1)
6.	0.022	0.022	↑ 1.0	1	1	→ Index Scan using tbldependenciasbr_pkey on tbldependenciasbr d (cost=0.00..8.28 rows=1 width=11) (actual time=0.021..0.022 rows=1 loops=1) Index Cond: ((prefdep)::text = '0018'::text)
7.	0.550	0.767	↑ 1.1	661	1	→ Bitmap Heap Scan on sem_prestacao_bb_mcis pm (cost=22.87..1200.34 rows=704 width=59) (actual time=0.232..0.767 rows=661 loops=1) Recheck Cond: ((pm.cd_prefdep)::text = '0018'::text) Filter: (pm.cd_restricao_rentabiliza IS NULL)
8.	0.217	0.217	↓ 1.1	905	1	→ Bitmap Index Scan on sem_prestacao_bb_mcis_cd_prefdep_cd_mci_idx (cost=0.00..22.69 rows=857 width=0) (actual time=0.217..0.217 rows=905 loops=1) Index Cond: ((pm.cd_prefdep)::text = '0018'::text)
9.	50.236	50.236	↑ 1.0	1	661	→ Index Scan using telefones_pkey on telefones (cost=0.00..8.44 rows=1 width=38) (actual time=0.076..0.076 rows=1 loops=661) Index Cond: ((telefones.t_mci)::text = (pm.cd_mci)::text)
10.	9.746	14.459	↑ 1.0	29194	1	→ Hash (cost=449.94..449.94 rows=29194 width=10) (actual time=14.459..14.459 rows=29194 loops=1) Buckets: 4096 Batches: 1 Memory Usage: 1198kB
11.	4.713	4.713	↑ 1.0	29194	1	→ Seq Scan on anot_cad (cost=0.00..449.94 rows=29194 width=10) (actual time=0.004..4.713 rows=29194 loops=1)
12.	23.135	23.135	↑ 1.0	1	661	→ Index Scan using base_nova_pkey on base_atual base (cost=0.00..8.78 rows=1 width=12) (actual time=0.034..0.035 rows=1 loops=661) Index Cond: ((base.r_mci)::text = (pm.cd_mci)::text)
13.	7.271	7.271	↓ 0.0	0	661	→ Index Scan using anotacao_cdc_pkey on anotacao_cdc anot_cdc (cost=0.00..0.28 rows=1 width=10) (actual time=0.011..0.011 rows=0 loops=661) Index Cond: ((base.r_mci)::text = (anot_cdc.anot_mci)::text)

Nested Loop Left Join  (cost=837.73..14807.43 rows=704 width=116) (actual time=15.057..116.247 rows=661 loops=1)
  ->  Nested Loop Left Join  (cost=837.73..14191.70 rows=704 width=116) (actual time=14.916..93.306 rows=661 loops=1)
        ->  Hash Left Join  (cost=837.73..7998.38 rows=704 width=104) (actual time=14.814..69.322 rows=661 loops=1)
              Hash Cond: ((pm.cd_mci)::text = (anot_cad.anot_mci)::text)
              ->  Nested Loop Left Join  (cost=22.87..7168.55 rows=704 width=94) (actual time=0.313..52.921 rows=661 loops=1)
                    ->  Nested Loop  (cost=22.87..1215.66 rows=704 width=65) (actual time=0.261..1.267 rows=661 loops=1)
                          ->  Index Scan using tbldependenciasbr_pkey on tbldependenciasbr d  (cost=0.00..8.28 rows=1 width=11) (actual time=0.021..0.022 rows=1 loops=1)
                                Index Cond: ((prefdep)::text = '0018'::text)
                          ->  Bitmap Heap Scan on sem_prestacao_bb_mcis pm  (cost=22.87..1200.34 rows=704 width=59) (actual time=0.232..0.767 rows=661 loops=1)
                                Recheck Cond: ((pm.cd_prefdep)::text = '0018'::text)
                                Filter: (pm.cd_restricao_rentabiliza IS NULL)
                                ->  Bitmap Index Scan on sem_prestacao_bb_mcis_cd_prefdep_cd_mci_idx  (cost=0.00..22.69 rows=857 width=0) (actual time=0.217..0.217 rows=905 loops=1)
                                      Index Cond: ((pm.cd_prefdep)::text = '0018'::text)
                    ->  Index Scan using telefones_pkey on telefones  (cost=0.00..8.44 rows=1 width=38) (actual time=0.076..0.076 rows=1 loops=661)
                          Index Cond: ((telefones.t_mci)::text = (pm.cd_mci)::text)
              ->  Hash  (cost=449.94..449.94 rows=29194 width=10) (actual time=14.459..14.459 rows=29194 loops=1)
                    Buckets: 4096  Batches: 1  Memory Usage: 1198kB
                    ->  Seq Scan on anot_cad  (cost=0.00..449.94 rows=29194 width=10) (actual time=0.004..4.713 rows=29194 loops=1)
        ->  Index Scan using base_nova_pkey on base_atual base  (cost=0.00..8.78 rows=1 width=12) (actual time=0.034..0.035 rows=1 loops=661)
              Index Cond: ((base.r_mci)::text = (pm.cd_mci)::text)
  ->  Index Scan using anotacao_cdc_pkey on anotacao_cdc anot_cdc  (cost=0.00..0.28 rows=1 width=10) (actual time=0.011..0.011 rows=0 loops=661)
        Index Cond: ((base.r_mci)::text = (anot_cdc.anot_mci)::text)
Total runtime: 116.711 ms

Per node type stats

node type	count	sum of times	% of query
Bitmap Heap Scan	1	0.550 ms	0.5 %
Bitmap Index Scan	1	0.217 ms	0.2 %
Hash	1	9.746 ms	8.4 %
Hash Left Join	1	1.942 ms	1.7 %
Index Scan	4	80.664 ms	69.4 %
Nested Loop	1	0.478 ms	0.4 %
Nested Loop Left Join	3	17.937 ms	15.4 %
Seq Scan	1	4.713 ms	4.1 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
anot_cad	1	4.713 ms	4.1 %
Seq Scan	1	4.713 ms	100.0 %
anotacao_cdc	1	7.271 ms	6.3 %
Index Scan	1	7.271 ms	100.0 %
base_atual	1	23.135 ms	19.9 %
Index Scan	1	23.135 ms	100.0 %
sem_prestacao_bb_mcis	1	0.550 ms	0.5 %
Bitmap Heap Scan	1	0.550 ms	100.0 %
tbldependenciasbr	1	0.022 ms	0.0 %
Index Scan	1	0.022 ms	100.0 %
telefones	1	50.236 ms	43.2 %
Index Scan	1	50.236 ms	100.0 %

explain.depesz.com

A tool for finding a real cause for slow queries.

Result: L6g

Colorize:

Columns visibility:

Per node type stats

Per table stats