explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wWxj

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 0.033 ↓ 0.0 0 1

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

2. 0.031 0.031 ↓ 0.0 0 1

Index Scan Backward using orders__batchid_side_id__index on orders (cost=0.55..56.37 rows=15 width=329) (actual time=0.031..0.031 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.233 ms
Execution time : 0.059 ms