explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ncPl

Settings
# exclusive inclusive rows x rows loops node
1. 0.007 152.821 ↑ 1.0 50 1

Limit (cost=2,565.93..2,566.05 rows=50 width=36) (actual time=152.811..152.821 rows=50 loops=1)

2. 1.313 152.814 ↑ 12.3 50 1

Sort (cost=2,565.93..2,567.46 rows=613 width=36) (actual time=152.810..152.814 rows=50 loops=1)

  • Sort Key: (similarity(((("user" -> 'first_name'::text) || ' '::text) || ("user" -> 'last_name'::text)), 'Michelle Alves'::text)) DESC
  • Sort Method: top-N heapsort Memory: 31kB
3. 112.234 151.501 ↓ 3.3 1,995 1

Bitmap Heap Scan on orders (cost=196.75..2,545.56 rows=613 width=36) (actual time=40.949..151.501 rows=1,995 loops=1)

  • Recheck Cond: (((("user" -> 'first_name'::text) || ' '::text) || ("user" -> 'last_name'::text)) % 'Michelle Alves'::text)
  • Rows Removed by Index Recheck: 8728
  • Heap Blocks: exact=10336
4. 39.267 39.267 ↓ 17.5 10,723 1

Bitmap Index Scan on trgm_idx_users_full_name (cost=0.00..196.60 rows=613 width=0) (actual time=39.267..39.267 rows=10,723 loops=1)

  • Index Cond: (((("user" -> 'first_name'::text) || ' '::text) || ("user" -> 'last_name'::text)) % 'Michelle Alves'::text)
Planning time : 0.298 ms
Execution time : 152.978 ms