explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xE6z

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 3.703 ↓ 0.0 0 1

Limit (cost=149.18..166.92 rows=8 width=4) (actual time=3.703..3.703 rows=0 loops=1)

2. 0.003 3.701 ↓ 0.0 0 1

Bitmap Heap Scan on purchase_order (cost=149.18..570.53 rows=190 width=4) (actual time=3.701..3.701 rows=0 loops=1)

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

Bitmap Index Scan on trgm_idx_purchase_order_name (cost=0.00..149.13 rows=378 width=0) (actual time=3.698..3.698 rows=0 loops=1)

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