explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yX7i

Settings
# exclusive inclusive rows x rows loops node
1. 0.010 2,182.439 ↑ 1.0 1 1

Bitmap Heap Scan on orders (cost=267.65..271.66 rows=1 width=355) (actual time=2,182.439..2,182.439 rows=1 loops=1)

  • Recheck Cond: (((account_id)::text = 'W62243246CAD'::text) AND ((order_batch_id)::text = 'order-batch-007k18bCiBRF'::text))
  • Filter: ((average_fill_price_currency)::text = 'CAD'::text)
  • Heap Blocks: exact=1
2. 0.164 2,182.429 ↓ 0.0 0 1

BitmapAnd (cost=267.65..267.65 rows=1 width=0) (actual time=2,182.429..2,182.429 rows=0 loops=1)

3. 3.439 3.439 ↑ 14.1 33 1

Bitmap Index Scan on orders__account_id_status__index (cost=0.00..24.05 rows=465 width=0) (actual time=3.439..3.439 rows=33 loops=1)

  • Index Cond: ((account_id)::text = 'W62243246CAD'::text)
4. 2,178.826 2,178.826 ↓ 33.5 172,804 1

Bitmap Index Scan on orders__batchid_side_id__index (cost=0.00..243.34 rows=5,153 width=0) (actual time=2,178.826..2,178.826 rows=172,804 loops=1)

  • Index Cond: ((order_batch_id)::text = 'order-batch-007k18bCiBRF'::text)
Planning time : 0.167 ms
Execution time : 2,182.473 ms