explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6kjk : Optimization for: Optimization for: Optimization for: plan #E1Bu; plan #TfBD; plan #Jqc1

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.003 43,539.922 ↓ 0.0 0 1

Nested Loop (cost=0.56..2,076,005.74 rows=67,322 width=203) (actual time=43,539.922..43,539.922 rows=0 loops=1)

2. 43,539.919 43,539.919 ↓ 0.0 0 1

Seq Scan on nfe_ident ni (cost=0.00..1,356,924.80 rows=100,062 width=29) (actual time=43,539.919..43,539.919 rows=0 loops=1)

  • Filter: ((to_date(to_char(dhemi, 'YYYY-MM-DD'::text), 'YYYY-MM-DD'::text) >= '2020-08-26'::date) AND (to_date(to_char(dhemi, 'YYYY-MM-DD'::text), 'YYYY-MM-DD'::text) <= '2020-08-26'::date))
  • 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.122 ms