explain.depesz.com

PostgreSQL's explain analyze made readable

Result: E1Bu

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.002 38,917.754 ↓ 0.0 0 1

Nested Loop (cost=0.56..1,975,943.24 rows=67,322 width=203) (actual time=38,917.754..38,917.754 rows=0 loops=1)

2. 38,917.752 38,917.752 ↓ 0.0 0 1

Seq Scan on nfe_ident ni (cost=0.00..1,256,862.30 rows=100,062 width=29) (actual time=38,917.752..38,917.752 rows=0 loops=1)

  • Filter: ((to_char(dhemi, 'YYYY-MM-DD'::text) >= '2020-08-26'::text) AND (to_char(dhemi, 'YYYY-MM-DD'::text) <= '2020-08-26'::text))
  • Rows Removed by Filter: 20,012,499
3. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_nfe on nfe n (cost=0.56..7.14 rows=1 width=203) (never executed)

  • Index Cond: (((cnpj_emitente)::text = (ni.cnpj_emitente)::text) AND (numero = ni.numero) AND (serie = ni.serie) AND (tpamb = ni.tpamb) AND ((mod)::text = (ni.mod)::text))
Planning time : 2.362 ms