explain.depesz.com

PostgreSQL's explain analyze made readable

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

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.001 0.016 ↓ 0.0 0 1

Nested Loop (cost=1.00..17.19 rows=1 width=203) (actual time=0.016..0.016 rows=0 loops=1)

2. 0.015 0.015 ↓ 0.0 0 1

Index Scan using idx_nfe_ident_dhemi on nfe_ident ni (cost=0.44..8.50 rows=1 width=29) (actual time=0.015..0.015 rows=0 loops=1)

  • Index Cond: ((dhemi >= '2020-08-26 00:00:00-03'::timestamp with time zone) AND (dhemi <= '2020-08-26 00:00:00-03'::timestamp with time zone))
3. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_nfe on nfe n (cost=0.56..8.64 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.740 ms