explain.depesz.com

PostgreSQL's explain analyze made readable

Result: s6fc : Optimization for: plan #k5qr

Settings

Optimization path:

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

Aggregate (cost=9.99..10.00 rows=1 width=0) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Seq Scan on mesa (cost=7.58..9.96 rows=15 width=0) (actual rows= loops=)

  • Filter: (NOT (hashed SubPlan 1))
3. 0.000 0.000 ↓ 0.0

Seq Scan on venda (cost=0.00..7.58 rows=3 width=4) (actual rows= loops=)

  • Filter: ((sit_001 = ANY ('{8,21}'::integer[])) AND ((ven_024)::text = 'M'::text))