explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Y4eW

Settings
# exclusive inclusive rows x rows loops node
1. 0.221 0.533 ↑ 10.5 6 1

Bitmap Heap Scan on cache.salepricearticlescache ca (cost=88.05..338.32 rows=63 width=72) (actual time=0.384..0.533 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))
  • Heap Blocks: exact=16
  • Buffers: shared hit=85
2. 0.312 0.312 ↑ 3.5 18 1

Bitmap Index Scan on salepricearticlescache_tagjb_path_value_amount (cost=0.00..88.04 rows=63 width=0) (actual time=0.312..0.312 rows=18 loops=1)

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