explain.depesz.com

PostgreSQL's explain analyze made readable

Result: JzoD

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

Seq Scan on promotion_discountrule (cost=0.00..26.67 rows=1 width=605) (actual rows= loops=)

  • Filter: ((criteria ?| '{category}'::text[]) AND (((criteria #> '{category,op}'::text[]) <> '"EQ"'::jsonb) OR ((criteria #> '{category,value}'::text[]) = '"jeans"'::jsonb)))