explain.depesz.com

PostgreSQL's explain analyze made readable

Result: a2TF

Settings
# exclusive inclusive rows x rows loops node
1. 0.005 12.418 ↓ 0.0 0 1

Sort (cost=10,740.03..10,740.08 rows=20 width=200) (actual time=12.418..12.418 rows=0 loops=1)

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

Hash Join (cost=375.68..10,739.59 rows=20 width=200) (actual time=12.413..12.413 rows=0 loops=1)

  • Hash Cond: (car.car_cd_administradora = adm.adm_cd_administradora)
3. 0.001 12.413 ↓ 0.0 0 1

Nested Loop Anti Join (cost=89.26..10,451.41 rows=378 width=159) (actual time=12.413..12.413 rows=0 loops=1)

  • Join Filter: (cartao_edi.cae_cd_cartao = car.car_cd_cartao)
4. 0.398 12.412 ↓ 0.0 0 1

Bitmap Heap Scan on cartao car (cost=88.83..10,443.09 rows=378 width=159) (actual time=12.412..12.412 rows=0 loops=1)

  • Recheck Cond: ((car_ds_autorizacao)::text ~~* '%310839%'::text)
  • Filter: (car_cd_unidade_negocio = 144)
  • Rows Removed by Filter: 19
  • Heap Blocks: exact=19
5. 12.014 12.014 ↑ 499.2 19 1

Bitmap Index Scan on cartao_gin_autorizacao (cost=0.00..88.74 rows=9,485 width=0) (actual time=12.014..12.014 rows=19 loops=1)

  • Index Cond: ((car_ds_autorizacao)::text ~~* '%310839%'::text)
6. 0.000 0.000 ↓ 0.0 0

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

7. 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)
8. 0.000 0.000 ↓ 0.0 0

Hash (cost=281.23..281.23 rows=415 width=20) (never executed)

9. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=6.91..281.23 rows=415 width=20) (never executed)

  • Hash Cond: (adm.adm_cd_administradora_edi = ade.ade_cd_administradora_edi)
10. 0.000 0.000 ↓ 0.0 0

Seq Scan on administradora adm (cost=0.00..254.02 rows=7,702 width=24) (never executed)

11. 0.000 0.000 ↓ 0.0 0

Hash (cost=6.71..6.71 rows=16 width=4) (never executed)

12. 0.000 0.000 ↓ 0.0 0

Seq Scan on administradora_edi ade (cost=0.00..6.71 rows=16 width=4) (never executed)

  • Filter: (ade_cd_gestora = 1)
Planning time : 7.311 ms
Execution time : 12.467 ms