explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7TSG

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.493 40,512.500 ↑ 2,872.0 2 1

Nested Loop Left Join (cost=0.14..122,290.31 rows=5,744 width=233) (actual time=384.248..40,512.500 rows=2 loops=1)

2. 40,511.981 40,511.981 ↑ 2,872.0 2 1

Seq Scan on orders_document_storage (cost=0.00..120,687.75 rows=5,744 width=22) (actual time=383.995..40,511.981 rows=2 loops=1)

  • Filter: (regexp_replace((((data -> 'data'::text) -> 'shipping_address'::text) ->> 'phone'::text), '[-_() ]'::text, ''::text, 'g'::text) = '0657260055'::text)
  • Rows Removed by Filter: 1148787
3. 0.026 0.026 ↑ 1.0 1 2

Index Scan using stores_pkey on stores s (cost=0.14..0.20 rows=1 width=13) (actual time=0.011..0.013 rows=1 loops=2)

  • Index Cond: (orders_document_storage.store_id = id)
Planning time : 1.979 ms
Execution time : 40,512.680 ms