explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7VPV

Settings
# exclusive inclusive rows x rows loops node
1. 144.545 202.535 ↑ 4.0 6 1

Bitmap Heap Scan on cache.salepricearticlescache ca (cost=876.02..970.99 rows=24 width=72) (actual time=64.397..202.535 rows=6 loops=1)

  • Output: articlecode, articlename, COALESCE((((amountjb -> '5'::text) ->> 'a'::text))::integer, 0)
  • Recheck Cond: ((ca.tagjb @@ '("fts"."A" @> ["черный", "желтый", "ручка"] AND "dir".* && [4034, 4030])'::jsquery) AND (ca.level = 1) AND (ca.directoryid IS NOT NULL))
  • Rows Removed by Index Recheck: 9647
  • Heap Blocks: exact=8907
  • Buffers: shared hit=55023
2. 57.990 57.990 ↓ 467.2 11,212 1

Bitmap Index Scan on salepricearticlescache_tagjb_path_value_amount (cost=0.00..876.01 rows=24 width=0) (actual time=57.990..57.990 rows=11,212 loops=1)

  • Index Cond: (ca.tagjb @@ '("fts"."A" @> ["черный", "желтый", "ручка"] AND "dir".* && [4034, 4030])'::jsquery)
  • Buffers: shared hit=7557
Planning time : 0.654 ms
Execution time : 202.854 ms