explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Jgh0

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

Nested Loop Anti Join (cost=1.14..7.80 rows=1 width=131) (actual time=0.010..0.010 rows=0 loops=1)

  • Join Filter: (cartao_edi.cae_cd_cartao = car.car_cd_cartao)
2. 0.000 0.009 ↓ 0.0 0 1

Nested Loop (cost=0.71..5.23 rows=1 width=131) (actual time=0.009..0.009 rows=0 loops=1)

3. 0.000 0.009 ↓ 0.0 0 1

Nested Loop (cost=0.57..5.03 rows=1 width=135) (actual time=0.009..0.009 rows=0 loops=1)

4. 0.009 0.009 ↓ 0.0 0 1

Index Scan using cartao_idx_unidade_negocio on cartao car (cost=0.43..2.65 rows=1 width=131) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: (car_cd_unidade_negocio = 2175)
  • Filter: ((car_ds_autorizacao)::text ~~ '%634563%'::text)
5. 0.000 0.000 ↓ 0.0 0

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

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

Index Scan using administradora_edi_pkey on administradora_edi ade (cost=0.14..0.17 rows=1 width=4) (never executed)

  • Index Cond: (ade_cd_administradora_edi = adm.adm_cd_administradora_edi)
  • Filter: (ade_cd_gestora = 3)
7. 0.000 0.000 ↓ 0.0 0

Index Scan using cartao_edi_idx_cd_unidade_negocio on cartao_edi (cost=0.43..2.56 rows=1 width=4) (never executed)

  • Index Cond: (cae_cd_unidade_negocio = 2175)
  • Filter: (cae_cd_cartao IS NOT NULL)
Planning time : 0.983 ms
Execution time : 0.071 ms