explain.depesz.com

PostgreSQL's explain analyze made readable

Result: X5dO

Settings

Optimization(s) for this plan:

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

Hash Right Join (cost=410.02..428.26 rows=5 width=721) (actual rows= loops=)

  • Hash Cond: ((ckr.cikk_kiegeszito_id = ck.cikk_kiegeszito_id) AND (ckr.raktar_id = fun.raktar_id))
  • Filter: (ckr.torolve IS NULL)
2. 0.000 0.000 ↓ 0.0

Seq Scan on cikk_kiegeszito_raktar ckr (cost=0.00..14.70 rows=470 width=144) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Hash (cost=395.02..395.02 rows=1,000 width=577) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=371.27..395.02 rows=1,000 width=577) (actual rows= loops=)

  • Hash Cond: (fun.cikk_id = ck.cikk_id)
  • Filter: (ck.torolve IS NULL)
5. 0.000 0.000 ↓ 0.0

Function Scan on list_keszletek fun (cost=0.25..10.25 rows=1,000 width=389) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Hash (cost=221.01..221.01 rows=12,001 width=188) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Seq Scan on cikk_kiegeszito ck (cost=0.00..221.01 rows=12,001 width=188) (actual rows= loops=)