explain.depesz.com

PostgreSQL's explain analyze made readable

Result: rRgf

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 5,694.480 ↓ 0.0 0 1

Limit (cost=1,000.55..81,824.19 rows=8 width=8) (actual time=5,694.480..5,694.480 rows=0 loops=1)

2. 5,989.779 5,989.779 ↓ 0.0 0 1

Gather Merge (cost=1,000.55..2,607,562.74 rows=258 width=8) (actual time=5,694.477..5,989.779 rows=0 loops=1)

  • Workers Planned: 7
  • Workers Launched: 7
  • -> Parallel Index Scan Backward using purchase_order_date_order_index on purchase_order (cost=0.43..2606531.01 rows=37 width=8) (actual time=5671.9
  • Filter: (((name)::text ~~* '%52185782645%'::text) AND ((company_id IS NULL) OR (company_id = 1)) AND (warehouse_id = 11))
  • Rows Removed by Filter: 553876
Planning time : 6.458 ms
Execution time : 5,989.939 ms