explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 73Lg : Optimization for: plan #7TSG

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.563 0.717 ↑ 2,872.0 2 1

Hash Left Join (cost=194.32..19,038.15 rows=5,744 width=233) (actual time=0.479..0.717 rows=2 loops=1)

  • Hash Cond: (orders_document_storage.store_id = s.id)
2. 0.006 0.022 ↑ 2,872.0 2 1

Bitmap Heap Scan on orders_document_storage (cost=136.94..18,514.07 rows=5,744 width=22) (actual time=0.020..0.022 rows=2 loops=1)

  • Recheck Cond: (regexp_replace((((data -> 'data'::text) -> 'shipping_address'::text) ->> 'phone'::text), '[-_() ]'::text, ''::text, 'g'::text) = '0657260055'::text)
  • Heap Blocks: exact=2
3. 0.016 0.016 ↑ 2,872.0 2 1

Bitmap Index Scan on orders_document_storage_stripped_phone (cost=0.00..135.51 rows=5,744 width=0) (actual time=0.016..0.016 rows=2 loops=1)

  • Index Cond: (regexp_replace((((data -> 'data'::text) -> 'shipping_address'::text) ->> 'phone'::text), '[-_() ]'::text, ''::text, 'g'::text) = '0657260055'::text)
4. 0.024 0.132 ↑ 1.0 150 1

Hash (cost=55.50..55.50 rows=150 width=13) (actual time=0.132..0.132 rows=150 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 15kB
5. 0.108 0.108 ↑ 1.0 150 1

Seq Scan on stores s (cost=0.00..55.50 rows=150 width=13) (actual time=0.004..0.108 rows=150 loops=1)

Planning time : 0.837 ms
Execution time : 0.764 ms