explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1z6d

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 8.294 ↓ 0.0 0 1

Nested Loop Anti Join (cost=1.27..21,392.35 rows=1 width=131) (actual time=8.294..8.294 rows=0 loops=1)

2. 0.005 8.293 ↓ 0.0 0 1

Nested Loop (cost=0.85..21,387.49 rows=1 width=131) (actual time=8.293..8.293 rows=0 loops=1)

  • Join Filter: (adm.adm_cd_administradora_edi = ade.ade_cd_administradora_edi)
3. 0.018 0.018 ↑ 1.0 10 1

Seq Scan on administradora_edi ade (cost=0.00..1.68 rows=10 width=4) (actual time=0.014..0.018 rows=10 loops=1)

  • Filter: (ade_cd_gestora = 3)
  • Rows Removed by Filter: 44
4. 0.000 8.270 ↓ 0.0 0 10

Materialize (cost=0.85..21,384.78 rows=7 width=135) (actual time=0.827..0.827 rows=0 loops=10)

5. 0.001 8.271 ↓ 0.0 0 1

Nested Loop (cost=0.85..21,384.75 rows=7 width=135) (actual time=8.270..8.271 rows=0 loops=1)

6. 8.270 8.270 ↓ 0.0 0 1

Index Scan using cartao_idx_autorizacao_filial on cartao car (cost=0.56..21,367.23 rows=7 width=131) (actual time=8.270..8.270 rows=0 loops=1)

  • Index Cond: (car_cd_unidade_negocio = 2175)
  • Filter: ((car_ds_autorizacao)::text ~~ '%634563%'::text)
  • Rows Removed by Filter: 13343
7. 0.000 0.000 ↓ 0.0 0

Index Scan using administradora_pkey on administradora adm (cost=0.29..2.50 rows=1 width=8) (never executed)

  • Index Cond: (adm_cd_administradora = car.car_cd_administradora)
8. 0.000 0.000 ↓ 0.0 0

Index Scan using cartao_edi_idx_cartao_nao_vinculado on cartao_edi (cost=0.42..2.64 rows=1 width=4) (never executed)

  • Index Cond: (cae_cd_cartao = car.car_cd_cartao)
  • Filter: (cae_cd_unidade_negocio = 2175)
Planning time : 0.927 ms
Execution time : 8.353 ms