explain.depesz.com

PostgreSQL's explain analyze made readable

Result: FI8v

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 7,138.928 ↓ 0.0 0 1

Limit (cost=0.00..22,956.33 rows=8 width=4) (actual time=7,138.928..7,138.928 rows=0 loops=1)

2. 7,138.925 7,138.925 ↓ 0.0 0 1

Seq Scan on purchase_order (cost=0.00..545,212.81 rows=190 width=4) (actual time=7,138.925..7,138.925 rows=0 loops=1)

  • Filter: (((name)::text ~~* '%52185782645%'::text) AND ((company_id IS NULL) OR (company_id = 1)) AND (warehouse_id = 11))
  • Rows Removed by Filter: 3777132
Planning time : 0.765 ms
Execution time : 7,138.965 ms