explain.depesz.com

PostgreSQL's explain analyze made readable

Result: odr

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

Hash Join (cost=456,184.92..2,474,674.23 rows=57 width=16) (actual rows= loops=)

  • Hash Cond: ((dst.customer_id = src.customer_id) AND (dst.company_id = src.company_id) AND (dst.codprod = src.codprod) AND (dst.numregiao = src.numregiao))
2. 0.000 0.000 ↓ 0.0

Seq Scan on ionv_tabprecos dst (cost=0.00..1,335,863.32 rows=21,245,332 width=16) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Hash (cost=320,239.64..320,239.64 rows=4,567,164 width=16) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Seq Scan on ionvt_tabprecos src (cost=0.00..320,239.64 rows=4,567,164 width=16) (actual rows= loops=)