explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9VVR

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

Nested Loop Anti Join (cost=1,672.54..2,023.29 rows=21 width=131) (actual time=2.815..2.815 rows=0 loops=1)

2. 0.006 2.815 ↓ 0.0 0 1

Hash Join (cost=1,672.12..1,967.09 rows=21 width=131) (actual time=2.814..2.815 rows=0 loops=1)

  • Hash Cond: (adm.adm_cd_administradora_edi = ade.ade_cd_administradora_edi)
3. 0.001 2.783 ↓ 0.0 0 1

Nested Loop (cost=1,670.32..1,965.00 rows=112 width=135) (actual time=2.783..2.783 rows=0 loops=1)

4. 0.043 2.782 ↓ 0.0 0 1

Bitmap Heap Scan on cartao car (cost=1,670.03..1,794.72 rows=112 width=131) (actual time=2.782..2.782 rows=0 loops=1)

  • Recheck Cond: (car_cd_unidade_negocio = 2175)
  • Filter: ((car_ds_autorizacao)::text ~~ '634563%'::text)
5. 0.512 2.739 ↓ 0.0 0 1

BitmapAnd (cost=1,670.03..1,670.03 rows=112 width=0) (actual time=2.739..2.739 rows=0 loops=1)

6. 2.208 2.208 ↑ 1.7 13,343 1

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

  • Index Cond: (car_cd_unidade_negocio = 2175)
7. 0.019 0.019 ↑ 2,278.2 48 1

Bitmap Index Scan on cartao_idx_autorizacao (cost=0.00..1,432.80 rows=109,356 width=0) (actual time=0.019..0.019 rows=48 loops=1)

  • Index Cond: (((car_ds_autorizacao)::text ~>=~ '634563'::text) AND ((car_ds_autorizacao)::text ~<~ '634564'::text))
8. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (adm_cd_administradora = car.car_cd_administradora)
9. 0.004 0.026 ↑ 1.0 10 1

Hash (cost=1.68..1.68 rows=10 width=4) (actual time=0.026..0.026 rows=10 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
10. 0.022 0.022 ↑ 1.0 10 1

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

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

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

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