explain.depesz.com

PostgreSQL's explain analyze made readable

Result: pL0G

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 26.316 ↓ 0.0 0 1

Nested Loop Anti Join (cost=267.40..278.97 rows=1 width=95) (actual time=26.316..26.316 rows=0 loops=1)

2. 0.000 26.316 ↓ 0.0 0 1

Nested Loop (cost=266.98..274.11 rows=1 width=95) (actual time=26.316..26.316 rows=0 loops=1)

3. 0.001 26.316 ↓ 0.0 0 1

Nested Loop (cost=266.84..273.79 rows=2 width=99) (actual time=26.315..26.316 rows=0 loops=1)

4. 0.003 26.315 ↓ 0.0 0 1

Bitmap Heap Scan on cartao car (cost=266.55..268.78 rows=2 width=95) (actual time=26.315..26.315 rows=0 loops=1)

  • Recheck Cond: (((car_ds_autorizacao)::text ~~ '%634563%'::text) AND (car_cd_unidade_negocio = 2175))
5. 0.024 26.312 ↓ 0.0 0 1

BitmapAnd (cost=266.55..266.55 rows=2 width=0) (actual time=26.312..26.312 rows=0 loops=1)

6. 24.056 24.056 ↑ 8.1 230 1

Bitmap Index Scan on cartao_idx_autorizacao (cost=0.00..29.37 rows=1,863 width=0) (actual time=24.056..24.056 rows=230 loops=1)

  • Index Cond: ((car_ds_autorizacao)::text ~~ '%634563%'::text)
7. 2.232 2.232 ↑ 1.7 13,343 1

Bitmap Index Scan on cartao_idx (cost=0.00..236.93 rows=22,439 width=0) (actual time=2.232..2.232 rows=13,343 loops=1)

  • Index Cond: (car_cd_unidade_negocio = 2175)
8. 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)
9. 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)
10. 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 : 8.831 ms
Execution time : 26.406 ms