explain.depesz.com

PostgreSQL's explain analyze made readable

Result: H3UU

Settings
# exclusive inclusive rows x rows loops node
1. 0.011 0.952 ↑ 1.0 1 1

Aggregate (cost=40.03..40.04 rows=1 width=8) (actual time=0.952..0.952 rows=1 loops=1)

2. 0.176 0.941 ↓ 60.0 60 1

Bitmap Heap Scan on users (cost=36.01..40.03 rows=1 width=0) (actual time=0.786..0.941 rows=60 loops=1)

  • Recheck Cond: ((first_name ~~ '%aeb%'::text) AND (last_name ~~ '%aeb%'::text))
  • Heap Blocks: exact=60
3. 0.765 0.765 ↓ 60.0 60 1

Bitmap Index Scan on users_search_idx (cost=0.00..36.01 rows=1 width=0) (actual time=0.764..0.765 rows=60 loops=1)

  • Index Cond: ((first_name ~~ '%aeb%'::text) AND (last_name ~~ '%aeb%'::text))