explain.depesz.com

PostgreSQL's explain analyze made readable

Result: IUK8 : b

Settings
# exclusive inclusive rows x rows loops node
1. 0.061 4.444 ↑ 1.0 1 1

Aggregate (cost=3,544.26..3,544.27 rows=1 width=8) (actual time=4.444..4.444 rows=1 loops=1)

2. 4.383 4.383 ↓ 4.0 748 1

Index Scan using sales_order_processing_warehouse_created_at_idx on sales_order (cost=0.56..3,543.79 rows=186 width=10) (actual time=0.041..4.383 rows=748 loops=1)

  • Index Cond: ((processing_warehouse = 70) AND (created_at >= CURRENT_DATE))
  • Filter: ((shipping_plan_id = 3) AND ((status)::text <> ALL ('{canceled,holded,doi_thanh_toan,processing}'::text[])))
  • Rows Removed by Filter: 1,767
Planning time : 0.278 ms
Execution time : 4.487 ms