explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5x5W

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.044 ↓ 0.0 0 1

Limit (cost=219.56..219.60 rows=15 width=329) (actual time=0.044..0.044 rows=0 loops=1)

  • Buffers: shared hit=4
2. 0.006 0.043 ↓ 0.0 0 1

Sort (cost=219.56..219.60 rows=15 width=329) (actual time=0.043..0.043 rows=0 loops=1)

  • Sort Key: id COLLATE ""C"
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=4
3. 0.037 0.037 ↓ 0.0 0 1

Index Scan using orders__order_batch_id__idx on orders (cost=0.55..219.27 rows=15 width=329) (actual time=0.036..0.037 rows=0 loops=1)

  • Index Cond: ((order_batch_id)::text = 'order-batch-007k18bCiBRF'::text)
  • Filter: (((id)::text > 'order-007k18cfcEBB'::text) AND (side = 'BUY'::order_side))
  • Buffers: shared hit=4
Planning time : 0.255 ms
Execution time : 0.075 ms