explain.depesz.com

PostgreSQL's explain analyze made readable

Result: oZz4

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

Nested Loop Anti Join (cost=1.29..12.85 rows=1 width=95) (actual time=0.090..0.090 rows=0 loops=1)

2. 0.000 0.089 ↓ 0.0 0 1

Nested Loop (cost=0.86..7.99 rows=1 width=95) (actual time=0.089..0.089 rows=0 loops=1)

3. 0.000 0.089 ↓ 0.0 0 1

Nested Loop (cost=0.72..7.67 rows=2 width=99) (actual time=0.089..0.089 rows=0 loops=1)

4. 0.089 0.089 ↓ 0.0 0 1

Index Scan using cartao_idx_autorizacao on cartao car (cost=0.44..2.66 rows=2 width=95) (actual time=0.089..0.089 rows=0 loops=1)

  • Index Cond: (((car_ds_autorizacao)::text ~>=~ '634563'::text) AND ((car_ds_autorizacao)::text ~<~ '634564'::text))
  • Filter: (((car_ds_autorizacao)::text ~~ '634563%'::text) AND (car_cd_unidade_negocio = 2175))
  • Rows Removed by Filter: 48
5. 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)
6. 0.000 0.000 ↓ 0.0 0

Index Scan using administradora_edi_pkey on administradora_edi ade (cost=0.14..0.16 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_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 : 1.005 ms
Execution time : 0.148 ms