explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CBDK

Settings
# exclusive inclusive rows x rows loops node
1. 0.007 2,620.544 ↑ 1.0 50 1

Limit (cost=218,091.41..218,091.54 rows=50 width=36) (actual time=2,620.535..2,620.544 rows=50 loops=1)

2. 1.885 2,620.537 ↑ 16.3 50 1

Sort (cost=218,091.41..218,093.45 rows=814 width=36) (actual time=2,620.534..2,620.537 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. 2,618.652 2,618.652 ↓ 3.4 2,755 1

Seq Scan on orders (cost=0.00..218,064.37 rows=814 width=36) (actual time=0.090..2,618.652 rows=2,755 loops=1)

  • Filter: (((("user" -> 'first_name'::text) || ' '::text) || ("user" -> 'last_name'::text)) % 'Michelle Alves'::text)
  • Rows Removed by Filter: 811,292
Planning time : 0.139 ms
Execution time : 2,620.574 ms