explain.depesz.com

A tool for finding a real cause for slow queries.

Result: mmW

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# exclusive inclusive rows x rows loops node
1. 451.780 594.441 ↓ 2.0 4,487 1

Nested Loop Left Join (cost=71.22..17,234.16 rows=2,254 width=117) (actual time=1.653..594.441 rows=4,487 loops=1)

2. 7.580 75.356 ↓ 2.0 4,487 1

Nested Loop Left Join (cost=71.22..1,040.88 rows=2,254 width=113) (actual time=1.339..75.356 rows=4,487 loops=1)

3. 5.734 18.419 ↓ 2.0 4,487 1

Hash Left Join (cost=71.22..388.09 rows=2,254 width=103) (actual time=1.325..18.419 rows=4,487 loops=1)

  • Hash Cond: ((b.r_mci)::text = (anc.r_mci)::text)
4. 1.974 11.439 ↓ 2.0 4,487 1

Nested Loop Left Join (cost=0.00..305.58 rows=2,254 width=93) (actual time=0.066..11.439 rows=4,487 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 4,487 1

Index Scan using base_atual_r_prefixo_idx on base_atual b (cost=0.00..269.13 rows=2,254 width=88) (actual time=0.042..9.444 rows=4,487 loops=1)

  • Index Cond: ((b.r_prefixo)::bpchar = (d.prefdep)::bpchar)
7. 0.839 1.246 ↑ 1.0 2,543 1

Hash (cost=39.43..39.43 rows=2,543 width=10) (actual time=1.246..1.246 rows=2,543 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 105kB
8. 0.407 0.407 ↑ 1.0 2,543 1

Seq Scan on mci_anc_massificado anc (cost=0.00..39.43 rows=2,543 width=10) (actual time=0.003..0.407 rows=2,543 loops=1)

9. 49.357 49.357 ↓ 0.0 0 4,487

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=4,487)

  • Index Cond: ((b.r_mci)::text = (anotacao.anot_mci)::text)
10. 67.305 67.305 ↓ 0.0 0 4,487

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=4,487)

  • Index Cond: ((contatos.cr_mci)::text = (b.r_mci)::text)
  • Filter: (contatos.cr_data_contato >= '2012-02-11'::date)