explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vl6a

Settings
# exclusive inclusive rows x rows loops node
1. 0.083 0.397 ↑ 1.0 20 1

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

2. 0.147 0.314 ↑ 108.8 20 1

Sort (cost=8,558.43..8,563.87 rows=2,175 width=20) (actual time=0.275..0.314 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.128 0.167 ↑ 90.6 24 1

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

  • Recheck Cond: (name_vector @> '{5639492}'::integer[])
  • Heap Blocks: exact=24
4. 0.039 0.039 ↑ 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.039..0.039 rows=24 loops=1)

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