explain.depesz.com

PostgreSQL's explain analyze made readable

Result: v2UY

Settings
# exclusive inclusive rows x rows loops node
1. 0.014 33,953.307 ↓ 0.0 0 1

Sort (cost=132,100.41..132,100.46 rows=20 width=200) (actual time=33,953.307..33,953.307 rows=0 loops=1)

  • Sort Key: car.car_dt_movimento DESC, car.car_dt_bom_para
  • Sort Method: quicksort Memory: 25kB
2. 0.000 33,953.293 ↓ 0.0 0 1

Nested Loop Anti Join (cost=7.91..132,099.98 rows=20 width=200) (actual time=33,953.293..33,953.293 rows=0 loops=1)

  • Join Filter: (cartao_edi.cae_cd_cartao = car.car_cd_cartao)
3. 1.140 33,953.293 ↓ 0.0 0 1

Nested Loop (cost=7.48..132,096.88 rows=20 width=175) (actual time=33,953.293..33,953.293 rows=0 loops=1)

4. 1.861 6.978 ↓ 2.2 901 1

Hash Join (cost=6.91..281.23 rows=415 width=20) (actual time=0.064..6.978 rows=901 loops=1)

  • Hash Cond: (adm.adm_cd_administradora_edi = ade.ade_cd_administradora_edi)
5. 5.071 5.071 ↑ 1.0 7,675 1

Seq Scan on administradora adm (cost=0.00..254.02 rows=7,702 width=24) (actual time=0.012..5.071 rows=7,675 loops=1)

6. 0.004 0.046 ↑ 1.0 16 1

Hash (cost=6.71..6.71 rows=16 width=4) (actual time=0.046..0.046 rows=16 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
7. 0.042 0.042 ↑ 1.0 16 1

Seq Scan on administradora_edi ade (cost=0.00..6.71 rows=16 width=4) (actual time=0.006..0.042 rows=16 loops=1)

  • Filter: (ade_cd_gestora = 1)
  • Rows Removed by Filter: 281
8. 33,945.175 33,945.175 ↓ 0.0 0 901

Index Scan using cartao_idx_administradora on cartao car (cost=0.56..317.62 rows=1 width=159) (actual time=37.675..37.675 rows=0 loops=901)

  • Index Cond: (car_cd_administradora = adm.adm_cd_administradora)
  • Filter: (((car_ds_autorizacao)::text ~~* '%310839%'::text) AND (car_cd_unidade_negocio = 144))
  • Rows Removed by Filter: 6,355
9. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.43..2.65 rows=1 width=4) (never executed)

10. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (cae_cd_unidade_negocio = 144)
Planning time : 10.383 ms
Execution time : 33,974.439 ms