begin transaction
SELECT nextval('seq_order_id') as orderId
SELECT * FROM orders WHERE accountid = ? AND status IN (3, 7)
INSERT INTO orders (orderid, ... )
end transaction
g_benchmark=# explain analyze select * from orders where accountid=1000001 and status IN (3,7);
QUERY PLAN
---------------------------------------------------------------------------------------------------------------------------------
Index Scan using index_orders_accountid on orders (cost=0.00..9.37 rows=1 width=250) (actual time=3.179..3.179 rows=0 loops=1)
Index Cond: (accountid = 1000001)
Filter: ((status = 3) OR (status = 7))
Total runtime: 3.254 ms
(4 rows)
-------------------
Runtimes
Each run time figure is the time to complete the the above transaction for the number of specified times (serially - one after another)'
1: elapsed time: 0.032 sec
100: elapsed time: 1.643 sec
1000: elapsed time: 16.441 sec