explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dzjs

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

Nested Loop Anti Join (cost=1.15..30,367.81 rows=21 width=131) (actual time=78.810..78.810 rows=0 loops=1)

2. 0.000 78.810 ↓ 0.0 0 1

Nested Loop (cost=0.72..30,311.61 rows=21 width=131) (actual time=78.810..78.810 rows=0 loops=1)

  • Join Filter: (adm.adm_cd_administradora_edi = ade.ade_cd_administradora_edi)
3. 0.001 78.810 ↓ 0.0 0 1

Nested Loop (cost=0.72..30,293.11 rows=112 width=135) (actual time=78.809..78.810 rows=0 loops=1)

4. 78.809 78.809 ↓ 0.0 0 1

Index Scan using cartao_idx on cartao car (cost=0.44..30,122.83 rows=112 width=131) (actual time=78.809..78.809 rows=0 loops=1)

  • Index Cond: (car_cd_unidade_negocio = 2175)
  • Filter: (to_tsvector((car_ds_autorizacao)::text) @@ to_tsquery('634563'::text))
  • Rows Removed by Filter: 13343
5. 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)
6. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..1.73 rows=10 width=4) (never executed)

7. 0.000 0.000 ↓ 0.0 0

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

  • Filter: (ade_cd_gestora = 3)
8. 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.152 ms
Execution time : 78.883 ms