explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ckma

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.023 ↑ 1.0 1 1

Aggregate (cost=51.42..51.43 rows=1 width=8) (actual time=0.023..0.023 rows=1 loops=1)

2. 0.000 0.022 ↓ 0.0 0 1

Nested Loop (cost=1.69..51.42 rows=1 width=8) (actual time=0.022..0.022 rows=0 loops=1)

3. 0.001 0.022 ↓ 0.0 0 1

Nested Loop (cost=1.12..48.61 rows=1 width=24) (actual time=0.022..0.022 rows=0 loops=1)

4. 0.021 0.021 ↓ 0.0 0 1

Index Scan using idx_nota_fiscal_service_date on nf_nota_fiscal_servico notafiscal0_ (cost=0.56..9.58 rows=14 width=40) (actual time=0.021..0.021 rows=0 loops=1)

  • Index Cond: ((id_empresa = 1565) AND (date_part('year'::text, data) = '2020'::double precision) AND (date_part('month'::text, data) = '1'::double precision))
5. 0.000 0.000 ↓ 0.0 0

Index Scan using ef_pessoa_pkey on ef_pessoa pessoa1_ (cost=0.57..2.79 rows=1 width=8) (never executed)

  • Index Cond: (id_pessoa = notafiscal0_.id_tomador)
  • Filter: (empresa_id_empresa = 1565)
6. 0.000 0.000 ↓ 0.0 0

Index Scan using negotiation_pkey on negotiation negotiatio4_ (cost=0.57..2.80 rows=1 width=17) (never executed)

  • Index Cond: (id = notafiscal0_.negotiation_id)
  • Filter: ((tenant_id = 1565) AND (((status)::text = 'COMMITED'::text) OR ((notafiscal0_.statusnotafiscal)::text = ANY ('{EMITIDA,CANCELADA,FALHA_CANCELAMENTO,AGUARDANDO_RETORNO,AGUARDANDO_CORRECAO,CORRIGIDA_SUCESSO,FALHA,DENEGADA,PENDENTE,CANCELAMENTO_MANUAL}'::text[]))))
Planning time : 1.188 ms
Execution time : 0.064 ms