explain.depesz.com

PostgreSQL's explain analyze made readable

Result: betb

Settings
# exclusive inclusive rows x rows loops node
1. 0.016 3.807 ↑ 1.0 100 1

Limit (cost=2,640.47..2,640.72 rows=100 width=88) (actual time=3.782..3.807 rows=100 loops=1)

2. 0.638 3.791 ↑ 9.4 100 1

Sort (cost=2,640.47..2,642.83 rows=944 width=88) (actual time=3.780..3.791 rows=100 loops=1)

  • Sort Key: popularity DESC
  • Sort Method: top-N heapsort Memory: 44kB
3. 1.779 3.153 ↓ 1.4 1,343 1

Bitmap Heap Scan on product p (cost=39.32..2,604.39 rows=944 width=88) (actual time=1.455..3.153 rows=1,343 loops=1)

  • Recheck Cond: (search_ids @> ''{1,100000294}''::integer[])
  • Heap Blocks: exact=295
4. 1.374 1.374 ↓ 1.5 1,372 1

Bitmap Index Scan on idx_d34a04adb461d327 (cost=0.00..39.08 rows=944 width=0) (actual time=1.374..1.374 rows=1,372 loops=1)

  • Index Cond: (search_ids @> ''{1,100000294}''::integer[])
Planning time : 0.259 ms
Execution time : 3.866 ms