explain.depesz.com

PostgreSQL's explain analyze made readable

Result: E9vL

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.027 ↑ 20.0 1 1

Limit (cost=35,497.72..35,497.77 rows=20 width=20) (actual time=0.026..0.027 rows=1 loops=1)

2. 0.007 0.026 ↑ 9,037.0 1 1

Sort (cost=35,497.72..35,520.31 rows=9,037 width=20) (actual time=0.025..0.026 rows=1 loops=1)

  • Sort Key: (CASE WHEN ((importance = '0'::double precision) OR (importance IS NULL)) THEN ('0.75001'::double precision - ((search_rank)::double precision / '40'::double precision)) ELSE importance END) DESC
  • Sort Method: quicksort Memory: 25kB
3. 0.006 0.019 ↑ 9,037.0 1 1

Bitmap Heap Scan on search_name (cost=114.04..35,257.25 rows=9,037 width=20) (actual time=0.019..0.019 rows=1 loops=1)

  • Recheck Cond: (name_vector @> '{5639492}'::integer[])
  • Heap Blocks: exact=1
4. 0.013 0.013 ↑ 9,037.0 1 1

Bitmap Index Scan on idx_search_name_name_vector (cost=0.00..111.78 rows=9,037 width=0) (actual time=0.013..0.013 rows=1 loops=1)

  • Index Cond: (name_vector @> '{5639492}'::integer[])