explain.depesz.com

PostgreSQL's explain analyze made readable

Result: iVML : a

Settings
# exclusive inclusive rows x rows loops node
1. 0.064 227.624 ↑ 1.0 1 1

Aggregate (cost=30,723.29..30,723.30 rows=1 width=8) (actual time=227.623..227.624 rows=1 loops=1)

2. 4.976 227.560 ↓ 3.4 746 1

Bitmap Heap Scan on sales_order (cost=26,297.08..30,722.73 rows=222 width=10) (actual time=223.815..227.560 rows=746 loops=1)

  • Recheck Cond: ((created_at >= CURRENT_DATE) AND (processing_warehouse = 70))
  • Filter: ((shipping_plan_id = 3) AND ((status)::text <> ALL ('{canceled,holded,doi_thanh_toan,processing}'::text[])))
  • Rows Removed by Filter: 1761
  • Heap Blocks: exact=1919
3. 215.808 222.584 ↓ 0.0 0 1

BitmapAnd (cost=26,297.08..26,297.08 rows=3,991 width=0) (actual time=222.584..222.584 rows=0 loops=1)

  • -> Bitmap Index Scan on idx_processing_warehouse (cost=0.00..24196.85 rows=600399 width=0) (actual time=214.104..214.104 rows=500
4. 6.776 6.776 ↑ 1.2 80,205 1

Bitmap Index Scan on idx_created_at (cost=0.00..2,099.87 rows=99,361 width=0) (actual time=6.775..6.776 rows=80,205 loops=1)

  • Index Cond: (created_at >= CURRENT_DATE)
  • Index Cond: (processing_warehouse = 70)
Planning time : 0.334 ms
Execution time : 235.596 ms