explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8Zx5

Settings
# exclusive inclusive rows x rows loops node
1. 191.444 240.234 ↓ 14.9 3,737 1

Bitmap Heap Scan on catalogue_simple_product (cost=9,556.49..65,362.49 rows=250 width=148) (actual time=50.272..240.234 rows=3,737 loops=1)

  • Recheck Cond: (category_id = 5)
  • Filter: (attributes @> '{"model": "poet", "sizes": ["M", "L"], "colors": ["white", "yellow"]}'::jsonb)
  • Rows Removed by Filter: 246263
  • Heap Blocks: exact=5962
  • Planning time: 0.147 ms
  • Execution time: 240.499 ms
2. 48.790 48.790 ↓ 1.0 250,000 1

Bitmap Index Scan on catalogue_simple_product_b583a629 (cost=0.00..9,556.42 rows=249,600 width=0) (actual time=48.790..48.790 rows=250,000 loops=1)

  • Index Cond: (category_id = 5)