explain.depesz.com

PostgreSQL's explain analyze made readable

Result: IUK8 : b

Settings
# exclusive inclusive rows x rows loops node
1. 4.444 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)

  • -> Index Scan using sales_order_processing_warehouse_created_at_idx on sales_order (cost=0.56..3543.79 rows=186 width=10) (actual time=0.041.
  • 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: 1767
Planning time : 0.278 ms
Execution time : 4.487 ms