explain.depesz.com

PostgreSQL's explain analyze made readable

Result: FAMC

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

Bitmap Heap Scan on promotion_discountrule (cost=8.00..12.02 rows=1 width=605) (actual rows= loops=)

  • Recheck Cond: (criteria ?| '{category}'::text[])
  • Filter: (((criteria #> '{category,op}'::text[]) <> '"EQ"'::jsonb) OR ((criteria #> '{category,value}'::text[]) = '"jeans"'::jsonb))
2. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on promotion_d_criteri_220ad2_gin (cost=0.00..8.00 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (criteria ?| '{category}'::text[])