explain.depesz.com

PostgreSQL's explain analyze made readable

Result: MA4C

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

Limit (cost=3,769,308.05..3,769,308.29 rows=1 width=5,685) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Unique (cost=3,769,308.05..3,769,308.29 rows=1 width=5,685) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Sort (cost=3,769,308.05..3,769,308.05 rows=1 width=5,685) (actual rows= loops=)

  • Sort Key: data_processamento DESC, id, version, chave_acesso, chave_unica, emitente_codigo_municipio, cstat_sefaz, data_hora_emissao, dt_hr_ult_cons_sefaz, data_hora_recebimento, digest_value, emitente_documento, emitente_ie, id_lote_erp, nom (...)
4. 0.000 0.000 ↓ 0.0

Seq Scan on nfce nfce0_ (cost=0.00..3,769,308.04 rows=1 width=5,685) (actual rows= loops=)

  • Filter: (((destinatario_documento)::text ~~ '07233087000196%'::text) AND (data_hora_recebimento >= '2020-07-05 00:00:00'::timestamp without time zone) AND (data_hora_recebimento <= '2020-07-07 23:59:59.999'::timestamp without time zone) (...)