explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5ZdJ

Settings
# exclusive inclusive rows x rows loops node
1. 0.036 4.145 ↑ 1.0 250 1

Limit (cost=0.57..251,734.30 rows=250 width=355) (actual time=0.063..4.145 rows=250 loops=1)

  • Buffers: shared hit=850
2. 4.109 4.109 ↑ 164.0 250 1

Index Scan using orders_new__pkey on orders (cost=0.57..41,293,394.48 rows=41,009 width=355) (actual time=0.062..4.109 rows=250 loops=1)

  • Index Cond: ((id)::text > 'order-007k18cfcEBB'::text)
  • Filter: (((order_batch_id)::text = 'order-batch-007k18bCiBRF'::text) AND (side = 'BUY'::order_side))
  • Rows Removed by Filter: 453
  • Buffers: shared hit=850
Planning time : 0.272 ms
Execution time : 4.195 ms