explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Qpkk : sort80

Settings
# exclusive inclusive rows x rows loops node
1. 0.007 5,366.819 ↓ 1.5 3 1

Limit (cost=504,115.54..504,115.54 rows=2 width=8) (actual time=5,366.816..5,366.819 rows=3 loops=1)

2. 0.000 5,366.812 ↓ 1.5 3 1

Sort (cost=504,115.54..504,115.54 rows=2 width=8) (actual time=5,366.811..5,366.812 rows=3 loops=1)

  • Sort Key: date_order DESC
  • Sort Method: quicksort Memory: 25kB
3. 14.175 5,373.846 ↓ 1.5 3 1

Gather (cost=5,000.00..504,115.53 rows=2 width=8) (actual time=322.568..5,373.846 rows=3 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
4. 5,359.671 5,359.671 ↑ 1.0 1 5

Parallel Seq Scan on purchase_order (cost=0.00..499,115.33 rows=1 width=8) (actual time=2,571.701..5,359.671 rows=1 loops=5)

  • Filter: (((name)::text ~~* '%02268%'::text) AND ((company_id IS NULL) OR (company_id = 1)) AND (warehouse_id = 70) AND (((state)::text <>
  • Rows Removed by Filter: 755426
Planning time : 40.865 ms
Execution time : 5,374.115 ms