explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 04V

Settings
# exclusive inclusive rows x rows loops node
1. 0.082 0.625 ↑ 1.0 20 1

Limit (cost=8,558.43..8,558.48 rows=20 width=20) (actual time=0.510..0.625 rows=20 loops=1)

2. 0.117 0.543 ↑ 108.8 20 1

Sort (cost=8,558.43..8,563.87 rows=2,175 width=20) (actual time=0.505..0.543 rows=20 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: 26kB
3. 0.365 0.426 ↑ 90.6 24 1

Bitmap Heap Scan on search_name (cost=44.86..8,500.55 rows=2,175 width=20) (actual time=0.085..0.426 rows=24 loops=1)

  • Recheck Cond: (name_vector @> '{5639492}'::integer[])
  • Heap Blocks: exact=24
4. 0.061 0.061 ↑ 90.6 24 1

Bitmap Index Scan on idx_search_name_name_vector (cost=0.00..44.32 rows=2,175 width=0) (actual time=0.061..0.061 rows=24 loops=1)

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