explain.depesz.com

A tool for finding a real cause for slow queries.

Result: L6g

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# exclusive inclusive rows x rows loops node
1. 15.670 116.247 ↑ 1.1 661 1

Nested Loop Left Join (cost=837.73..14,807.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..14,191.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..7,998.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..7,168.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..1,215.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..1,200.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 29,194 1

Hash (cost=449.94..449.94 rows=29,194 width=10) (actual time=14.459..14.459 rows=29,194 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 1198kB
11. 4.713 4.713 ↑ 1.0 29,194 1

Seq Scan on anot_cad (cost=0.00..449.94 rows=29,194 width=10) (actual time=0.004..4.713 rows=29,194 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)