explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hYLD

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=)

  • Output: src.customer_id, src.company_id, src.numregiao, src.codprod
  • Inner Unique: true
  • 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 ion_vendas.ionv_tabprecos dst (cost=0.00..1,335,863.32 rows=21,245,332 width=16) (actual rows= loops=)

  • Output: dst.customer_id, dst.company_id, dst.codprod, dst.numregiao
3. 0.000 0.000 ↓ 0.0

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

  • Output: src.customer_id, src.company_id, src.numregiao, src.codprod
4. 0.000 0.000 ↓ 0.0

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

  • Output: src.customer_id, src.company_id, src.numregiao, src.codprod