explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Kma8

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

Aggregate (cost=21,270.70..21,270.71 rows=1 width=0) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Nested Loop Semi Join (cost=0.00..21,270.55 rows=62 width=0) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Seq Scan on products (cost=0.00..19,996.96 rows=185 width=10) (actual rows= loops=)

  • Filter: ((supercode = ANY ('{0,2}'::integer[])) AND (visibility = ANY ('{2,4}'::integer[])) AND (status = 1) AND (1713 = ANY (category_ids)))
4. 0.000 0.000 ↓ 0.0

Index Scan using depot_virtual_pkey on depot_virtual (cost=0.00..6.88 rows=1 width=11) (actual rows= loops=)

  • Index Cond: ((id)::text = (products.kodikos)::text)
  • Filter: (stock_3 > 0)