explain.depesz.com

PostgreSQL's explain analyze made readable

Result: aApH

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 1,076.267 1,076.267 ↓ 0.0 0 1

Sort (cost=191,226.57..191,226.57 rows=3 width=1,521) (actual time=1,076.267..1,076.267 rows=0 loops=1)

  • Sort Key: (CASE WHEN (cfpa.id_tipo = 5) THEN (cfd.dt_lancamento)::date ELSE cf.dt_emissao END), cf.nr_carta_frete, (CASE cfpa.id_tipo WHEN 0 THEN 'Adiantamento'::text WHEN 1 THEN 'Saldo'::text WHEN 2 THEN 'V. Comb.'::text WHEN 3 THEN 'Diária Viagem'::text WHEN 4 THEN 'Estadia Carregado'::text WHEN 5 THEN 'Diária Motorista'::text ELSE NULL::text END), cfp.dt_recebimento, (COALESCE((cfpa.nr_parcela)::integer, (cfp.nr_parcela)::integer, 1))
  • Sort Method: quicksort Memory: 25kB