explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ymu6

Settings
# exclusive inclusive rows x rows loops node
1. 337.629 781.014 ↑ 4.0 6 1

Bitmap Heap Scan on cache.salepricearticlescache ca (cost=876.02..970.99 rows=24 width=72) (actual time=466.525..781.014 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=50030 read=4993 dirtied=43
2. 443.385 443.385 ↓ 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=443.385..443.385 rows=11,212 loops=1)

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