explain.depesz.com

PostgreSQL's explain analyze made readable

Result: rT89

Settings
# exclusive inclusive rows x rows loops node
1. 0.007 14.035 ↓ 0.0 0 1

Limit (cost=364.21..381.45 rows=8 width=4) (actual time=14.035..14.035 rows=0 loops=1)

2. 0.008 14.028 ↓ 0.0 0 1

Bitmap Heap Scan on purchase_order (cost=364.21..861.99 rows=231 width=4) (actual time=14.028..14.028 rows=0 loops=1)

  • Recheck Cond: ((name)::text ~~* '%52185782645%'::text)
  • Filter: (((company_id IS NULL) OR (company_id = 1)) AND (warehouse_id = 11))
3. 14.020 14.020 ↓ 0.0 0 1

Bitmap Index Scan on trgm_idx_purchase_order_name (cost=0.00..364.15 rows=446 width=0) (actual time=14.020..14.020 rows=0 loops=1)

  • Index Cond: ((name)::text ~~* '%52185782645%'::text)
Planning time : 4.380 ms
Execution time : 14.232 ms