bidder explain select from bids where biddate 2019-02-20 and auction_i

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
bidder=# explain 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)
Sort Key: bids_y2019m02d21.biddate
-> Append (cost=0.14..24.49 rows=3 width=552)
-> Index Scan using bids_y2019m02d21_auction_id_idx on bids_y2019m02d21 (cost=0.14..8.16 rows=1 width=552)
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)
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)
Index Cond: ((auction_id)::text = '10181220090030010115017069818DF4'::text)
Filter: (biddate > '2019-02-20'::date)