explain.depesz.com

PostgreSQL's explain analyze made readable

Result: rqRE

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

HashAggregate (cost=25.40..25.41 rows=1 width=8) (actual time=0.011..0.011 rows=0 loops=1)

  • Group Key: fi.cod_farmacia, fi.cod_filial
2. 0.001 0.010 ↓ 0.0 0 1

Nested Loop Anti Join (cost=0.29..25.39 rows=1 width=8) (actual time=0.010..0.010 rows=0 loops=1)

3. 0.001 0.009 ↓ 0.0 0 1

Nested Loop (cost=0.14..9.19 rows=1 width=20) (actual time=0.009..0.009 rows=0 loops=1)

  • Join Filter: ((cv.cod_rede = fi.cod_rede) AND (cv.cod_filial = fi.cod_filial))
4. 0.008 0.008 ↓ 0.0 0 1

Index Scan using idx_cadcvend_cod_modelo on cadcvend cv (cost=0.14..8.16 rows=1 width=12) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((cod_modelo)::text = '59'::text)
  • Filter: ((COALESCE(flg_excluido, 'N'::bpchar) <> 'S'::bpchar) AND (flg_sitcaixa = '2'::bpchar))
5. 0.000 0.000 ↓ 0.0 0

Seq Scan on cadfilia fi (cost=0.00..1.01 rows=1 width=12) (never executed)

  • Filter: (upper((est_filial)::text) = 'CE'::text)
6. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pkcadcfexml00 on cadcfexml xml (cost=0.15..8.17 rows=1 width=12) (never executed)

  • Index Cond: ((cod_rede = cv.cod_rede) AND (cod_filial = cv.cod_filial) AND (num_nota = cv.num_nota))
  • Heap Fetches: 0