explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 14d

Settings
# exclusive inclusive rows x rows loops node
1. 0.039 19.386 ↑ 1.1 35 1

Sort (cost=179.93..180.03 rows=40 width=10) (actual time=19.374..19.386 rows=35 loops=1)

  • Sort Key: (similarity((pc)::text, 'PMP000UN'::text))
  • Sort Method: quicksort Memory: 26kB
2. 0.185 19.347 ↑ 1.1 35 1

Bitmap Heap Scan on product_kv (cost=20.72..178.87 rows=40 width=10) (actual time=19.190..19.347 rows=35 loops=1)

  • Recheck Cond: ((pc)::text ~~* 'PMP000%'::text)
  • Heap Blocks: exact=3
3. 19.162 19.162 ↑ 1.1 35 1

Bitmap Index Scan on fts_product_kv_pc_idx (cost=0.00..20.71 rows=40 width=0) (actual time=19.162..19.162 rows=35 loops=1)

  • Index Cond: ((pc)::text ~~* 'PMP000%'::text)
Planning time : 0.316 ms
Execution time : 19.431 ms