explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Ocgt

Settings
# exclusive inclusive rows x rows loops node
1. 174.564 222.200 ↓ 41.4 10,389 1

Bitmap Heap Scan on catalogue_simple_product (cost=9,605.99..65,431.00 rows=251 width=148) (actual time=48.801..222.200 rows=10,389 loops=1)

  • Recheck Cond: (category_id = 7)
  • Filter: (attributes @> '{"speed": 2400, "screen": 12.2}'::jsonb)
  • Rows Removed by Filter: 239611
  • Heap Blocks: exact=5139
  • Planning time: 0.149 ms
  • Execution time: 222.764 ms
2. 47.636 47.636 ↑ 1.0 250,000 1

Bitmap Index Scan on catalogue_simple_product_b583a629 (cost=0.00..9,605.93 rows=250,867 width=0) (actual time=47.636..47.636 rows=250,000 loops=1)

  • Index Cond: (category_id = 7)