explain.depesz.com

PostgreSQL's explain analyze made readable

Result: OAPV

Settings
# exclusive inclusive rows x rows loops node
1. 0.010 1,801.899 ↑ 1.0 50 1

Limit (cost=137,686.64..137,692.47 rows=50 width=100) (actual time=1,795.012..1,801.899 rows=50 loops=1)

2. 14.957 1,801.889 ↑ 10.2 50 1

Gather Merge (cost=137,686.64..137,746.14 rows=510 width=100) (actual time=1,795.011..1,801.889 rows=50 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 0.156 1,786.932 ↑ 12.1 21 3 / 3

Sort (cost=136,686.62..136,687.25 rows=255 width=100) (actual time=1,786.928..1,786.932 rows=21 loops=3)

  • Sort Key: (similarity(COALESCE(((("user" -> 'first_name'::text) || ' '::text) || ("user" -> 'last_name'::text)), (((shipping_address -> 'first_name'::text) || ' '::text) || (shipping_address -> 'last_name'::text))), 'Devin Marsh'::text)) DESC
  • Sort Method: quicksort Memory: 26kB
4. 1,786.776 1,786.776 ↑ 11.6 22 3 / 3

Parallel Seq Scan on orders (cost=0.00..136,676.42 rows=255 width=100) (actual time=178.684..1,786.776 rows=22 loops=3)

  • Filter: (COALESCE(((("user" -> 'first_name'::text) || ' '::text) || ("user" -> 'last_name'::text)), (((shipping_address -> 'first_name'::text) || ' '::text) || (shipping_address -> 'last_name'::text))) % 'Devin Marsh'::text)
  • Rows Removed by Filter: 204258
Planning time : 0.274 ms
Execution time : 1,801.955 ms