explain.depesz.com

PostgreSQL's explain analyze made readable

Result: gSaP

Settings
# exclusive inclusive rows x rows loops node
1. 0.195 9.089 ↑ 3.2 6 1

Bitmap Heap Scan on cache.salepricearticlescache ca (cost=932.02..1,007.34 rows=19 width=72) (actual time=8.965..9.089 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=6
  • Buffers: shared hit=437
2. 8.894 8.894 ↑ 3.2 6 1

Bitmap Index Scan on salepricearticlescache_tagjb_value_path (cost=0.00..932.01 rows=19 width=0) (actual time=8.893..8.894 rows=6 loops=1)

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