explain.depesz.com

PostgreSQL's explain analyze made readable

Result: LX3

Settings
# exclusive inclusive rows x rows loops node
1. 0.011 1.020 ↑ 1.0 1 1

Nested Loop (cost=0.27..43.43 rows=1 width=1,673) (actual time=1.010..1.020 rows=1 loops=1)

2. 0.976 0.976 ↑ 1.0 1 1

Seq Scan on promotion_criterion (cost=0.00..35.03 rows=1 width=4) (actual time=0.969..0.976 rows=1 loops=1)

  • Filter: ((((key)::text = 'market'::text) AND (operator = 1) AND (value = '"SE"'::jsonb)) OR (((key)::text = 'market'::text) AND (operator = 7) AND (value @> '["SE"]'::jsonb)) OR (((key)::text = 'market'::text) AND (operator = 2) AND (value <> '"SE"'::jsonb)) OR (((key)::text = 'store'::text) AND (operator = 1) AND (value = '"10010"'::jsonb)) OR (((key)::text = 'store'::text) AND (operator = 7) AND (value @> '["10010"]'::jsonb)) OR (((key)::text = 'store'::text) AND (operator = 2) AND (value <> '"10010"'::jsonb)) OR (((key)::text = 'cart_total'::text) AND (operator = 1) AND (value = '123.0'::jsonb)) OR (((key)::text = 'cart_total'::text) AND (operator = 7) AND (value @> '[123.0]'::jsonb)) OR (((key)::text = 'cart_total'::text) AND (operator = 2) AND (value <> '123.0'::jsonb)) OR (((key)::text = 'sku'::text) AND (operator = 1) AND (value = '"AAA"'::jsonb)) OR (((key)::text = 'sku'::text) AND (operator = 7) AND (value @> '["AAA"]'::jsonb)) OR (((key)::text = 'sku'::text) AND (operator = 2) AND (value <> '"AAA"'::jsonb)) OR (((key)::text = 'product'::text) AND (operator = 1) AND (value = '"AA"'::jsonb)) OR (((key)::text = 'product'::text) AND (operator = 7) AND (value @> '["AA"]'::jsonb)) OR (((key)::text = 'product'::text) AND (operator = 2) AND (value <> '"AA"'::jsonb)) OR (((key)::text = 'style'::text) AND (operator = 1) AND (value = '"A"'::jsonb)) OR (((key)::text = 'style'::text) AND (operator = 7) AND (value @> '["A"]'::jsonb)) OR (((key)::text = 'style'::text) AND (operator = 2) AND (value <> '"A"'::jsonb)) OR (((key)::text = 'item_type'::text) AND (operator = 1) AND (value = '1'::jsonb)) OR (((key)::text = 'item_type'::text) AND (operator = 7) AND (value @> '[1]'::jsonb)) OR (((key)::text = 'item_type'::text) AND (operator = 2) AND (value <> '1'::jsonb)) OR (((key)::text = 'category'::text) AND (operator = 1) AND (value = ANY ('{"\"high-waist\"","\"clothing\"","\"jeans\""}'::jsonb[]))) OR (((key)::text = 'category'::text) AND (operator = 7) AND (value @> '["high-waist", "clothing", "jeans"]'::jsonb)) OR (((key)::text = 'category'::text) AND (operator = 2) AND (value <> ALL ('{"\"high-waist\"","\"clothing\"","\"jeans\""}'::jsonb[]))))
  • Rows Removed by Filter: 1003
3. 0.033 0.033 ↑ 1.0 1 1

Index Scan using promotion_pricerule_pkey on promotion_pricerule (cost=0.27..8.29 rows=1 width=1,673) (actual time=0.032..0.033 rows=1 loops=1)

  • Index Cond: (id = promotion_criterion.price_rule_id)
Planning time : 0.499 ms
Execution time : 1.173 ms