explain.depesz.com

PostgreSQL's explain analyze made readable

Result: NOoI

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

Limit (cost=0.55..56.37 rows=15 width=329) (actual time=0.029..0.029 rows=0 loops=1)

2. 0.028 0.028 ↓ 0.0 0 1

Index Scan using orders__batchid_side_id__index on orders (cost=0.55..56.37 rows=15 width=329) (actual time=0.028..0.028 rows=0 loops=1)

  • Index Cond: (((order_batch_id)::text = 'order-batch-007k18bCiBRF'::text) AND (side = 'BUY'::order_side) AND ((id)::text > 'order-007k18cfcEBB'::text))
Planning time : 0.302 ms
Execution time : 0.055 ms