explain.depesz.com

PostgreSQL's explain analyze made readable

Result: pIR7

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

Nested Loop (cost=0.99..1,189.69 rows=3 width=16) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Index Only Scan using ionvt_tabprecos_i0 on ionvt_tabprecos src (cost=0.43..462.71 rows=114 width=16) (actual rows= loops=)

  • Index Cond: ((customer_id = 282) AND (company_id = 290))
3. 0.000 0.000 ↓ 0.0

Index Only Scan using ionv_tabprecos_pkey on ionv_tabprecos dst (cost=0.56..6.38 rows=1 width=16) (actual rows= loops=)

  • Index Cond: ((customer_id = 282) AND (company_id = 290) AND (numregiao = src.numregiao) AND (codprod = src.codprod))