bidder EXPLAIN ANALYZE select from bids where biddate 2019-02-20 and a

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
bidder=# EXPLAIN ANALYZE select * from bids where biddate > '2019-02-20' and auction_id='10181220090030010115017069818DF4';
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------------------------
Append (cost=0.14..24.49 rows=3 width=552) (actual time=0.041..0.079 rows=3 loops=1)
-> Index Scan using bids_y2019m02d21_auction_id_idx on bids_y2019m02d21 (cost=0.14..8.16 rows=1 width=552) (actual time=0.039..0.045 rows=2 loops=1)
Index Cond: ((auction_id)::text = '10181220090030010115017069818DF4'::text)
Filter: (biddate > '2019-02-20'::date)
-> Index Scan using bids_y2019m02d22_auction_id_idx on bids_y2019m02d22 (cost=0.14..8.16 rows=1 width=552) (actual time=0.018..0.020 rows=1 loops=1)
Index Cond: ((auction_id)::text = '10181220090030010115017069818DF4'::text)
Filter: (biddate > '2019-02-20'::date)
-> Index Scan using bids_y2019m02d23_auction_id_idx on bids_y2019m02d23 (cost=0.14..8.16 rows=1 width=552) (actual time=0.009..0.009 rows=0 loops=1)
Index Cond: ((auction_id)::text = '10181220090030010115017069818DF4'::text)
Filter: (biddate > '2019-02-20'::date)
Planning time: 0.860 ms
Execution time: 0.211 ms
(12 rows)
bidder=# EXPLAIN ANALYZE select * from bids where biddate > '2019-02-20' and auction_id='10181220090030010115017069818DF4' order by biddate;
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------------------------------
Sort (cost=24.52..24.53 rows=3 width=552) (actual time=0.139..0.141 rows=3 loops=1)
Sort Key: bids_y2019m02d21.biddate
Sort Method: quicksort Memory: 27kB
-> Append (cost=0.14..24.49 rows=3 width=552) (actual time=0.027..0.096 rows=3 loops=1)
-> Index Scan using bids_y2019m02d21_auction_id_idx on bids_y2019m02d21 (cost=0.14..8.16 rows=1 width=552) (actual time=0.025..0.030 rows=2 loops=1)
Index Cond: ((auction_id)::text = '10181220090030010115017069818DF4'::text)
Filter: (biddate > '2019-02-20'::date)
-> Index Scan using bids_y2019m02d22_auction_id_idx on bids_y2019m02d22 (cost=0.14..8.16 rows=1 width=552) (actual time=0.044..0.045 rows=1 loops=1)
Index Cond: ((auction_id)::text = '10181220090030010115017069818DF4'::text)
Filter: (biddate > '2019-02-20'::date)
-> Index Scan using bids_y2019m02d23_auction_id_idx on bids_y2019m02d23 (cost=0.14..8.16 rows=1 width=552) (actual time=0.017..0.017 rows=0 loops=1)
Index Cond: ((auction_id)::text = '10181220090030010115017069818DF4'::text)
Filter: (biddate > '2019-02-20'::date)
Planning time: 0.628 ms
Execution time: 0.236 ms
(15 rows)