explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2Smt

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

Nested Loop (cost=0.70..5,351.74 rows=1 width=4) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.42..5,343.75 rows=1 width=10) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Seq Scan on pedidofaturado p (cost=0.00..4,890.69 rows=7 width=10) (actual rows= loops=)

  • Filter: (cli_coddelsoft = tbfi.fngetclientepagador(144767))
4. 0.000 0.000 ↓ 0.0

Index Scan using ix_tbfiitempedido on itempedido i (cost=0.42..64.71 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (ped_id = p.ped_id)
  • Filter: ((sta_id = 1) AND ((itm_mensalidade > '0'::double precision) OR (itm_locacao > '0'::double precision)))
5. 0.000 0.000 ↓ 0.0

Index Scan using cliente_coddelsoft_idx on cliente c (cost=0.28..7.98 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (cli_coddelsoft = p.cli_coddelsoft)
  • Filter: ((NOT tbrh.fnisraizen(pes_id)) OR (p.ctr_diavctoparcela <> 5))