explain.depesz.com

PostgreSQL's explain analyze made readable

Result: BAQQ

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

Limit (cost=10.19..10.20 rows=1 width=208) (actual time=0.032..0.033 rows=0 loops=1)

2. 0.006 0.032 ↓ 0.0 0 1

Sort (cost=10.19..10.20 rows=1 width=208) (actual time=0.031..0.032 rows=0 loops=1)

  • Sort Key: (abs((car.car_dt_bom_para - '2020-07-06'::date))), car.car_cd_parcelamento
  • Sort Method: quicksort Memory: 25kB
3. 0.000 0.026 ↓ 0.0 0 1

Nested Loop Anti Join (cost=1.27..10.18 rows=1 width=208) (actual time=0.026..0.026 rows=0 loops=1)

4. 0.001 0.026 ↓ 0.0 0 1

Nested Loop (cost=0.84..5.31 rows=1 width=179) (actual time=0.026..0.026 rows=0 loops=1)

5. 0.025 0.025 ↓ 0.0 0 1

Index Scan using cartao_idx_autorizacao on cartao car (cost=0.56..2.80 rows=1 width=163) (actual time=0.025..0.025 rows=0 loops=1)

  • Index Cond: ((car_cd_unidade_negocio = 332) AND ((car_ds_autorizacao)::text = '621942'::text) AND (car_cd_administradora = 7,870) AND (car_dt_movimento = '2020-06-05'::date))
  • Filter: ((car_vl_cartao >= 226.98::numeric(18,2)) AND (car_vl_cartao <= 227.02::numeric(18,2)) AND (car_cd_cartao <> ALL ('{-1,1,2,3}'::integer[])))
6. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (adm_cd_administradora = 7,870)
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 = 332)
Planning time : 0.937 ms
Execution time : 0.105 ms