explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bjq6

Settings
# exclusive inclusive rows x rows loops node
1. 0.007 17.183 ↓ 0.0 0 1

Sort (cost=3,897.61..3,897.64 rows=14 width=200) (actual time=17.183..17.183 rows=0 loops=1)

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

Nested Loop Anti Join (cost=3,060.63..3,897.34 rows=14 width=200) (actual time=17.176..17.176 rows=0 loops=1)

3. 0.005 17.175 ↓ 0.0 0 1

Nested Loop (cost=3,060.20..3,858.02 rows=14 width=175) (actual time=17.175..17.175 rows=0 loops=1)

4. 0.018 0.018 ↑ 1.0 1 1

Index Scan using administradora_pkey on administradora adm (cost=0.28..2.50 rows=1 width=20) (actual time=0.015..0.018 rows=1 loops=1)

  • Index Cond: (adm_cd_administradora = 5,057)
5. 0.129 17.152 ↓ 0.0 0 1

Bitmap Heap Scan on cartao car (cost=3,059.92..3,855.38 rows=14 width=159) (actual time=17.152..17.152 rows=0 loops=1)

  • Recheck Cond: ((car_cd_administradora = 5,057) AND ((car_ds_nsu)::text = '000011417189'::text))
  • Filter: ((car_cd_unidade_negocio = 332) AND (car_cd_cartao <> ALL ('{-1,1,2,3}'::integer[])))
6. 1.344 17.023 ↓ 0.0 0 1

BitmapAnd (cost=3,059.92..3,059.92 rows=711 width=0) (actual time=17.023..17.023 rows=0 loops=1)

7. 15.659 15.659 ↑ 1.0 135,653 1

Bitmap Index Scan on cartao_idx_administradora (cost=0.00..1,498.80 rows=142,272 width=0) (actual time=15.659..15.659 rows=135,653 loops=1)

  • Index Cond: (car_cd_administradora = 5,057)
8. 0.020 0.020 ↓ 0.0 0 1

Bitmap Index Scan on cartao_nsu (cost=0.00..1,560.86 rows=148,200 width=0) (actual time=0.020..0.020 rows=0 loops=1)

  • Index Cond: ((car_ds_nsu)::text = '000011417189'::text)
9. 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.885 ms
Execution time : 17.272 ms